Glad to be of service.

Phil Parkin (11/13/2013)

---

Hi Dwain, I did consider this. But as the variable in question had a numeric datatype, I could not see how there...

arnipetursson (11/12/2013)

---

When I run the two queries (outer join vs NOT EXISTS),

the outer join query runs in 4-9ms (69 logical IO n the temp tables and 0 scans and...

Lowell (11/12/2013)

---

yeah the whole "exotic' naming convention for non traditional joins started back in 2007...

Excuse me for butting in here, on a job that you seem to indicate is complete.

I strongly advise you reconsider how you're constructing the @sql string. Wherever you've concatenated...

I can give you a real world example that has been simplified that you can look at.

How to Design, Build and Test a Dynamic Search Stored Procedure[/url]

There are 2 tables:...

Exotic JOIN? I think BOL must have forgotten to mention that one. 😛

In the CATCH section of a TRY/CATCH block, you can use ERROR_LINE(), however it returns NULL if there is no current error.

It's been awhile since my high school biology days, but don't inch worms move pretty slow?

Old enough to know better, young enough to give...

Messy indeed!

What I'd try to do second (first I'd try to get the format of the spreadsheet changed into a more homogeneous table). is to read the row of names...

Please excuse me on 2 points then:

- Apparently my question wasn't...

mitzyturbo (11/12/2013)

---

Hi Dwain

Insert Statement:

INSERT INTO [Criteria]

([TeamID]

,[WorkGroup]

...

BTW. I thought this was a really fun problem. Best I've seen on the forums in weeks.

I have an idea for another way to solve it that might...

lmeinke (11/12/2013)

---

On a quick read through I noticed your data type is int. This would drop the leading zeros on many of my skus. When I run this...