-- generate a row for every unit bought / sold.

-- I guess this could be adapted to use the least common denominator

-- Another possibility is to use an iTVF (inline...

dbowlin (9/8/2010)

---

This really got me thinking. Instead of the beep/sound that windows makes when you make a mistake or do something fairly rediculuous. It should insult you....

seshireddy524 (9/8/2010)

---

hi i am generating primary key with identity 10 and i am incrementing by 10.Unfortunatly the order takes place like 10,50,60.so now i want to place them in order...

Please adjust either the third query or the sample data so that the third query returns a row:-

IF OBJECT_ID( 'tempdb..#Sample') IS NOT NULL DROP TABLE #Sample

CREATE TABLE #Sample (RowID INT,...

Your "key" filter is to include...

richard.kirby (9/7/2010)

---

Thanks Chris - looks a lot neater - the only problem I have is that the innermost select fails as the AppointmentDate field where I'm setting some date parameters...

sharonmtowler (9/7/2010)

---

when the sp was created, distinct was neccessary. table has been cleaned up since.

i use all the fields in the report,

replication date is a date field when...

Lynn Pettis (9/7/2010)

---

Wanted, one word term for lazy and obnoxious OP.

Received a PM from a newbie (noobie, no posts as of yet) asking for help. Told him to post...

CirquedeSQLeil (9/7/2010)

---

Sleep sleep. Everybody...

-- do your date arithmetic up front

DECLARE @StartToday DATETIME

SET @StartToday = DATEADD(dd, DATEDIFF(dd, 0, GETDATE()), 0)

SELECT @StartToday

-- no more DISTINCT: which row would you pick from the dupes?

-- If...

Hi Sharon

I think this query can be simplified quite a bit. First though, a couple of questions. Is the DISTINCT necessary, and if so why?

What datatype is the column REPLICATION_DATE?

What...

Here's a nice APPLY version:

SELECT d.EmployeeName,

d.Id,

TicketNumbers = STUFF(iTVF.TicketNumbers, 1, 1, SPACE(0))

FROM @Tab d

CROSS APPLY

(SELECT ',' + CAST(HelpdeskTicketNo AS VARCHAR)

FROM @Tab

WHERE id = d.id...

It's not as simple as changing...

Yeah I know and it's not even wednesday yet.

You will get much quicker answers if you post table creation / data insertion scripts as follows:

CREATE TABLE #tblImage (

ImageID int IDENTITY(1,1) NOT FOR REPLICATION NOT NULL,

[Image] image NOT NULL,

[FileName]...