Topics
Started by
Posts
Last post
I have a job which runs a store procedure. The proc is something like BEGIN STEP 1) Archive records…
7 replies
I am trying to call the following user defined function in an update statement but getting an error…
4 replies
Hi, I frequently see code like SELECT @SQL = '' SELECT @SQL = COALESCE(@SQL,'') And then on the f…
2 replies
I have a stored proc as the SQL command text which is getting passed a parameter, which contains a …
5 replies
Howdy everybody, I want to keep 11321 character in field on table SQL Server, but varchar(max) is n…
7 replies
I have received this script for optimization. I really have no clue on how can we optimize an INSER…
3 replies
Hi All, I want to know the tables used inside a Stored Procedure. For ex, CREATE TABLE TABLEB( X IN…
2 replies
I find some statements in the documentation for Merge confusing and potentially misleading, and wou…
8 replies
I have three tables Callog, Asnmnt and Tracker. With the used values for this query below. Cal…
3 replies
I have the following update statement where based on the value for the column in the case statement…
5 replies
from http://technet.microsoft.com/en-us/library/ms177562.aspx Returns the same type as the first …
5 replies
I need to fill column values from preceding row if there is a null value in order to tie back to an…
9 replies
Hi, I have the following table: ID | Val 1 | A 1 | B 1 | C 2 | C 2 | B 2 | A 3 | A 3 …
6 replies
Hi, I have the code written to import my XML files fine. I was trying to turn it into a stored proc…
2 replies
Hi, I need to create a function that will provide me with a checksum to verify my data output. For…
5 replies
Viewing 15 topics - 4,561 through 4,575 (of 4,984 total)
You must be logged in to create new topics.