Viewing 7 posts - 1 through 7 (of 7 total)
I would assume an invalid character as well. Start with SELECT TOP 10, and if that works, TOP 100, then TOP N, etc. Once you find a record...
November 20, 2013 at 2:03 pm
Lynn Pettis (4/26/2013)
Start with your original post and the three sample records you provided. Does this recurse forever?What is your expected results based on those three sample records?
Lynn is...
April 26, 2013 at 3:38 pm
1. what are the min and max values in the table? (the ranges for the data types is why it could be a concern--> http://msdn.microsoft.com/en-us/library/ms187347.aspx)
2. try assigning...
April 26, 2013 at 3:05 pm
Use SSIS.
Add a loop (don't forget to increment your date)
Within the loop add a dataflow task. The source should be OLEDB. in the source you can specify the...
April 26, 2013 at 3:00 pm
Just for fun... do this...
;WITH cte_OBS AS (
SELECT CAST(OBSVALUE AS datetime) AS OBSVALUE
FROM OBS
WHERE ISDATE(OBSVALUE) = 1
)
SELECT OBSVALUE
into dbo.temperic_OBSVals
FROM cte_OBS
once the table is created,...
April 26, 2013 at 2:51 pm
Yes is will work when the "= 3" is put back.
December 1, 2009 at 10:15 am
Sample data would help a lot, but this may help. Maybe it will at least give you an idea.
selectA.Col1,
A.Col2,
A.Col3,
SUM(A1.total) as [current_month],
SUM(A2.total) as [current_month-1],
SUM(A3.total) as [current_month-2]
fromviewV1 as A
LEFT JOIN...
September 14, 2009 at 2:52 pm
Viewing 7 posts - 1 through 7 (of 7 total)