Viewing 15 posts - 2,656 through 2,670 (of 4,080 total)
I know... otherwise I would never have dared to say 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
August 5, 2009 at 12:58 pm
Thanks, Gail. Nice to see you back.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 5, 2009 at 12:05 pm
Thanks for letting us know you solved it yourself, Virgil. Don't worry about it. We've all had moments when we overlooked a simple and obvious...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 5, 2009 at 12:04 pm
It only takes a second when you are doing something like expanding the maximum size of a varchar field, because none of the actual data rows have to change. ...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 5, 2009 at 12:01 pm
This I gotta see....
You guys rock, but the vocals are like nails on a blackboard.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 5, 2009 at 11:55 am
Were the rows populated, or did it have nulls in the char(1) column?
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 5, 2009 at 10:05 am
Try this: EXEC database.schema.procedureName
If your database is called Reports, and your procedure is dbo.InventorySummary you would use:
EXEC Reports.dbo.InventorySummary.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 5, 2009 at 9:53 am
Hmmmm party encounters a Spamming Troll...
Roll 3xd10 for saving throws against annoying misspellings....
Wizard casts Ancient Programming Languages...
Elf has shot the food!
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 5, 2009 at 9:30 am
Anything slower than "instantaneous" is too damn slow, Gus 🙂
Hey Eswin,
(1) Please don't post to the "Problems Getting Worse" thread to call attention to your questions. That's...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 5, 2009 at 9:00 am
I am trying to imagine what the forms for RPG.NET would look like.
The mind boggles :w00t:
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 5, 2009 at 8:59 am
The joke is REALLY old school. I cut my teeth on RPG II on an IBM System 32 back in the late 1970s.
So far as...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 5, 2009 at 8:42 am
Old school string manipulation?
declare @xml xml
declare @string varchar(max)
set @xml =
'
'
set @string = cast(@xml as varchar(max))
set @string = replace(@string,'','')
set @string = replace(@string,'','')
set @xml = @string
select @xml
OK... Editing here because this is...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 5, 2009 at 8:17 am
Subqueries don't make queries horrible 😉 How have you approached the problem?
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 5, 2009 at 8:03 am
By way of explanation, it appears to be trying to convert the money datatype to the varchar datatype to make the comparison. (Not convert the '0.00' to money.) ...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 5, 2009 at 8:00 am
One warning about the output clause, it can only contain columns that were inserted into the primary table (and calculated columns based on those columns). It will not...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 5, 2009 at 7:01 am
Viewing 15 posts - 2,656 through 2,670 (of 4,080 total)