Basic troubleshooting I'd follow:

Check your SQL logs

Check your Windows logs

Run SQL Profiler against the DB (save results to file or table)

If you can, restore a copy of the suspect DB...

SQLKnowItAll (4/26/2012)

---

Pam Brisjar (4/26/2012)

---

I have a side by side install (2005 and 2008) as noted above. But yeah, I suspect it felt it was "helping" me as I had 2005...

I have a side by side install (2005 and 2008) as noted above. But yeah, I suspect it felt it was "helping" me as I had 2005 installed.

Yup, that did it.

Now why in the world would they do something like that...

Oy.

LEFT() is going to get you everything from the start fo the string to the count you specify. So

DECLARE @STR VARCHAR(9)

SET @STR = '123456789'

SELECT LEFT(@str,3)

will...

Oooh, nice.

Thanks.

Bogged down in a lot of muck and brain's on overload.

SQLKnowItAll (4/2/2012)

---

DECLARE @auth_id INT

SET @AUTH_ID = 95385

SELECT UPPER(cpt4_id)

FROM #outpatient_service os1

INNER JOIN

(SELECT MIN(key_id) AS min_key_id

...

Data is correct. Each auth_id can have 1 - many entries in the #outpatient_service table.

For every auth in #TRANS, I need to get the first cpt entered based on...

When I need to do this within SSIS, I place the code within an SP and call that SP from SSIS. OPENQUERY itself doesn't work that well from SSIS. There...

Data Warehousing | Integration Services

http://www.sqlservercentral.com/Forums/Topic1265061-364-1.aspx

basic pseudocode:

INSERT INTO [table1]

(

...

See my response to your other post (the one in the Data Warehouse group). I posted an example of doing a join between openquery and a SQL Server table.

With the...

To consolidate and repeat what has been said above, if you are using OPENQUERY, you must use:

SELECT *

FROM OPENQUERY(LSCTLRDAT1, 'SELECT * FROM Company WHERE EFF0YR = ''112'' AND EFF0MO =...

No problemo, Sean. But I do agree with you that we need to see the exact query that's producung the error. After all, I could be wrong 😎

Not necessarily. I've seen DB2 do some strange things with data type mismatches.

You sure that particular column is a character type not a numeric?