Topics
Started by
Posts
Last post
Hello, Upon executing the following code I get this error: ----------------------------------------…
5 replies
Hi Can someone please help me with this? Raw Data ID StartDate DEP EndDate 1 14/02/2011 A 14/…
9 replies
I have two statements (below) that do two different things.--With Terminations SELECT ----DATEPART(…
8 replies
Is it possible to have this query do a distinct count of each orglevel? SELECT ----DATEPART(YEAR, …
4 replies
Hi, I wonder if anyone can explain the following: I have a table that has a column [unique_name] de…
11 replies
Hi, i have a table like below Create Table tab1 ( RefNo varchar(10), Version int, details varc…
13 replies
I already have the sp written but it is really ugly, I want to rewrite it, can anyone help? I have …
7 replies
Hello, I was given a task to have a query which gets the information from the xml data in a table f…
5 replies
The following indicates that xp_cmdshell works like expected: declare @sqlcmd varchar(200) SET @sql…
3 replies
LOAD DATA LOCAL INFILE 'C:\\Documents and Settings\\J03299\\Desktop\\TMETER.csv' INTO TABLE edata C…
2 replies
Hi, i am finding an issue where in if we take the profiler data and executes in SSMS the SP execute…
4 replies
Can you use a variable with a view? I have a view that joins 5 tables, one of which is an OpenQuery…
8 replies
hi i need script or function or procedure to get field's name has data difference and get this data…
2 replies
I see that this topic has generated a lot of discussion. I am also in a situation where I want to d…
2 replies
Hi all I have a table that holds order details in columns. eg. OrderNo, Prod1, Prod2, Prod3........…
2 replies
Viewing 15 topics - 1,111 through 1,125 (of 12,234 total)
You must be logged in to create new topics.