Topics
Started by
Posts
Last post
I was given a task to find out overlapping indexes and disable from my db....can any one show me th…
7 replies
I'm struggling to find a graceful way to concatenate 3 string values from a record, separated by da…
8 replies
Hi there. Here is the data, I think it explains itself: DECLARE @t TABLE (custID int, module t…
4 replies
Apologies for the length of the code here. Like many others here i regularly enter Jacob Sebastians…
7 replies
create table #MyTest ( Duration int, EndDuration ); insert into #MyTest ( Duration, …
7 replies
0288 INV0000083073 217.08000 0288X2 RESALE INV0000083063 229.00000 051…
11 replies
I've run into this a few times - I have TableA that has a very large volume of rows added to it and…
1 replies
Is there any script which returns the stored procedure names in db which are never or rarely used? …
12 replies
difference between after trigger & instead of trigger?
2 replies
dear sql guru, kindly look into my problem i have a table as mentioned in sample code below it code…
9 replies
Hi there. I'm new to pivot tables. I have the following pivot table and can't figure out how to add…
7 replies
What is the difference between Non-Updateable Views and Updateable Views in SQL server? Please Give…
4 replies
select Distinct ClientIdentifier, sourcesystem, methodtype, voicedatatype ,Count(CASE WHEN …
8 replies
I use this query below that collates all records for that current day, I need to be able to use the…
2 replies
I'm trying to write some code, either a trigger or another monitoring object that watches for a new…
8 replies
Viewing 15 topics - 3,751 through 3,765 (of 12,230 total)
You must be logged in to create new topics.