i want to create a table with query

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

i want to create a table with query

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2003-02-11 : 21:16:05

Shailesh writes "i want to make a table of this query at run time in crystal report..like access
SELECT [TblTransSplitWork].[ThrProcess],
[TblTransSplitWork].[SplitWorkName], [TblMstRABill].[WorkId],
[TblMstRABill].[RABillAmount], [TblTransMlaMp].[MlaTrId],
[TblTransMlaMp].[ConstId], [TblTransMlaMp].[MLAType],
[TblMstRABill].[RABillNo],
[TblMstContPayment].[VchDate]
FROM (TblTransMlaMp INNER JOIN
((TblMstRABill INNER JOIN
((TblMstWorkOrder INNER JOIN
TblMstAggrement ON
[TblMstWorkOrder].[AggId] = [TblMstAggrement].[AggId])
INNER JOIN
TblTransSplitWork ON
[TblMstAggrement].[TransSplitId] = [TblTransSplitWork].[TransSplitId])
ON [TblMstRABill].[WorkId] = [TblMstWorkOrder].[WorkId])
INNER JOIN
TblRptSite ON
[TblTransSplitWork].[RptId] = [TblRptSite].[RptId]) ON
[TblTransMlaMp].[MlaTrId] = [TblRptSite].[MlaTrId]) INNER JOIN
TblMstContPayment ON
([TblMstRABill].[RABillNo] = [TblMstContPayment].[RABillNo])
AND ([TblMstRABill].[ContId] = [TblMstContPayment].[ContId])
WHERE TblTransSplitWork.ThrProcess = 'DPDC'"

ValterBorges
Master Smack Fu Yak Hacker

1429 Posts

Posted - 2003-02-11 : 22:32:05

access does not make tables of queries you have to tell it to make a table.

Not sure what you mean make a table in crystal report.

However,
If you want to create a table based on this query

you could use a temp table and do the following

SELECT [TblTransSplitWork].[ThrProcess],
[TblTransSplitWork].[SplitWorkName], [TblMstRABill].[WorkId],
[TblMstRABill].[RABillAmount], [TblTransMlaMp].[MlaTrId],
[TblTransMlaMp].[ConstId], [TblTransMlaMp].[MLAType],
[TblMstRABill].[RABillNo],
[TblMstContPayment].[VchDate]
INTO #TempTable
FROM (TblTransMlaMp INNER JOIN
((TblMstRABill INNER JOIN
((TblMstWorkOrder INNER JOIN
TblMstAggrement ON
[TblMstWorkOrder].[AggId] = [TblMstAggrement].[AggId])
INNER JOIN
TblTransSplitWork ON
[TblMstAggrement].[TransSplitId] = [TblTransSplitWork].[TransSplitId])
ON [TblMstRABill].[WorkId] = [TblMstWorkOrder].[WorkId])
INNER JOIN
TblRptSite ON
[TblTransSplitWork].[RptId] = [TblRptSite].[RptId]) ON
[TblTransMlaMp].[MlaTrId] = [TblRptSite].[MlaTrId]) INNER JOIN
TblMstContPayment ON
([TblMstRABill].[RABillNo] = [TblMstContPayment].[RABillNo])
AND ([TblMstRABill].[ContId] = [TblMstContPayment].[ContId])
WHERE TblTransSplitWork.ThrProcess = 'DPDC'"

or maybe you want to create a view.

Please clarify your question.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources