Viewing 15 posts - 766 through 780 (of 851 total)
Bob Hovious (2/4/2009)
I just have to blink and be the first to ask.Is this thread dead?
[font="Verdana"]Dunno about the others, but I've been getting therapy.[/font]
February 4, 2009 at 4:06 pm
[font="Verdana"]Try something like:
substring(
case when dbo.BOCleared.DDS is null then '' else ', ' + dbo.BOCleared.DDS end +
case when dbo.CTCleared.DDS is null then ''...
February 4, 2009 at 3:21 pm
[font="Verdana"]Are you displaying this in a reporting services report? Because if so, you can return the actual datetime value, and then change the field format on the report so...
February 4, 2009 at 2:12 pm
raohtheconquerer (2/4/2009)
Ok! I guess that the union would gradually degrade depending on how many parameters i'd have to string together?
[font="Verdana"]Not necessarily. It depends on your hardware and the version/edition...
February 4, 2009 at 1:55 pm
[font="Verdana"]Ah, that makes sense!
You could always do the "sixth normal form" thing, and have a related table into which you fill in the GUIDs as/when you need them (as distinct...
February 4, 2009 at 1:50 pm
[font="Verdana"]Just a reminder: if you know that the lists (record-sets, sets, terminology of your choice) that you are combining don't have values in common, use union all, not union to...
February 4, 2009 at 1:42 pm
[font="Verdana"]Good.
I had a think over this last night, and realised you could simplify it a little by using case. So that would change the psuedo-SQL to look something like...
February 4, 2009 at 1:39 pm
[font="Verdana"]I'd suggest you start with the datepart function. Look it up in SQL Server Books Online (BOL).[/font]
February 4, 2009 at 1:32 pm
[font="Verdana"]Wow! I have to say reading through the responses and the amount of time people are taking to look at this, I am seriously impressed! Some good, thoughtful...
February 4, 2009 at 1:27 pm
[font="Verdana"]It can depend on the indexes on the table you are inserting into as well. If it is heavily indexes, this will slow down the insert.
Try dropping all but...
February 4, 2009 at 1:21 pm
[font="Verdana"]Would a pattern that says "not a period followed by a digit" work? (er, [^.0-9].) Regular expressions are always fun![/font]
February 4, 2009 at 1:13 pm
[font="Verdana"]Mine would be:
selectconvert(varchar(6), getdate(), 112)
[/font]
February 4, 2009 at 12:47 pm
[font="Verdana"]Just a reminder. If one of the column values is null, then "null + 'Test String'" will return null.[/font]
February 4, 2009 at 12:43 pm
[font="Verdana"]I'm a little confused by the question.
Business Intelligence (BI) is a label for a group of people and products working together to produce the information (i.e. data with meaning) that...
February 4, 2009 at 12:39 pm
[font="Verdana"]be a little careful here. You could well get different behaivour depending on what you actually want.
For example, if you have three values, A, B, C, and they are...
February 4, 2009 at 12:34 pm
Viewing 15 posts - 766 through 780 (of 851 total)