Using a variable in a query 1

[DataFanatic]

I am trying to use a field in a table to provide the variable for this query. I get an error: "The column prefix 'tblvdte' does not match with a table name or alias name used in the query."
I have searched the error and found little to aid me.
Here is the query:

declare @rundte as int
set @rundte = tblvdte.rundte

SELECT cast(SUM(RDSIZE * RDNPPB)+.05 as int) AS SCHED,
cast(SUM(RDSIZE * RDNEPB)+.05 as int) AS Prod
FROM RMODELT1 join tblvdte on
rmodelt1.rdpmnm <> tblvdte.rundte

WHERE (RDRSDT = @rundte) AND (RDPMNM < '01999')

Can someone give some direction as to how to accomplish this.

 

[bborissov]

You can't SET a variable to Table field, you could only SELECT it:

declare @rundte as int
SELECT @rundte = tblvdte.rundte FROM tblvdte WHERE ...

SELECT     cast(SUM(RDSIZE * RDNPPB)+.05 as int) AS SCHED,
 cast(SUM(RDSIZE * RDNEPB)+.05 as int) AS Prod
FROM RMODELT1
join tblvdte  on rmodelt1.rdpmnm <> tblvdte.rundte
WHERE     (RDRSDT = @rundte) AND (RDPMNM < '01999')

Borislav Borissov
VFP9 SP1, SQL Server 2000/2005.

 

[DataFanatic]

Borislav
Thanks very much for the response
That works!

I am very new to this stuff and have been getting little bits and pieces from this forum to get to where I am.
If I can impose once again, what would be the best resource to track down these type of questions in syntax etc.

Thanks again for your assistance.

 

[bborissov]

Here
Ask questions, read FAQ. BOL is also a great help.

Borislav Borissov
VFP9 SP1, SQL Server 2000/2005.

 

[DataFanatic]

Borislav, You're right. Here is great. Also the BOL was something I was unaware of. I was searching through the help file and finding nothing. (I now know it was help only for the MMC). What a great journey this will be.

I have implemented things today that are very clear thanks to your assistance. When I figure out how to give you a Star... you will get one.

Thanks again.

 

[bborissov]

Just after my signature there is a signe with somethinh like "Thank bborissov for ..."

Borislav Borissov
VFP9 SP1, SQL Server 2000/2005.

 

[gmmastros]

While in Query Analyzer, you can press F1 to get help on the query analyzer (not very helpful). But, you can press [!]SHIFT-F1[/!] to get to books on line where the sql syntax is explained.

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[DataFanatic]

Thanks for jumping in to offer assistance. You guys are great.