Topics
Started by
Posts
Last post
All, This is driving me crazy. It should be easy but is giving me multiple records per day. Pleas…
19 replies
Hi, I need to calculate a rank column. Just assume following result and my desire rank column. Plea…
3 replies
Hi Friends, I have one result set which is as below. --------------------Run below script in your q…
7 replies
Hi, I have a parent-child relationship as under: 1 Node1 0 2 Child1_1 1 3 Child2_1 1 4 Node2 …
5 replies
All, I have a scenario. Step1 : User will pass delimited values. Step2 : I used 'Tally' table to sp…
11 replies
All, I just started to work to replace a cursor in a function. My goal is to use SET BASED techniqu…
26 replies
Hi Friends, Need your help.... please run below script in ur query window. -------------------…
5 replies
I posted this in another forum(SQL 7.2) and realized it was in the wrong location... I have a table…
7 replies
Hi, I am running query in sql 2005 and its taking tool ong to finish. I have to run query for my mo…
12 replies
All, I tried to see IO cost for a function. I ran the function like SET STATISTICS IO ON SELECT dbo…
1 replies
/* the question is how to delete 30-140 from tb1, get the result: nbe x1020 x3160 x141200 f…
2 replies
Msg 1776, Level 16, State 0, Line 1 There are no primary or candidate keys in the referenced table …
1 replies
I inherited some SQL logic that I need to alter. The SQL employs LEFT OUTER JOINS extensively to p…
2 replies
Hi All, I made one observation, i just need to confirm with you folks if my assumptions are correct…
2 replies
Hi, I have 2 tables both of them have large number of rows. I need to select the recent updated row…
3 replies
Viewing 15 topics - 3,646 through 3,660 (of 12,234 total)
You must be logged in to create new topics.