ChrisM@Work

Forum Replies Created

Viewing 15 posts - 8,416 through 8,430 (of 10,143 total)

RE: Are the posted questions getting worse?

Paul White (5/27/2009)
Right then.
Given the wealth of knowledge and talent around these parts, who's up for writing the perfect collaborative-effort book on indexing?
We could all get fabulously rich!!!...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

May 28, 2009 at 2:41 pm

#1001774
RE: Arithmetic Overflow

Paul White (5/27/2009)
arun.sas (5/26/2009)
Paul White (5/26/2009)
A country where the VAT rate requires a DEC(38,2) is likely to experience civil unrest sooner rather than later. :w00t:
Never assume the VAT means “Value...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

May 28, 2009 at 2:38 pm

#1001773
RE: Are the posted questions getting worse?

David Burrows (5/15/2009)
here
No mountains only a few hills
Blimey, small world...I was born in Wroughton in the old RAF hospital - and shoot every saturday now at Roves Farm, a couple...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

May 18, 2009 at 10:38 am

#996494
RE: Are the posted questions getting worse?

GilaMonster (5/5/2009)
Why would I ever trace a gorgeous African summer for that damp, slightly warm couple months that they call summer in the UK?
(before anyone gets offended, I'm originally from...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

May 5, 2009 at 10:39 am

#989031
RE: Are the posted questions getting worse?

Derek Dongray (5/5/2009)
Some time ago, the BBC Radio 2 lunchtime show hosted by Jeremy Vine had a phone in to find the best opening lines of all time.
And the winner...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

May 5, 2009 at 6:43 am

#988723
RE: Are the posted questions getting worse?

Jan Van der Eecken (4/29/2009)
David Webb (4/29/2009)
Yes. I saw it 5 times during the next two weeks and saw some new detail I had missed on the times before....
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

April 30, 2009 at 4:24 am

#986538
RE: Are the posted questions getting worse?

GilaMonster (4/29/2009)
tosscrosby (4/29/2009)
Lynn Pettis (4/28/2009)
You know, I can think of some one else that, IMHO, ranks right there with our favorite White House window washer, and here is his latest...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

April 30, 2009 at 4:15 am

#986534
RE: Query to bring top latest record

peggyah (4/22/2009)
I have a similar problem where I have records of individuals that are being tracked as they move through an area. I only what the see the last...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

April 23, 2009 at 2:07 am

#982700
RE: Insert Query

Please can you supply a source table create script with inserts for a few rows? If you're unsure about how to do this, read the link in my sig.
Cheers
ChrisM
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

April 23, 2009 at 2:03 am

#982695
RE: cannot insert duplicate key row in object 'tablename' with unique index 'indexname'

Interesting - the primary key consists of [CostWorkOrder] plus another two columns, but [CostWorkOrder] is also defined separately as a unique key (the DML for this isn't in your script)....
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

April 22, 2009 at 10:36 am

#982336
RE: Error between unicode and non-unicode string data types!

The last four rows in your list appear to be 3 columns shorter than the previous rows - is this real or an artifact?
You could identify which row(s) are...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

April 22, 2009 at 10:05 am

#982309
RE: Error between unicode and non-unicode string data types!

There are only 17 columns in the sample you posted earlier.
In your shoes, I'd create a new file containing the first row from your flat file, copied down say...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

April 22, 2009 at 9:21 am

#982266
RE: Incrementing inside a group

Jeff Moden's excellent article here[/url] describing how to do this is currently being rewritten to accommodate changes between SQL2k and SQL2k5. However, the SQL2k code, which is what you're interested...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

April 22, 2009 at 9:02 am

#982252
RE: Error between unicode and non-unicode string data types!

How many rows and columns in the flat file?
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

April 22, 2009 at 8:38 am

#982229
RE: Error between unicode and non-unicode string data types!

Then I guess you're concatenating two source columns. Have you tried remapping them?
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

April 22, 2009 at 7:12 am

#982171

Viewing 15 posts - 8,416 through 8,430 (of 10,143 total)