The...

Like this:

DROP TABLE #Tbl1

DROP TABLE #Tbl2

DROP TABLE #Tbl3

CREATE TABLE #Tbl1 ([sid] int, cid int)

CREATE TABLE...

But Nabha's query works...

CREATE TABLE #ticket_history (id INT,...

Lynn Pettis (12/10/2009)

---

Grasshopper (aka sk.panda ),

Would like a correct answer or just shots in the dark?

If you want a correct answer, please read and follow the instructions in this article[/url]...

Depends if the code failed on the sample using the #table,...

Interesting - from BOL "Character literals and variables are assigned the default collation of the current database". So the default collation of your db is different to that of the...

There was an irresistable whiff of buffalo chips in the air...

--Transaction Table

CREATE TABLE #INBOUND_PLM_CHCM (PER_NR INT, [STATUS] INT, SOC_MAPPING VARCHAR(10))

INSERT INTO #INBOUND_PLM_CHCM (PER_NR, [STATUS], SOC_MAPPING)

SELECT 12345, 0, 'PLM-5000'...

if IPC.STATUS=CHCM.INCOMING_DATA then CHCM.OUTGOING_DATA AS 'STATUS'

else the condition does not satisfy then display IPC.STATUS

You've specified an INNER JOIN in your query. You will never see when the "condition does not...

Rob-350472 (12/10/2009)

---

I've been playing around with this, and come up with this, which seems to work:

DECLARE loop_cursor CURSOR

FOR

SELECT id, type FROM tblA WHERE id < 100

OPEN loop_cursor

DECLARE...

Sure...read this[/url]

Run this:

SET DATEFORMAT DMY

DROP TABLE #Temp

CREATE TABLE #Temp (ProductId INT,

ValiFrom DATETIME, ValidTO DATETIME,

ProductDescription CHAR(3), CountryCode CHAR(2), OpenDate DATETIME)

INSERT INTO #Temp (ProductId, ValiFrom, ValidTO, ProductDescription, CountryCode, OpenDate)

SELECT 123, '01/01/2008',...

Hi Arun

Can you precisely define the rules which determine that this row:

123 30/11/2009 07/12/2009 NULL NULL 15/09/1998

should be updated to this:

123 30/11/2009 07/12/2009 WWW GB 15/09/1998

And so on for the...

Slightly different to Thomas' solution:

SELECT rp.StartDate, SUM(productionVolume) AS totalVolume

FROM @productionData pd

INNER JOIN @reportPeriods rp

ON pd.productionDate >= rp.StartDate

AND pd.productionDate < rp.EndDate

GROUP BY rp.StartDate

ORDER BY rp.StartDate

You're not very familiar with LEFT JOIN's then?

Nothing beats a little testing - try them for yourself.

All of the different conditions which have come up in this thread.

It scales very poorly. It works fine, just don't try it on large tables.