Viewing 15 posts - 49,966 through 49,980 (of 59,078 total)
rbarryyoung (6/16/2008)
Ugh. How many times a week can we get the "String concatenation" question? We need some FAQ or permanent link that we can just send people to.
Heh......
June 17, 2008 at 12:21 am
boyfriend-alex (6/16/2008)
It works well.
By the way can i ask one thing more?
In this query....
for xml path('')
What is it for ? What do i have to...
June 17, 2008 at 12:20 am
rbarryyoung (6/16/2008)
Select * from Table2Where IsNumeric(JoinColumn) = 0
Maybe... or maybe not... 😉
DECLARE @Varchar VARCHAR(10)
DECLARE @Numeric NUMERIC
SET @Varchar = '$1.00'
SET @Numeric ...
June 17, 2008 at 12:07 am
Master the basics, then go for the gold...
June 16, 2008 at 11:58 pm
Heh... Ya know... some of these posts just reminded me of something... I shouldn't get upset about folks writing code to solve the "Time to Market" problem... I make more...
June 16, 2008 at 11:37 pm
Tech_Newbie (6/16/2008)
June 16, 2008 at 10:34 pm
Thanks, Navket... I appreciate the feedback.
If you really want to see something that replaces the loop or a cursor, take a look at the following...
http://www.sqlservercentral.com/articles/Advanced+Querying/61716/
June 16, 2008 at 10:04 pm
Stephanie Giovannini (6/16/2008)
Outstanding job, Stephanie! 🙂
June 16, 2008 at 9:58 pm
GSquared (6/16/2008)
I have some examples where hardware was a solution. See if you agree with them:
Yes... we did something similar at work... we changed from SQL Server Standard Edition...
June 16, 2008 at 9:38 pm
HYDNIZ (6/16/2008)
June 16, 2008 at 9:27 pm
Outstanding... thanks for the feedback, Matt. And, I'm sorry... I didn't realize that you were already beating the distinct drum on the usage of the function...
June 16, 2008 at 9:10 pm
Basically, explain what you did here and expound upon how this technique can be applied elsewhere... you will be successful...
http://www.sqlservercentral.com/Forums/Topic511356-61-1.aspx
June 16, 2008 at 9:07 pm
karthikeyan (6/16/2008)
I have to give a presentation to my manager, my manager's manager, again, his manager ( upto 3 level) over my tuning work tomorrow.
What have you done in the...
June 16, 2008 at 9:04 pm
TheSQLGuru (6/16/2008)
Jeff, I have referenced the Running Totals thread at least 10 times now on various MS forums, including the MVP private one.
Thank you for the awesome honor,...
June 16, 2008 at 8:56 pm
Viewing 15 posts - 49,966 through 49,980 (of 59,078 total)