Topics
Started by
Posts
Last post
Hi, I have a stored procedure, which would fire "n" number of queries which have a function …
2 replies
I have a big problem, I need to export data to a flat file using a stored procedure (not my first c…
3 replies
hi there, anyone can help formating string/number like string 1 to 0001 string 2 to 0002 etc thx b4
3 replies
Hi All, Firstly sorry if i have posted in the wrong forum here, i'm new to this place so go easy! I…
17 replies
Table_A col_a = \server1\joeblow, janedoe, \server2\jerrydoe Table_B col_b = joeblow, janedoe…
2 replies
Hi, My query is..... DECLARE @t timestamp SET @t=(select @@DBTS) Print @t But the follow…
1 replies
: Hi, I have a string in field (in any table). Suppose string is -- 'I Love India'(string can be of…
4 replies
I have inherited a sql 2005 cluster and am far from a dba. I am trying to understand the below sp..…
2 replies
Hi, I have an excel worksheet - sheet 1 renamed as 'test' I am trying to use openrowset in my sele…
2 replies
I am struggling with the HAVING clause trying to get a row selected using the max function.&nb…
4 replies
Hi I am creating SP's for my Team to use when we run analysis jobs. i.e. Table audit scripts, check…
1 replies
Have a stored procedure with a single input parameter that returns a data set from an linked Oracle…
7 replies
hi all my select statement is something like this select name from table result is O'Shea O'Connor …
1 replies
I have renamed an old table with a backup name and created a new table with the original name of th…
2 replies
I read an article the other day that advised against the use of the NOT IN and NOT EXISTS statement…
3 replies
Viewing 15 topics - 12,106 through 12,120 (of 12,234 total)
You must be logged in to create new topics.