Topics
Started by
Posts
Last post
I'm trying to get my head around PIVOT. I understand the syntax and have successfully written a PIV…
1 replies
Hi all I have the following table: CREATE TABLE usTab1 ( Col1 INT IDENTITY(1,1) NOT NULL PRIMA…
12 replies
I have two tables, one with the original data, and a migrated one in need of fixing. The migrated …
4 replies
Following the advice given in this thread, I'm trying to extract data from XML in a hierarchy - th…
2 replies
Return the number of sales by product category where the average recommended price is R10 or more g…
4 replies
Ok, what am I missing here? I have the following code sample on which I expect one of the queries t…
1 replies
By: lk4772
Hi there I have a challenge where I need some help. May someone can help me? I have a table where a…
7 replies
Hi, I've a table with a fulltext index and when I search for an exact phrase I get a result but whe…
5 replies
By: PiMané
So there's a trick I've used a few times with the ORDER BY clause in SQL, and I was just curious if…
18 replies
Hi, I have this XML file. It's my first time trying to load one. It has three levels, and for some …
5 replies
Hi, What the best way to check if a record exists and at get a column from it to use? DECLARE @ord…
4 replies
By: PiMané
Hi All, I have RATE and SHIFT columns in a table as mentioned below. When I pass RATE=1 then I g…
14 replies
By: T.Ashish
I have two separate tables in my database ReportCategories and Reports. I am trying to determine h…
4 replies
I have a fairly simple need to place a text file on in a directory from a query. BCP seemed the be…
2 replies
Hi all, Running SQL 2012 BI on a spanky new server with 2690 x 2 CPU, fast SSD, ramdisk for tempdb …
10 replies
By: psingla
Viewing 15 topics - 4,606 through 4,620 (of 4,984 total)
You must be logged in to create new topics.