David Emerson
davide at dalyn.co.nz
Wed Sep 10 20:58:46 CDT 2003
I have also tried the following but with the same error message -
SELECT GateIDNo, MaxMDQ, OldMDQDate
FROM (SELECT GateIDNo, MAX(MDQ) AS MaxMDQ, MAX(MDQDate) AS OldMDQDate
FROM dbo.tblGateStationMDQ
WHERE MDQ <> 0
GROUP BY GateIDNo
HAVING (MAX(MDQDate) < '20031001'))
David
At 11/09/2003, you wrote:
>I am trying to use a select statement as the source of another select
>statement in a Sproc.
>
>The following statement works -
>
>SELECT GateIDNo, MAX(MDQ) AS MaxMDQ, MAX(MDQDate) AS OldMDQDate
> FROM dbo.tblGateStationMDQ
> WHERE MDQ <> 0
> GROUP BY GateIDNo
> HAVING (MAX(MDQDate) < '20031001')
>
>But when I do the following -
>
>SELECT @qs = 'SELECT GateIDNo, MaxMDQ, OldMDQDate
> FROM (SELECT GateIDNo, MAX(MDQ) AS MaxMDQ, MAX(MDQDate) AS OldMDQDate
> FROM dbo.tblGateStationMDQ
> WHERE MDQ <> 0
> GROUP BY GateIDNo
> HAVING (MAX(MDQDate) < ''20031001''))'
>
>I get the following error -
>
>Server: Msg 170, Level 15, State 1, Line 6
>Line 6: Incorrect syntax near ')'.
>
>Using Print (@qs) I get -
>
>SELECT GateIDNo, MaxMDQ, OldMDQDate
> FROM (SELECT GateIDNo, MAX(MDQ) AS MaxMDQ, MAX(MDQDate) as OldMDQDate
> FROM dbo.tblGateStationMDQ
> WHERE MDQ <> 0
> GROUP BY GateIDNo
> HAVING (MAX(MDQDate) < '20031001'))
>
>Any suggestions?
>
>Regards
>
>David Emerson
>DALYN Software Ltd
>25b Cunliffe St, Johnsonville
>Wellington, New Zealand
>Ph/Fax (877) 456-1205
>_______________________________________________
>dba-SQLServer mailing list
>dba-SQLServer at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
>http://www.databaseadvisors.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/dba-sqlserver/attachments/20030911/6ca8d2f4/attachment.html>