Topics
Started by
Posts
Last post
I have a problem with SPs which were working fine but now due to larger xml data output, it is show…
2 replies
Hi i have following table (very big table) columns ID , CODE ,............................... value…
5 replies
Hi Guys, I am having a small problem with the query which I have written. Here is the sample query …
1 replies
I need to order 2 columns on a 10m+ row table with no indexes, and the query I have runs about 8 m…
6 replies
Hello experts I have a numeric(9,4) columnA and the users need an output like below. COLUMNA …
18 replies
Hi all - here's my situation: SELECT ID, COUNT(*) FROM User JOIN project ONID = UserID AND D…
5 replies
We have a ticketing system where people close their individual assignments but they forget to close…
4 replies
i'm in the process of customizing a backup monitoring system from one of the articles here. http://…
2 replies
According to BOL: Searched CASE function: Evaluates, in the order specified, Boolean_expression fo…
13 replies
I'm inserting a record and one its of columns need to be the Hash Value (varchar(32)).. Anyone know…
5 replies
Hi Folks, I wonder if you can help. I have written a query in SQL management studio which writes da…
3 replies
i have a table of datetime vals. I need to get only the distinct dates (don't care about times) &#…
7 replies
[font="Courier New"]This script below renders job name -AND- average duration for each job. (The A…
3 replies
Hi All I have created a table as shown below Create table #temp (ID int,Levelid int, v…
3 replies
Hi I am trying to capture the Stored Procedure call executed by a report. When executing my TestPr…
4 replies
Viewing 15 topics - 4,696 through 4,710 (of 12,230 total)
You must be logged in to create new topics.