Viewing 15 posts - 331 through 345 (of 851 total)
[font="Verdana"]I'm still not very clear on what you are trying to do.
Have you looked at dateadd(), datediff() and convert() in SQL Server Books Online?
[/font]
April 13, 2009 at 10:50 pm
Jeff Moden (4/13/2009)
Thanks, Bruce... and sorry I took it the wrong way.
[font="Verdana"]No problem.
I think it's yet another example of using the right tool for the job. It's just that...
April 13, 2009 at 7:44 pm
Jeff Moden (4/13/2009)
April 13, 2009 at 6:33 pm
mnicholas (4/13/2009)
I guess how in MS Reporting Services do I order the columns from highest Total to lowest?
[font="Verdana"]Heh. Do it in SQL Server? 😛
Seriously, I'd be hard pressed...
April 13, 2009 at 4:37 pm
RBarryYoung (4/13/2009)
Note that the line counts are different simply because the TVF omits empty results:
string[] items = toSplit.Split(new string[] { delimeter }, StringSplitOptions.RemoveEmptyEntries);)
It would be really nice if we could...
April 13, 2009 at 4:29 pm
[font="Verdana"]I think the problem is that you want to order the columns not the rows.
Hmmm.
The only way I can think of off-hand is to unpivot, order, then pivot back up.
[/font]
April 13, 2009 at 4:10 pm
Florian Reischl (4/13/2009)
I thought about the CTE while typing the sub-query. I just determined that, in this case, the sub-query is simple enough that it stays readable.Greets
Flo
[font="Verdana"]Agreed in this case...
April 13, 2009 at 4:02 pm
[font="Verdana"]I remember doing a bunch of performance testing a couple of years ago when we were converting code from SQL Server 6.5 to SQL Server 7. We found then...
April 13, 2009 at 3:23 pm
[font="Verdana"]Also okay in SQL Server 2005 to use a CTE (common table expression), which I find makes the resulting code a little more readable, but is otherwise pretty much the...
April 13, 2009 at 3:15 pm
[font="Verdana"]Flo, I'll add my kudos as well: it's good to see some numbers showing how CLR rates in comparison with T-SQL. And I'll look forward to the article. ...
April 13, 2009 at 2:03 pm
[font="Verdana"]I still tend to use a Calendar table, rather than a function, for bulk date conversions. Obviously that doesn't work so well when you have a time component![/font]
April 8, 2009 at 4:43 pm
andrew gothard (4/8/2009)
April 8, 2009 at 4:11 pm
[font="Verdana"]
A good article.
I've been using that trick of breaking large operations down into smaller ones since, oh, SQL Server 6.5 days?
Compared with re-assembling the small steps into the one or...
April 8, 2009 at 2:39 pm
[font="Verdana"]Hmmm.
This is like saying "I only know about two colours: blue and green. Now this thing called "red" comes along... is it blue or green?
A table is, believe...
April 6, 2009 at 4:38 pm
Jeff Moden (4/6/2009)
April 6, 2009 at 2:29 pm
Viewing 15 posts - 331 through 345 (of 851 total)