Viewing 15 posts - 6,346 through 6,360 (of 8,761 total)
Strongly recommend following Luis's suggestion, simple and well tested approach.
😎
For completeness, below is an sample solution which replicates the logic in a query instead of the splitter function.
USE tempdb;
SET...
January 3, 2015 at 7:34 am
Phil Parkin (1/3/2015)
Eirikur Eiriksson (1/3/2015)
Luis Cazares (1/3/2015)
DECLARE @date date = '20140927'
Be careful with the implicit conversion as the results will be depending on the system settings, no guarantee that it...
January 3, 2015 at 3:51 am
Phil Parkin (1/3/2015)
The quote was from the original post & I just wanted to throw this in as an aside, not as a suggested solution...
January 3, 2015 at 2:28 am
Luis Cazares (1/3/2015)
DECLARE @date date = '20140927'
Be careful with the implicit conversion as the results will be depending on the system settings, no guarantee that it will be interpreted as...
January 3, 2015 at 2:23 am
cheryljanicedsouza (1/2/2015)
I need to convert the given data 20140927 into 27 Sept 2014. Plz help. Thanks
Given that the originating data type is not date, the operation is twofold, first...
January 3, 2015 at 2:19 am
Phil Parkin (1/3/2015)
just set @@Identity to a variable and do a second insert statement.
Rather than @@Identity, you would be better off...
January 3, 2015 at 1:47 am
Jeff Moden (1/2/2015)
I could be wrong but that looks like it presupposes what the identities will be.
It doesn't as the output clause retrieves the identity values generated in the first...
January 3, 2015 at 1:38 am
marcia.j.wilson (1/2/2015)
January 2, 2015 at 1:47 pm
Jeff Moden (1/2/2015)
Eirikur Eiriksson (1/2/2015)
Stefan Krzywicki (1/2/2015)
Happy New Year everyone!Who, like me, is at work today?
I must be the saddest (read nerdiest/most pathetic) in this bunch, got the day off...
January 2, 2015 at 1:35 pm
Stefan Krzywicki (1/2/2015)
Happy New Year everyone!Who, like me, is at work today?
I must be the saddest (read nerdiest/most pathetic) in this bunch, got the day off but still spent 10...
January 2, 2015 at 12:21 pm
Jeffery Williams (1/2/2015)
I need...
January 2, 2015 at 12:14 pm
schleep (1/2/2015)
That's working in the back-end Eirikur, thank you!!I have to dump the empty result set into a #tmp table so the front-end doesn't puke, but that's a minor detail.
Quick...
January 2, 2015 at 10:54 am
marcia.j.wilson (1/2/2015)
Eirikur Eiriksson (1/1/2015)
Quick suggestion: Integration Services Data Types😎
Thanks. I had come across that link, but it wasn't quite what I was looking for. I'm looking for something...
January 2, 2015 at 10:42 am
Only the second query which uses 'true' as a predicate has an implicit conversion
😎
<Object...
January 2, 2015 at 10:33 am
Quick thought, don't think that in this case it makes any difference, looked into this quite a while back and I couldn't find any implicit conversion in the execution plan.
😎
January 2, 2015 at 8:18 am
Viewing 15 posts - 6,346 through 6,360 (of 8,761 total)