Viewing 15 posts - 9,931 through 9,945 (of 13,874 total)
dawnbrown243 (5/7/2013)
May 8, 2013 at 1:11 am
visu.cts2012 (5/8/2013)
May 8, 2013 at 12:53 am
dg227 (5/7/2013)
May 7, 2013 at 7:53 am
This is probably what you meant by "I can program the loading process in another way, I know." but to remove most of the doubt I like to code extracts...
May 7, 2013 at 5:58 am
SteveEClarke (5/7/2013)
Have a sandwich .... have a drink .... come back ....
Only to...
May 7, 2013 at 5:47 am
OK - forgot about that. But at least you can change the date bit. The error message suggests that that is where your problem is occurring.
May 7, 2013 at 5:34 am
SteveEClarke (5/7/2013)
I am trying to acheive two fields, one with a DATE in and the second with a TIME in, for an audit log.
That's what my code does.
May 7, 2013 at 5:25 am
Why not avoid the datatype conversions completely?
declare @Today date
declare @NowTime time
select @Today = getdate()
,@NowTime = getdate()
select @Today
...
May 7, 2013 at 5:19 am
manibad (5/6/2013)
sgmunson (5/6/2013)
May 6, 2013 at 11:15 pm
pmcquirk 96901 (5/6/2013)
May 6, 2013 at 11:10 pm
OK, I see what you are getting at, thanks. I still cannot see why that causes a formatting problem when outputting though.
May 6, 2013 at 9:23 am
Learner093 (5/3/2013)
May 6, 2013 at 7:29 am
sgmunson (5/6/2013)
May 6, 2013 at 7:20 am
Steve Shurts (5/6/2013)
May 6, 2013 at 5:55 am
Hi Wayne.
Nice article, thank you.
Can you explain what you mean by: "...you can specify what the server is change all the variables at one place simply" please - it...
May 5, 2013 at 11:36 pm
Viewing 15 posts - 9,931 through 9,945 (of 13,874 total)