problem with a stored procedure

[inarobis]

Hello guys,

I have a problem with a stored procedure in sql server.

I would like to execute this query

declare @sSQL varchar(255)


SET @sSQL =
'SELECT TOP 1 [value], date, name, [times]
FROM (SELECT value, date, times, name
FROM view
WHERE ValueDate =
(SELECT MAX(date) AS maxdate
FROM view v
WHERE (date BETWEEN ''2006-02-01'' AND ''2006-02-28''))) Newtable
WHERE (name = ''TEST'')
GROUP BY [value], date, [times], name
ORDER BY [times] DESC'

EXEC (@sSQL)

When I execute the query I have no problem but ... when i tried to stored it I have this several problem I do not know why ... something like

Line 4: Incorrect syntax near '='

I would like be able to pass variable on it and create function to store the results in a table.

Please someone could help me on that.

Ina

 

[vongrunt]

varchar(255) is not big enough...

------
[small]select stuff(stuff(replicate('<P> <B> ', 14), 109, 0, '<.'), 112, 0, '/')[/small]

 

[inarobis]

and nvarchar is better?

 

[SQLDenis]

>>and nvarchar is better?
No for 1 byte of varchar you need 2 bytes of nvarchar
just make it varchar(8000)

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[vongrunt]

Yup.

Run print @sSQL instead of EXEC and you'll see statement is not complete. That's because it is longer than 255 characters... SELECT LEN(yourcode) actually returns 552.

------
[small]select stuff(stuff(replicate('<P> <B> ', 14), 109, 0, '<.'), 112, 0, '/')[/small]

 

[inarobis]

Thank you I did it... and it works