Viewing 15 posts - 11,281 through 11,295 (of 15,376 total)
nishantshende-532951 (7/20/2012)
Thanks for the reply...I am inserting data into temporary table so there is no question of indexes.
But where is the data coming from? It is very likely that the...
July 20, 2012 at 9:24 am
bdloving 4446 (7/20/2012)
Careful, none of the answers given test for your Date requirement!
That's because the best we could do is pseudocode, we never got any ddl to work with. I...
July 20, 2012 at 9:12 am
Steve Jones - SSC Editor (7/20/2012)
July 20, 2012 at 8:05 am
Mountain Steve (7/20/2012)
July 20, 2012 at 7:44 am
Where did you hear that? There is no truth to that at all. It doesn't even make sense. Why would the optimizer care which order they are in? It is...
July 20, 2012 at 7:36 am
tibrize (7/20/2012)
Answer of the question is wrong !!
Nope, you typed it wrong. 😛 The very last query is a UNION and you have UNION ALL
select @@VERSION
create table #t1 (col...
July 20, 2012 at 7:28 am
I don't quite get what you are doing but doing inserts into a hierarchy like this is pretty straight forward.
July 20, 2012 at 7:19 am
To take a little different approach to the discussion, you should NEVER design your tables based on what you want in a report. Design your tables in such a way...
July 19, 2012 at 4:06 pm
Here is a link to Paul's article about APPLY.
Understanding and Using APPLY (Part 1)[/url]
Understanding and Using APPLY (Part 2)[/url]
This a great set of articles and totally opened my eyes on...
July 19, 2012 at 2:52 pm
No worries. It will fall off the radar soon enough. 🙂
July 19, 2012 at 2:42 pm
Lynn Pettis (7/19/2012)
Sean Lange (7/19/2012)
I wish there was something I could do for you to thank you for all your time on this.
This is just so great.
I think you just...
July 19, 2012 at 2:19 pm
Looks like this was posted in the wrong category (per the OP). Please direct all replies there. http://www.sqlservercentral.com/Forums/Topic1332538-1292-1.aspx
July 19, 2012 at 2:12 pm
I wish there was something I could do for you to thank you for all your time on this.
This is just so great.
I think you just did. 😀
Most of us...
July 19, 2012 at 2:10 pm
chetan_28patel (7/19/2012)
I want to use function to change data type from decimal to date field without adding any extra columnI just want to update column only
You need to explain a...
July 19, 2012 at 1:38 pm
dtopicdragovic (7/19/2012)
Actually I like this idea of 1 table with flags 'U', 'D' etc.Thanks again for all these suggestions and ideas. I learn a lot today.
DD
You are welcome. Hope your...
July 19, 2012 at 1:31 pm
Viewing 15 posts - 11,281 through 11,295 (of 15,376 total)