SQL SERVER 2000 Dynamic sql is not working 1

[tempo1]

Hi everyone
The code i wrote is:

DECLARE @dynamic VARCHAR(1000)
SET @dynamic=
'
SELECT 
accountno "accountno"
FROM
fiftyplus..contact1
'
print @dynamic
exec @dynamic

not working ! I get an error message saying:

SELECT
accountno "accountno"
FROM
fiftyplus..contact1
Server: Msg 203, Level 16, State 2, Line 10
The name '
SELECT
accountno "accountno"
FROM
fiftyplus..contact1
' is not a valid identifier.

And i cant figure out why ! Can anyone tell me whats wrong
with it ?
Thanks

 

[ptheriault]

try this...

DECLARE @dynamic VARCHAR(1000)
SET @dynamic=
'
SELECT
accountno as accountno
FROM
fiftyplus..contact1
'
print @dynamic
exec @dynamic

- Paul
- If at first you don't succeed, find out if the loser gets anything.

 

[ptheriault]

This will give the same too.

DECLARE @dynamic VARCHAR(1000)
SET @dynamic=
'SELECT accountno 
FROM fiftyplus..contact1'

print @dynamic
exec @dynamic

- Paul
- If at first you don't succeed, find out if the loser gets anything.

 

[tempo1]

Hi ptheriault,
And thanks.
I get the following error message

Could not find stored procedure '
SELECT
accountno,
lastname,
secr,
mergecodes

FROM
contact1
'.

Thanks

 

[gmmastros]

Change:
exec @dynamic

To:
exec [!]([/!]@dynamic[!])[/!]

-George

"the screen with the little boxes in the window." - Moron

 

[tempo1]

Hi gmmastros,
Thanks a lot.
Thats trivial..
I was dealing with something much more complicated and maybe this is what made me forgetting the brackets.. Hopefully this is the reason to all my troubles..