Topics
Started by
Posts
Last post
I am extracting a table into a text file using DTS. I have unique business need to send a trailer …
5 replies
SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO CREATE PROC zCM_SP_GETSU…
3 replies
Calling All Experts: I need help identifying jobs that are currently executing in SQL Server Agent …
3 replies
By: Nilssond
Is there an easy way to reject rows using bulk insert in for it to continue inserting regardless of…
5 replies
Do a view execute everytime it is query by another query? Example, I have a query like this: select…
7 replies
iam writing a stored procedure after a very long time, so iam encountring some silly errors. now d…
1 replies
i have condition like this,in select querey i am also selection one field through diff select query…
3 replies
By: dongadoy
Hi, Is that possible to pass a table to stroed procedure, if yes would please give me one example? …
11 replies
I am trying to find a way to update multiple columns in a table using a select statement. I would l…
5 replies
By: TomT
i am finding duplicates like this SELECT ChstoragelocationCode FROM &n…
3 replies
Currently I have a standard query that passes multiple (dynamic) values(1,2,3,5,6,7,8,9,0,11,12) fr…
3 replies
I've seen multiple examples of how to store a simple hierarchy such as an Org Chart for a company, …
4 replies
I'm trying to pass multiple values from a web app via a single parameter to a stored procedure. I …
2 replies
DECLARE @x VARCHAR(10) SET @x = 'SQL' SELECT * FROM TABLE1 WHERE COL1 = 'SOMETHING' AND COL2 CASE W…
2 replies
Hello All, I getting SSN (hundreds of thousand of rows) from various sources, so there are many cas…
5 replies
Viewing 15 topics - 13,126 through 13,140 (of 17,082 total)
You must be logged in to create new topics.