Viewing 15 posts - 181 through 195 (of 859 total)
T_Dot_Geek (10/24/2012)
Create a new calculated SortID column and add it in order by clauseSELECT TaskID, BaseTaskID, SortID = Case When BaseTaskID = 0 THEN TaskID ELSE BaseTaskID END
order by SortID
thats...
For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]
Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
Jeff Moden's Cross tab and Pivots Part 1[/url]
Jeff Moden's Cross tab and Pivots Part 2[/url]
October 24, 2012 at 2:53 pm
Luis Cazares (10/23/2012)
That's why I recommended the Splitter. It gives a much simpler and more understandable code.I could help with the code, but Asiti should read the articles first.
I will...
For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]
Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
Jeff Moden's Cross tab and Pivots Part 1[/url]
Jeff Moden's Cross tab and Pivots Part 2[/url]
October 23, 2012 at 3:08 pm
can you post DDL and Sample data? While things may seem simple the udf and the the query you are trying and/or the outcome you are trying to get...
For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]
Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
Jeff Moden's Cross tab and Pivots Part 1[/url]
Jeff Moden's Cross tab and Pivots Part 2[/url]
October 22, 2012 at 11:04 pm
ok this gets you almost what i think you want. its something i did as i need to work on rCTE's and pivot tables and with any sort of...
For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]
Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
Jeff Moden's Cross tab and Pivots Part 1[/url]
Jeff Moden's Cross tab and Pivots Part 2[/url]
October 22, 2012 at 3:51 pm
actually sounds more like an unpivot to normalize a data structure.
http://msdn.microsoft.com/en-us/library/ms177410(v=sql.105).aspx at the very bottom is the unpivot
EDIT Forgot url tags
For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]
Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
Jeff Moden's Cross tab and Pivots Part 1[/url]
Jeff Moden's Cross tab and Pivots Part 2[/url]
October 22, 2012 at 2:42 pm
Sean Lange (10/22/2012)
naqib_bs (10/22/2012)
but I am member of administrator user therefore, it...
For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]
Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
Jeff Moden's Cross tab and Pivots Part 1[/url]
Jeff Moden's Cross tab and Pivots Part 2[/url]
October 22, 2012 at 2:32 pm
Well i have an answer but im going to ask what have you tried?
For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]
Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
Jeff Moden's Cross tab and Pivots Part 1[/url]
Jeff Moden's Cross tab and Pivots Part 2[/url]
October 8, 2012 at 3:25 pm
why the requirement not to use a CTE? Sounds like homework or an interview question to me.
EDIT: OP removed the requirement for with out a CTE.
For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]
Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
Jeff Moden's Cross tab and Pivots Part 1[/url]
Jeff Moden's Cross tab and Pivots Part 2[/url]
October 8, 2012 at 3:14 pm
Have a look at the average function http://msdn.microsoft.com/en-us/library/ms177677.aspx
Beyond that if you would like some more help can you please read the first link in my signature about how to post...
For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]
Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
Jeff Moden's Cross tab and Pivots Part 1[/url]
Jeff Moden's Cross tab and Pivots Part 2[/url]
September 28, 2012 at 3:46 pm
SQL Kiwi (9/23/2012)
Phil Parkin (9/23/2012)
Estimated costs for different statements are comparing apples with unicorns
I'm pretty sure that my unicorn will run faster than your apple:-D
Ha, true. There again,...
For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]
Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
Jeff Moden's Cross tab and Pivots Part 1[/url]
Jeff Moden's Cross tab and Pivots Part 2[/url]
September 23, 2012 at 10:13 am
Can you post some sample data that better reflects your setup. The scalar udf can most likely be rewritten into an Inline Scalar Udf (An inline table valued function...
For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]
Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
Jeff Moden's Cross tab and Pivots Part 1[/url]
Jeff Moden's Cross tab and Pivots Part 2[/url]
September 22, 2012 at 6:37 am
Luis Cazares (9/21/2012)
Anyone is going to SQL Saturday 151 in Orlando?I would like to meet some of the people from SSC.
i was just at 154 in St. Louis last weekend....
For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]
Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
Jeff Moden's Cross tab and Pivots Part 1[/url]
Jeff Moden's Cross tab and Pivots Part 2[/url]
September 21, 2012 at 5:56 pm
bitbucket-25253 (9/21/2012)
SQLRNNR
Targeting Joe and baiting him really needs to stop. And the same can be said of anybody else that has been personally attacked or been the recipient of piling...
For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]
Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
Jeff Moden's Cross tab and Pivots Part 1[/url]
Jeff Moden's Cross tab and Pivots Part 2[/url]
September 21, 2012 at 5:53 pm
ok im breaking out my "Realy? WTF" card on the behaviour twards the end of http://www.sqlservercentral.com/Forums/Topic1357081-392-3.aspx. did we really hit Godwin's law?
For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]
Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
Jeff Moden's Cross tab and Pivots Part 1[/url]
Jeff Moden's Cross tab and Pivots Part 2[/url]
September 21, 2012 at 9:03 am
glad im starting to learn c#. i knew deep down that c# was the way to go but this simiple example shows me im right.
For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]
Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
Jeff Moden's Cross tab and Pivots Part 1[/url]
Jeff Moden's Cross tab and Pivots Part 2[/url]
September 21, 2012 at 8:06 am
Viewing 15 posts - 181 through 195 (of 859 total)