Topics
Started by
Posts
Last post
Hi I Have A Table with 6 columns. Select count(*) from ( Select Column1,Column2,Count(*) From Table…
3 replies
Hello. I have a table that contains several duplicate rows. I would like to remove the duplicates…
7 replies
Consider the below T-SQL CREATE TABLE Temp10(Source nvarchar(50),Target nvarchar(50),Property1 int…
6 replies
I have written a stored procedure like USE [nxnv1_temp] GO /****** Object: StoredProcedure [dbo].[S…
2 replies
I'd like to put the data in table #Things into a normalized structure. Table #NewThings represents …
8 replies
In an sql server 2008 r2 database, I have one column that I need to separate the values. I then ne…
2 replies
Is possible to get this '2013-08-15 07:41:37.000' to this format --->>> '2013-08-01 00:…
1 replies
I need a little help my fella SQL DBA I need a ddl trigger script to prevent user from update/delet…
12 replies
Hi SSC, I’m doing some testing on index fragmentation and I wanted to re-build (or reorganize) some…
3 replies
Hey Guys, I am trying to convert this loop to a set based query. Here is what I have so far --LOOP …
9 replies
This has the potential to become a long-winded post. I hope I can keep it short but still provide a…
10 replies
I'm trying to get a running count of the rows in this table so that rows that have the same id also…
16 replies
XML RETRIEVAL ISSUE DUE TO Foriegn Lanuage I have a function to retrieve an xml element from a colu…
3 replies
I have a table to scan and on each record to execute stored procedure. This procedure returns a val…
9 replies
Hi, I was putting together some demo scripts to show bad query estimation however it appears that I…
6 replies
Viewing 15 topics - 2,806 through 2,820 (of 10,647 total)
You must be logged in to create new topics.