ChrisM@Work

Forum Replies Created

Viewing 15 posts - 5,926 through 5,940 (of 10,143 total)

RE: trying to add alias for value generated by Where clause

polkadot (8/2/2012)
Well here's how I solved it.
First, I assigned rank to the saledate so that cumulative totals were not against randomly ordered dates, then I inserted results into...
^{“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

August 3, 2012 at 2:49 am

#1521279
RE: T-SQL Advice on Update Statement Needed

Brandie Tarvin (8/2/2012)
Huh. Interesting thoughts, Chris. I'll take a look at that option.
Maybe I should be indexing the staging table after it's loaded too.
Here's a good reference[/url] covering the first...
^{“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

August 3, 2012 at 2:47 am

#1521278
RE: T-SQL Advice on Update Statement Needed

Michael Valentine Jones (8/2/2012)
In place of this:
or the earningsdate <> the timekey from dt3
or the CycleMonth <> the timekey from dt2
or AEarned1 <> staging column 1
or...
^{“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

August 3, 2012 at 2:40 am

#1521276
RE: Today's Random Word!

JAZZ Master (8/2/2012)
crookj (8/2/2012)
SQLRNNR (8/2/2012)
EL Jerry (8/2/2012)
Revenant (8/2/2012)
L' Eomot Inversé (8/2/2012)
Cliff Jones (8/2/2012)
Daniel Bowlin (8/2/2012)
Rob Schripsema (8/2/2012)
this?
read
me
making
keep
idiot
this
does
How
^{“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

August 3, 2012 at 2:33 am

#1521274
RE: Record linkage advice required– Long read (YOU HAVE BEEN WARNED!)

Abu Dina (8/2/2012)
The more I think about this the more I come to realise that the address fields must be standardised before any merge work is done. I've spent hours...
^{“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

August 2, 2012 at 9:48 am

#1520964
RE: Record linkage advice required– Long read (YOU HAVE BEEN WARNED!)

You need to tune the original query to reduce the false positives. The easiest way to do this is to tweak the match ratios in the WHERE clause until you...
^{“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

August 2, 2012 at 9:32 am

#1520939
RE: Strange behavior with "where not in" clause

Heh you beat me to it, Gus.
Gail has a great blog covering this behaviour here[/url].
^{“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

August 2, 2012 at 9:01 am

#1520908
RE: Update sortorder column to +1

The sample data doesn't contain any holes. Maybe there aren't any. Here's a sample set with a hole and two [Type]'s:
SET NOCOUNT ON
DROP TABLE #CustomerConditions
CREATE TABLE #CustomerConditions(
[Id] [int] IDENTITY(1,1)...
^{“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

August 2, 2012 at 8:51 am

#1520894
RE: Date format question

gsd1 (8/2/2012)
Thanks for the reply Chris.
For "07/13/2012 1:06:12 AM" --> Web service is returning "2012-07-13T01:06:12.000-04:00" .
I defined my table column as datetime and the program is loading it...
^{“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

August 2, 2012 at 8:25 am

#1520867
RE: Date format question

gsd1 (8/2/2012)
Hi,
For "07/13/2012 1:06:12 AM" --> I am getting "2012-07-13T01:06:12.000-04:00"
How can I just take date&time without considering "-04:00" in tsql?
Thank you..
Display of a SQL Server...
^{“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

August 2, 2012 at 7:50 am

#1520838
RE: Performance when adding PK

chriskellerx10 (8/2/2012)
I had a procedure that runs every day that normally takes 20 minutes or so...without a primary key. I added a PK to one of my tables (the PK...
^{“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

August 2, 2012 at 7:46 am

#1520833
RE: An Alternative (Better?) Method to UNPIVOT (SQL Spackle)

Another cracking good article Dwain!
^{“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

August 2, 2012 at 7:41 am

#1520827
RE: Implementing Surrogate Key

shahsn11 (8/2/2012)
So does that mean that Surrogate Key is only the concept. And in lay man terms(i.e. mine) can we say that PK=Surrogate Key.
If the above is true that what...
^{“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

August 2, 2012 at 7:25 am

#1520814
RE: Are the posted questions getting worse?

Evil Kraig F (8/1/2012)
GilaMonster (7/31/2012)
Evil Kraig F (7/31/2012)
Ugh, sick for a week blows. I miss anything of import since last Tuesday?
Vacation! Mine! (no, you're not invited 🙂 )
LOL! ...
^{“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

August 2, 2012 at 6:47 am

#1520776
RE: Are the posted questions getting worse?

SQL Kiwi (8/2/2012)
Fal (8/2/2012)
Well, being a Kiwi he does live in the land of Mordor. 😛
True; see the picture below of two hobbits winning our first gold medal in...
^{“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

August 2, 2012 at 6:47 am

#1520774

Viewing 15 posts - 5,926 through 5,940 (of 10,143 total)