I exclusively use LEFT JOINs. 😛

Cadavre +1 for a very clever solution.

dirtyshorellc (8/9/2012)

---

My appologies.

What I am doing is creating a query that will simply take certain columns from a table and export them to a csv file for export to another...

Phil Parkin (8/14/2012)

---

patrickmcginnis59 (8/14/2012)

---

Shadab Shah (8/12/2012)

---

Jeff Moden (8/10/2012)

---

Shadab Shah (8/9/2012)

---

Hi all,

I have come across various section on this website where it is mention that SQL Server is a set based...

SQLKnowItAll (8/14/2012)

---

So I set up a quick test using this setup:

USE test

GO

CREATE TABLE testStringReplace (string VARCHAR(250))

INSERT INTO testStringReplace

SELECT TOP 500000 c1.name + '%' + c1.name + '%'

FROM sys.columns c1

CROSS JOIN...

Playing around with PATINDEX, which is the closest thing you'll find to REGEX (except the CLR REGEX functions of course), I come up with something like this:

;WITH SampleData (string) AS...

Here's another approach:

;WITH Summary AS (

SELECT Account, Year=DATEPART(year, [Date]), Summary=SUM(Summary)

FROM #Accounts

GROUP BY Account, DATEPART(year, [Date]))

SELECT a.Account, [Date], Amount,...

Evil Kraig F (8/13/2012)

---

Jeff Moden (8/13/2012)

---

Evil Kraig F (8/10/2012)

---

Not that I don't admire Jeff's abilities, but he doesn't speak the language sometimes... or better stated, he speaks the language of...

Patterning after the quoted article, the solution for your data is as follows:

CREATE TABLE #testtab(

ID INT, DocID INT, MilestoneID INT,...

Peter Brinkhaus (8/12/2012)

---

Assuming that the TradeID column is unique (primary key?), why not use a UNION ALL instead of UNION. This avoids a (expensive) distinct sort to filter out nonexisting...

A little basic formatting would go a long way to improving readability:

IF LTRIM(rtrim(@PostCode)) <> ''

BEGIN

select @ParameterList = '' -- Not used anywhere

...

Wow! I'm glad I took the weekend off. Gave you guys a chance to get it all sorted out.

Lynn Pettis (8/11/2012)

---

CELKO (8/11/2012)

---

A reflex on my part. I assume that...

Gosh! If you're gonna use the VARCHAR(20) version of @Holder, you should at least use this version of DWAIN's:

REVERSE(1*REVERSE([Column] * 1))

Many good examples in BOL: http://msdn.microsoft.com/en-us/library/ms345137(v=sql.90).aspx

Another way I've used it is to construct an XML document for passing into a SP, although if I were to do it over again...