So, trying to read minds here based on the posts so far, you want something like this?

begin transaction

select

*

from

Production.Product with (UPDLOCK)

where

...

I guess I am still lost on what you are trying do.

😎

mtassin (5/20/2008)

2. SQL isn't a programming language. It is a set based Data Manipulation Language, last I checked you couldn't pause a stored procedure in the middle to ask...

Actually, it came down to this, your WHERE clause would not make use of an index on the date field if available, where as the change I made would allow...

How about showing us what you are trying to do? Your code, table DDL, sample data, and expected output.

😎

So, based on this discussion ALL programming languages should then throw an error if there is a truncation occuring due to attempting to pass a string value that is larger...

I guess we are expected to be mind readers here. Of course, if we were, we'd all be VERY SUCCESSFUL CONTRACTORS commanding TOP DOLLAR! :hehe:

Not here, unfortunately...

😎

Use what works best. I just thought I'd throw another way to do it your way.

😎

lol... Of course, how many times has that turned out to be NOT what they want. There...

As this is SQL Server 2005, how about this:

select

EmpID,

EmpName,

Pin

from

dbo.Table1

except

select

EmpID,

...

I took Gail's code and made some changes. Go ahead and check it out.

create table #Temp(

...

To expand on Jeff Moden's post. You will need to use the Execute Process Task. You will need a Zip utility with a command-line capability.

😎

Do the following as well:

sp_configure 'show advanced options', 1

go

reconfigure

go

sp_configure

go

Check the value for Default Language. If the run value is 0, then it is set to us_english. You then...

Shark Energy (5/20/2008)

---

Can anyone expand on this a little? It's most annoying. The developers aren't using yyyymmdd so I have to try and work out why the current environment is...

John Rowan (5/19/2008)

---

Good solution Lynn. For some reason, I was thinking that the termcd values were not all known, hence the need for a pivot as I was actually...