Topics
Started by
Posts
Last post
Hi, I cannot use ORDER BY clause in view unless TOP is specified. Without using top I get following…
3 replies
I have a production table called 'County2' with the following columns: CountyID (identity), [Name],…
2 replies
Hi, I need to randomly assign values to a column in a table. I need to update a column in a table w…
6 replies
can I have composite index on identity column? Regards - JL
1 replies
i am just stuck in a simple and complex query.. i hope that one of you will surly help me.. i have …
5 replies
In the Latin1_General collation, ss is treated like ß (German sharp s) in comparisons: 'ss' = 'ß' -…
5 replies
CREATE PROCEDURE CsatDataPull_SP_DP AS IF EXISTS (SELECT 1 FROM SYS.SYSOBJECTS WHERE NAME = 'AllReq…
1 replies
Hi, Replicating a procedure that exists on our legacy system which takes a letter template, perfor…
6 replies
I have a column c1 in a table T1, there is another table t2 with column c2. I am required to prepar…
3 replies
while running below statement in SQL server 2005 getting error message Ambiguous column name 'firs…
14 replies
I wanted to calculate the date difference between first row and the second row in the same table. I…
8 replies
Hi, I have this procedure, that does a lot of processing, from an input file. It loads the file, do…
11 replies
DECLARE @idoc int DECLARE @doc varchar(1000) SET @doc =' ' --Create an internal representation o…
1 replies
I have a stored procedure that does a simple calculation based on a case statement. When I run the …
2 replies
Hi to all I just want to information is that Applying the transaction objects in Stores procedure …
3 replies
Viewing 15 topics - 8,941 through 8,955 (of 12,230 total)
You must be logged in to create new topics.