Topics
Started by
Posts
Last post
Am using below stored procedure to display alpha-numeric sequence numbers. CREATE PROCEDURE tsp_alp…
6 replies
Hi everyone, We have a server, which has SQL SERVER 2008 R2,periodically we face with high CPU usag…
3 replies
Hi I have this code: SELECT [Policy_Id] = SNAP.POLICY_ID ,[Mex_Id] = FR.INV_PTF_NAME ,[Rebate_Amou…
1 replies
Hello We did an upgrade to SQL2008R2 last night and the query below seems to take an excessive tim…
9 replies
create procedure outname @Cont Int, @Nm Nvarchar (100) output as select @Nm=FirstName from Adventur…
1 replies
Team - Friday night is turning bad for me... One of my SPs was taking forever and after a long haul…
7 replies
All, I have recently read Jeff Moden's Multiple space into one space article and i saw M's reply on…
27 replies
Want to display 12.35 instead of 12.347777
2 replies
Is there a way using SQl to add Identity (500,1) to an existing column? For existing records, keep…
7 replies
I have two separate Insert and Update stored procedures and I am looking for a way to add a Variabl…
7 replies
I have a reindex job that seems to get into a deadly lock with an application. Essentially, on the …
8 replies
[font="Arial Black"]Regarding this book:[/font] Beginning T-SQL with Microsoft SQL Server 2005 and …
2 replies
Hi, I'm doing some testing with dynamic filtering and order by clause. I'm comparing dynamic SQL vs…
18 replies
Anyone knows in a stored procedure that has code like below: .... set @TranCount = @@trancount if n…
6 replies
I think that I'm having a end of the week, mind meltdown kind of moments. I have a table that has …
3 replies
Viewing 15 topics - 5,011 through 5,025 (of 10,640 total)
You must be logged in to create new topics.