Topics
Started by
Posts
Last post
Hi, Could anyone tell what is wrong with below query which is not producing desired result? Selec…
11 replies
I have a stored procedure that allows for nulls. When selecting data from my tables I normally do …
8 replies
Hi, does anyone have a nice example of an instead of update trigger on a view? e.g. it kicks in wh…
1 replies
I have a SP that accepts 2 parms an Int and a Char(5). EXEC@return_value = [dbo].[_Chuck] @PlanI…
5 replies
I have a routing table with a route ID, sort order, and employeeID, and route status. Users of the…
10 replies
I am sure this task can be accomplished with many variations. I run a call center that services e…
2 replies
Hi All, [p]As i ran some DMV scripts to get server scope - Disk related IO information. I got the c…
1 replies
Hi all, I am trying to make a HTTP post to a URL, sending a simple XML struct as the posting data, …
2 replies
Hi all, I noticed that whenever I run the bcp command, Example: EXEC master..xp_cmdshell 'echo test…
2 replies
Hi, Im using a select in sp_send_dbmail to provide the body of my email but I am also getting the r…
3 replies
I'm trying to convert a cursor in a stored procedure (that updates a table variable) into a CTE tha…
2 replies
Is this a legitimate SQL? SELECT ci.IG_SRC_SYS_KEY = CASE WHEN LEFT(ci.IG_CD,1) = 'D' THEN (SELE…
6 replies
if I change a table definiton in Management Studio, it creates a script, that makes a temp table, f…
1 replies
Hi All I am not sure if this can be done, i am using a select statement from a table wi…
12 replies
Hi all, This is probbaly a really daft question...but I can't find an answer, no matter where I loo…
20 replies
Viewing 15 topics - 7,591 through 7,605 (of 12,234 total)
You must be logged in to create new topics.