Viewing 15 posts - 3,916 through 3,930 (of 4,080 total)
By trebuchet or air cannon?
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
December 10, 2008 at 11:20 am
Who said it was a bug? 😉
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
December 8, 2008 at 2:29 pm
Try this. As pointed out earlier, you could also generate this as dynamic SQL with a MAX() line for every distinct attribute description. This assumes that...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
December 8, 2008 at 12:56 pm
Grammar lessons you need. Help you I cannot. Yes!
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
December 8, 2008 at 11:50 am
No argument here. I've already cut and pasted them into my snippets library.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
December 8, 2008 at 10:52 am
Most of our output goes to either reporting services, spreadsheets, or user interfaces that handle the formatting. The only raw SQL reports are ad-hoc. ...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
December 8, 2008 at 10:06 am
No reason at all 🙂
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
December 8, 2008 at 9:52 am
Good plan. Psychological issues are better served by counseling 😉
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
December 8, 2008 at 9:48 am
The mighty Garadin is correct. My last couple of examples were step-by-step, each dependent on the last. You can of course nest the steps into...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
December 7, 2008 at 3:19 pm
Take a look at the UNPIVOT operation. Unfortunately, you will have to list all columns by name.
http://msdn.microsoft.com/en-us/library/ms177410.aspx
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
December 7, 2008 at 1:13 pm
Sergiy's right. STR is often a better choice, but it depends on what you're going to do with your output.
If you're going to use STR, be sure...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
December 7, 2008 at 1:03 pm
Ned,
It is good of you to post up solutions which might be useful to others.
To elaborate on what Sergiy said, because datetime format is numeric...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
December 7, 2008 at 12:29 pm
CAST or CONVERT the decimal amount to varchar and then you can use an empty string with ISNULL.
select isnull(convert(varchar(10),amount),'') as amount
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
December 7, 2008 at 11:41 am
Just in case your question isn't about the format of the INSERT statement, but rather about how to designate your columns in the ACCESS database...
If your question is how...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
December 7, 2008 at 11:19 am
Jeff, I would never have thought to use parsename on an IP address, but it makes perfect sense because it has four elements separated by periods. Tell me...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
December 7, 2008 at 11:04 am
Viewing 15 posts - 3,916 through 3,930 (of 4,080 total)