Viewing 15 posts - 16 through 30 (of 118 total)
It will get very ugly, but this can be done with a conditional split, multiple outputs, lookups, and union alls. Not ideal by any means, but can be done....
March 13, 2013 at 3:26 pm
akshay.thanai (3/8/2013)
I am in need of a solution. I am supposed to load the data of a table from PROD server to UAT. If records are missing in UAT, load...
March 12, 2013 at 3:09 pm
Use the Merge, of those 3.
March 11, 2013 at 3:12 pm
The SQL Developer position is heads above the other position for career development and growth. Just a ballpark guess here, but my guess is you'll learn more in a...
March 4, 2013 at 2:17 pm
My advice is to create an individual package for each dimension and fact table. This makes it easier from a maintenance, troubleshooting, and auditing standpoint for a multitude of...
March 4, 2013 at 2:03 pm
Yes, there are a lot of jobs that demand those skills - but it is difficult to get your foot in the door without prior experience. That's kind of...
March 1, 2013 at 12:09 pm
Give me a few months and I'll be able to share the frustration! Still waiting on approval for my 2012 Enterprise license. 😀
February 28, 2013 at 1:35 pm
Use an environment variable.
February 28, 2013 at 10:21 am
If the name doesn't change then I would just hardcode the name of the file into a variable and feed that through with a derived column. But I prefer...
October 11, 2012 at 2:11 pm
Thanks a lot - I feel like a shmuck. I'm not too familiar with datetime2 and thought I was looking at 1912 data - not 12 AD! LOL...
July 20, 2012 at 12:51 pm
Ok, I apologize in advance. It is giving me an out-of-range error on the following type of values:
0012-12-01 00:00:00
0015-01-01 00:00:00
0020-01-01 00:00:00
0010-12-01 00:00:00
0016-08-01 00:00:00
0016-01-01 00:00:00
0018-12-01 00:00:00
0015-12-01 00:00:00
July 20, 2012 at 11:39 am
dcdanoland (7/20/2012)
The following code converts datetime2(0) to datetime:
Declare@SomeDateTime2_0datetime2(0)
Declare@SomeDateTimedatetime
Set@SomeDateTime2_0='2012-01-01 00:00:00'
Set@SomeDateTime=Convert(date, @SomeDateTime2_0)
Select@SomeDateTime2_0As[@SomeDateTime2_0],
@SomeDateTimeAs[@SomeDateTime]
The result is the following resultset:
@SomeDateTime2_0@SomeDateTime
2012-01-01 00:00:002012-01-01 00:00:00.000
This works, but not when trying to select from a dynamic dataset.
July 20, 2012 at 11:33 am
Actually - my error is:
Msg 242, Level 16, State 3, Line 1
The conversion of a datetime2 data type to a datetime data type resulted in an out-of-range value.
July 20, 2012 at 11:31 am
Viewing 15 posts - 16 through 30 (of 118 total)