Viewing 15 posts - 19,981 through 19,995 (of 26,490 total)
You are looking at the code in the wrong way. How did I provide you with everything you needed to test the code I provided?? Now, go back...
July 5, 2009 at 5:02 pm
And if you'd like a hint, it is all done using the dbo.DelimitedSplit function I provided. 😉
July 5, 2009 at 4:58 pm
Oh, by the way, I already have a solution ready once you post the setup code.
July 5, 2009 at 4:30 pm
Do you really want our help? If so, please review the code I provided in the SQLTeaserCode.txt file. Once you provide us with what we need in that...
July 5, 2009 at 4:23 pm
WayneS (7/5/2009)
paulneyman (7/5/2009)
Ok, can you write a sample how to do that?
No... we're not here to do your work for you. We will, however, guide you to find the solution.
As...
July 5, 2009 at 2:00 pm
mjarsaniya (7/4/2009)
sorry
May we ask why you felt compelled to delete the text of your post?
July 4, 2009 at 3:17 pm
luan.wp (7/2/2009)
Hi,What is a solution to optimize the SUM function in SQL, my query is taking more than 4 minutes .. causing a time out.
thanks!
Looks like you've had...
July 4, 2009 at 3:07 pm
Only way I know, and it isn't free, is RedGate SQL Prompt.
July 4, 2009 at 12:35 am
nisha.lakhwara (7/3/2009)
I am facing a problem with the sql 2005 Enterprise.I have installed the enterprize version on windows xp SP2 but i am not able to get access to the...
July 4, 2009 at 12:33 am
WayneS (7/3/2009)
@Lynn - it looks like the beginning of your CTE is missing, and the select from it isn't referencing the CTE. Otherwise, very nicely done.
Opps, I meant to cut...
July 3, 2009 at 3:10 pm
john.arnott (7/3/2009)
Ah, my goodness. I don't think I could have invented a more clear case for the importance of careful use of punctuation. There's a book...
July 3, 2009 at 1:02 pm
What you really need to do is lookup CONVERT in BOL (Books Online, the SQL Server Help System that you can access from SSMS by pressing the {f1} function key).
Here...
July 3, 2009 at 12:35 pm
Before I continue, please verify that the test environment I have created below is at least some what accurate regarding your problem. Please note a couple of things here.
One,...
July 3, 2009 at 12:23 pm
RBarryYoung (7/3/2009)
Lynn Pettis (7/3/2009)
It's just how Eswin changed things and tried...
July 3, 2009 at 10:25 am
Viewing 15 posts - 19,981 through 19,995 (of 26,490 total)