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...

Your welcome. Just to follow-up though, do you know why I made the suggested change in your WHERE...

He should be able to if he takes the time to read your article. That is where I came up with the idea for this solution.

😎

Can any of the values in the denominator be negative, or are all values greater than or equal to zero?

😎

I'd do the following instead (notice change in the where clause):

select

UniqueID,

sum(case termcd when 'BM' then 1 else 0 end) as BM,

...