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...
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...
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...
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...
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
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...
October 22, 2012 at 2:32 pm
Well i have an answer but im going to ask what have you tried?
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.
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...
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,...
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...
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....
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...
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?
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.
September 21, 2012 at 8:06 am
Viewing 15 posts - 181 through 195 (of 859 total)