135 reputation
5
bio website
location
age
visits member for 2 years, 1 month
seen Jul 2 '13 at 8:23

Aug
23
awarded  Popular Question
Nov
13
awarded  Supporter
Nov
13
comment Select the newest data (inner join + group by maybe)
Thanks, the row_number() function was exactly what I was looking for
Nov
13
accepted Select the newest data (inner join + group by maybe)
Nov
13
asked Select the newest data (inner join + group by maybe)
Oct
27
awarded  Scholar
Oct
27
accepted Save data to variable and use it in stored procedure
Oct
26
comment Save data to variable and use it in stored procedure
Sorry I have asked bad question I mean what to do if I have somthing like this set @q ='SELECT MAX(Date) FROM MyTable' because I have to build the query as a string because the name of MyTable changes according to some paramters. So how could I get the Date when I have the string of query?
Oct
26
comment Save data to variable and use it in stored procedure
And is it possible to use this syntax even if the SELECT MAX(Date) FROM MyTable is in variable, because this query is built according to some other parameters
Oct
26
awarded  Editor
Oct
26
comment Save data to variable and use it in stored procedure
sorry I forgot to write it. It's sql server 2008 R2
Oct
26
revised Save data to variable and use it in stored procedure
added 26 characters in body; edited tags
Oct
26
awarded  Student
Oct
26
asked Save data to variable and use it in stored procedure
Sep
21
asked SQL fulltext accent insensitive