Things usually get quiet in these forums at this time of year.

Query the From and To dates into a single column, using a Union statement. I don't know the structure of your table, so can't help much with the details....

You're welcome.

WayneS (12/27/2010)

---

GSquared (12/27/2010)

---

The first part is easy. It can be done in one Insert...Select if you just use the Row_Number() function.

IF OBJECT_ID(N'tempdb..#Numbers') IS NOT NULL

DROP TABLE #Numbers;

CREATE TABLE #Numbers...

I must be missing something if this won't work:

DECLARE @imported BIT;

SELECT @imported = null;

SELECT *

FROM #M_Vendor

WHERE DailysettlementYN = @imported

OR @imported IS NULL;

Change the value of the variable, as if it...

Stephen, you do realize this question was from May, 2 years ago (2009), right?

WayneS (12/27/2010)

---

If it will always be the first two characters that you want removed, just use the STUFF function:

declare @str varchar(500);

set @str = '| hello | world | I love...

He used to post on ExpertSexchange (sorry, I still...

Yeah, that's SQL 2008 R2. It's not a patch, it's an upgrade, and that means you have to buy licenses for it and install them from media (disk or...

CELKO (12/27/2010)

---

Common mistake, made by newbies who did not finsih readign their first SQL book 😀

SQL has a CASE expression and think it is a CASE statement. Expressions return...

You're welcome.

SELECT LEFT(UserDesc, PATINDEX('%reports to%', UserDesc)-2)

from UserNames;

Change:

select * from TableB where fname not in (select fname2 from TableA)

To:

select * from TableB where fname not in (select fname2 from TableA where fname2 is not null)

See if that...

The first part is easy. It can be done in one Insert...Select if you just use the Row_Number() function.

IF OBJECT_ID(N'tempdb..#Numbers') IS NOT NULL

DROP TABLE #Numbers;

CREATE TABLE #Numbers (Number INT...

Kit G (12/27/2010)

---

Richard Warr (12/24/2010)

---

Merry Christmas (and a Happy New Year) to all!

Kit, I loved your song. I guess the UK has a higher proportion of atheists than the US...