Viewing 15 posts - 1 through 15 (of 598 total)
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...
May 9, 2012 at 1:45 pm
SQLKnowItAll (4/26/2012)
Pam Brisjar (4/26/2012)
April 26, 2012 at 5:14 pm
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.
April 26, 2012 at 5:02 pm
Yup, that did it.
Now why in the world would they do something like that...
Oy.
April 26, 2012 at 2:14 pm
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...
April 4, 2012 at 7:32 am
Oooh, nice.
Thanks.
Bogged down in a lot of muck and brain's on overload.
April 2, 2012 at 11:51 am
SQLKnowItAll (4/2/2012)
DECLARE @auth_id INTSET @AUTH_ID = 95385
SELECT UPPER(cpt4_id)
FROM #outpatient_service os1
INNER JOIN
(SELECT MIN(key_id) AS min_key_id
...
April 2, 2012 at 11:35 am
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...
April 2, 2012 at 11:26 am
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...
March 15, 2012 at 8:07 am
Data Warehousing | Integration Services
http://www.sqlservercentral.com/Forums/Topic1265061-364-1.aspx
basic pseudocode:
INSERT INTO [table1]
(
...
March 12, 2012 at 5:24 pm
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...
March 12, 2012 at 2:17 pm
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 =...
March 12, 2012 at 1:51 pm
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
March 12, 2012 at 1:23 pm
An implicit conversion of '112' to any numeric datatype would not be a problem.
Not necessarily. I've seen DB2 do some strange things with data type mismatches.
March 12, 2012 at 1:07 pm
You sure that particular column is a character type not a numeric?
March 12, 2012 at 12:56 pm
Viewing 15 posts - 1 through 15 (of 598 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy