Topics
Started by
Posts
Last post
I have a S.P. written like this create proc my_sp @p1 varchar (20) = 'Default', @p2 v…
4 replies
Working on a stored proceedure that will select a random row in the table, update it as "won" and a…
8 replies
I think I'm encountering a fundamental gap in my understanding of index fragmentation, and I'm hopi…
4 replies
/* I have SQL that identifys overlaps in employee assignments and places the overlapped rows into t…
9 replies
Hi, is there any script that can check row by row values for comparing the data is it in order or n…
6 replies
I'm using a derived table (see the following code) to retrieve a unique smalldatetime value from a …
3 replies
Hello everyone, DECLARE @MyTable TABLE ( RowID bigint, RowKey int, Locale varchar(10), Descr n…
31 replies
Hi friends, I am having one table which is having startdate and enddate for one work. Now enddate m…
8 replies
Hi Guys.. Does anyone see a problem with the following update query? The last time i ran it, i kill…
13 replies
Hi, I'm writing a series of scripts that will make a copy of my database. So far I have all of the …
2 replies
I have the following dynamic sql that adds a second to a timestamp and then adds quotes with the qu…
3 replies
Hi I have a requirement such that I should insert a new record if there is no entry for a particu…
5 replies
How can i change to other database using command. In stored procedure I am unable to write "USE Dat…
2 replies
I'm new here, so i this is in the wrong forum I apologize. Question: Let's say I have two columns. …
2 replies
I'll try to explain this in the simplest why I can, what I am really after is why the IF/ELSE code …
10 replies
Viewing 15 topics - 8,866 through 8,880 (of 12,234 total)
You must be logged in to create new topics.