In sql server and in Azure the field that was causing the issue was a nvarchar(255), but the field coming back from salesforce was a numeric(10,0), so in my UDTT...

but if...

Doing that just gives me a total of 30029.35, both parts and labor added together, I need them separate fields/columns

Parts 27791.85 labor 2237.50

This is what I'd want my output to be.

From:

JRH-681 Daytona 2079347 2012-01-17 06:36:22.897 Labor 2237.5

JRH-681 Daytona 2079347 2012-01-17 06:36:22.897 Parts 27791.85

To:

JRH-681 Daytona 2079347 2012-01-17 06:36:22.897 Labor 2237.5 Parts 27791.85

...

Thanks jaya53, I'll give that a try on Monday.

But, in all to get it working for my boss to view over the weekend I just did.

If @activityStatusID = 1

select..

where

ACS.Discription='Complete'

else if...

I have tried this, but get a

Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when...

Sorry no joy, I tried that.

Also the ACS.Description fields is a nvarchar(80) which is what I set @ActiveStatusID to.

I tried this, and it sort of works, but get a Subquery...

Sorry still no joy, tried that.

I also verified that ASC.Description is a nvarchar 80 so that's what my @ActivityStatusID is now.

and

((

case

when @ActivityStatusID = '1'

then ACS.[Description] = 'Completed'

when @ActivityStatusID <>...

nvarchar(3000) I made it that big because I've been testing all sorts of things. I've tried using an IN rather than = <>.