Topics
Started by
Posts
Last post
I've been wrapping my head around this view that consists of multiple sub queries that are used to …
4 replies
create table #Achievements (Ach_ID INT, Description varchar (30), Bonus_Points int)create table #Pl…
4 replies
Hi, we are experiencing locking issues recently. We use Stored Procedures extensively for our datab…
3 replies
Hi Guys, I have a situation like In CLR Function(.DLL) I need to send one XML parameter comin…
3 replies
The AuditTable contains data from October, 2013 through current. We want to create:Audit2014TableAu…
13 replies
Hello SSC, Ok, I am going to try and explain this. Please bear with me 🙂 I have this stored procedu…
6 replies
My question is listed within the SQL code. IF OBJECT_ID('tempdb..#RX') IS NOT NULL DROP TABLE #RX;…
4 replies
In the remarks section of the MSDN article on the IN Operator a warning is provided:Explicitly incl…
2 replies
Hello Good Morning How to get Last Occurance of % value in the string... please help me with this s…
14 replies
Hi All, I am looking for a solution to partition a list of tables that are over a certain siz…
1 replies
I have sat with this problem for over two weeks now, it is time that I admit defeat. Time for me to…
8 replies
I'm very new to TSQL but my job has expanded to include building some SSRS reports for our CRM envi…
8 replies
Hello could you help me to write this query? I need to update from package.serialnumber the values …
2 replies
Hi Experts, I want to capture all the spid info and their associated queries,lock info till the po…
2 replies
I have a table that is created by a Stored procedure. This itself works fine. A new requirement has…
15 replies
Viewing 15 topics - 676 through 690 (of 4,984 total)
You must be logged in to create new topics.