bizzyjunky (3/15/2011)

---

You are using a right join which is only counting employees that belong to each type.

I suspect you are trying to list all employee types irrespective of whether there...

as I said several posts ago..

if @sql has the sql you want to execute then yes.

In a previous post you said it was only updating one group...

So you showed me the code for your proc, which still doesn't execute your dynamic sql. You still haven't showed what parameters you are sending in. I can't help you...

What is the stored proc code? What parameters are you passing it?

Go look in the other thread. It was all there. You just need to execute your dynamic string.

You said you don't want dynamic sql but that is what this is. Do you want dynamic sql or not?

This is the third of fourth thread where you are basically asking the same thing over and over. People keep asking for details and the best we get is extremely...

Your 2¢ may prevent a lot of hand wrings and hair pulling.

I'm actually doing an upgrade of some software along with SQL changes, so I'm building my SQL...

Just my 2¢, but I would remove it and fix the VB code that is referencing it. If you still have code that is using it you run the risk...

Nice job posting your ddl and data in a consumable format. KUDOS!!!!!!!!!

insert ProductCategory

select ID, CategoryID from product

Is that what you are looking for? Also i assume you are planning...

Try using datalength instead of a hardcoded length. Think that should get you the desired result.

Sounds a lot like homework to me???

Sounds like regional settings are different on these two servers.

Hi and welcome to SSC. We need a little information about what you are trying to do before anybody will be able to help. Please see the link in my...