Thanks Charmer, that did the trick!

The stored procedure selects it.

What is a "simple" result set? I tried modifying the execute SQL task like this:

1) Result Set: Single-Row

2) ConnectionType: OLE DB

3) Connection: SQL table

4) SQLSourceType: Direct Input

5) SQL Statement:...

Haha, I forgot to map the new derived column to the table column. Looks like that method did work!

I just found the issue. Apparently if you divide an integer by an integer the result is an integer. Here is a good explanation and fix:

http://social.msdn.microsoft.com/Forums/en/transactsql/thread/f608a688-0f48-4e81-b183-57e8dfaec641

That you Craig and Fraggle! Your insight was very valuable to me!

Here is how I made this work:

UPDATE C

SET C.Client = D.[Client] FROM dbo.Client_Stage_Test C LEFT OUTER...

Its a data warehouse environment and I want to lay the Client name into the Client field of the table using the crosswalk.

I want to match the table1.Carrier with...

Thanks for everyone's input! I am going to go ahead and switch to full recovery model and do some reading on log shipping and mirroring!

Here was the solution that worked in case somebody else runs into a problem like this. I think the issue was that the UPCs were in the Specialty_UPC table...

I think it's just a little more difficult to manage the servers. I am completely new to this whole "DBA" thing but it has become my responsibility in the...

I don't feel comfortable doing that due to the nature of the data. I understand if you can't help without it. Thanks anyways!!

Below is the entire query. Hopefully this helps!

select

[YearMonth]

,[ID]

,[STATE]

,[ORG_NBR]

,[MEMBERSHIP_CODE]

,column6

,column7

,column8

,CASE WHEN EXISTS((select top 1 MAX(U.UPC) from dbo.Specialty_UPCs AS U WHERE C.UPC...

The only thing I left out was the WHERE clause.

I am still getting the same error with that code 🙁

Like this:??

CASE

WHEN ((select count(distinct MAX(U.UPC)) from dbo.Specialty_UPCs as U where C.UPC = U.UPC) > 0)

...