Viewing 15 posts - 2,671 through 2,685 (of 4,080 total)
No, no, no... B5010D2A-F8F9-482B-AC29-C1351ECE52C8 is my NAME. My friends call me BR-542.
My appointment is 45DF88B8-C798-45DC-8E8D-4898172DB091.
__________________________________________________
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 6:50 am
declare @table table (xtext varchar(100))
insert into @table
select 'bicycle safety' union all
select 'safety bicycle' union all
select 'bicycle sidewalk safety' union all
select 'safety goggles bicycle' union all
select 'bicycle highway speeding' union all
select...
__________________________________________________
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 6:45 am
Or we could just go back to flat files. Screw relational AND hierarchical databases.
__________________________________________________
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 4, 2009 at 2:57 pm
You're welcome. I figured you'd get there eventually 😉
__________________________________________________
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 4, 2009 at 12:11 pm
I added notes to the top and bottom of the article for people to read the discussion.
That's a really good idea, Steve. Sometimes the amount of value in...
__________________________________________________
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 4, 2009 at 12:11 pm
I agree with Gus. Your simplest approach is to simply use an identity column and add the "U" when the number is displayed to your supervisor's application. ...
__________________________________________________
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 4, 2009 at 10:30 am
--
There is also a trick to handling spaces, commas, or other separators, which is shown in the examples below. The trick is to test an expression which includes...
__________________________________________________
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 4, 2009 at 10:16 am
I have to ask why the U is mandatory.
__________________________________________________
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 4, 2009 at 9:36 am
Care to elaborate on that, Paul? I'm somewhat familiar with Service Broker but I want to be sure I'm not misunderstanding you.
__________________________________________________
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 4, 2009 at 8:28 am
Take a minute sometime to read it and the comments, Jack. I don't think he was comparing apples to apples.
__________________________________________________
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 4, 2009 at 8:24 am
Another thing to point out about XML's use of space is that, barring compression, the data is being stored as characters wrapped in tags, making storage of integer, numeric, or...
__________________________________________________
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 4, 2009 at 7:54 am
Good luck, blue. It's really not difficult, just tedious and time consuming.
__________________________________________________
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 4, 2009 at 7:24 am
It's not a bug. That behavior is consistent even with char data (see code below).
Trailing blanks or spaces are disregarded, and in my opinion that's a fine thing too....
__________________________________________________
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 4, 2009 at 7:16 am
Jack, I think you have an OP who is lacking in the fundamentals as well as ESL-challenged.
Lynn, I'll say a little prayer for her tonight.
Grant, you and Gus...
__________________________________________________
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 3, 2009 at 8:19 pm
That's a good summary, Gus. We had some developers create scalar-valued UDFs (which contained queries) to simplify/standardize their final queries. That way, instead of writing...
__________________________________________________
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 3, 2009 at 8:15 pm
Viewing 15 posts - 2,671 through 2,685 (of 4,080 total)