ChrisM@Work

Forum Replies Created

Viewing 15 posts - 7,981 through 7,995 (of 10,143 total)

RE: Are the posted questions getting worse?

jcrawf02 (4/16/2010)
Having a good day today. Working through a problem comparing two datasets and finding those that don't match from either. Thought about it, mocked up some data and tried...
^{“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 16, 2010 at 8:49 am

#1152889
RE: define composite primary key with more than 900 bytes

anbillava (4/16/2010)
Thanks.. Thats what i was looking for. Can you explain little more about tie breaker process.
Sure.
Method 1: Enter the same row of data a third time and see...
^{“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 16, 2010 at 6:07 am

#1152744
RE: define composite primary key with more than 900 bytes

Tom.Thomson (4/16/2010)
Chris Morris-439714 (4/16/2010)
"Checksum of a row" could be used to quickly identify row pairs with differences, but the mismatched values still have to be highlighted.
I guess you threw this...
^{“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 16, 2010 at 5:47 am

#1152729
RE: If record not found, then insert else update

Hello
It would be better - much better - to identify the rows you want from @t1 then insert them into #tPosi in a single INSERT...FROM.
So "we need to check the...
^{“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 16, 2010 at 5:39 am

#1152723
RE: Problem in INSERT statement :(

lmu92 (4/15/2010)
@chris-2: When did you start promoting loops??? :crying:
Or do I miss something that prevent doing it set based?
This is what happens when you moonlight as a shower-curtain salesman, Lutz...
^{“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 16, 2010 at 2:39 am

#1152633
RE: Are the posted questions getting worse?

Roy Ernest (4/15/2010)
What is the best way to beat writer's block? Anybody have any ideas? I am half way through an article and now I cant seem to complete 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

April 16, 2010 at 2:28 am

#1152629
RE: define composite primary key with more than 900 bytes

This sounds a little like the double-entry used for clinical trials records. The data is entered twice by two different DE ops. When all of the data has been entered...
^{“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 16, 2010 at 2:24 am

#1152628
RE: Today's Random Word!

Tom.Thomson (4/15/2010)
Whiffletree, Whippletree, Swingletree, Singletree
(Do we really need four words for the same thing?)
Snow.
^{“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 16, 2010 at 2:05 am

#1152624
RE: Today's Random Word!

CirquedeSQLeil (4/15/2010)
crookj (4/15/2010)
tosscrosby (4/15/2010)
Sadistic
Politician and IRS!
Joe
Liars and Cheats?
Yours too?
Conspiracy!
^{“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 15, 2010 at 10:07 am

#1152257
RE: Today's Random Word!

Dentist
^{“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 15, 2010 at 9:17 am

#1152202
RE: Are the posted questions getting worse?

jcrawf02 (4/15/2010)
RBarryYoung (4/14/2010)
jcrawf02 (4/14/2010)
I've been out of Twitter-touch lately, but did you guys see this? Library of Congress is archiving every single tweet ever made?
Goggle already has them anyway.
Yes,...
^{“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 15, 2010 at 7:22 am

#1152098
RE: Problem in INSERT statement :(

sachinrshetty (4/15/2010)
Hi all,
Below is the query that I m using to insert values in variables to the columns of a table
CREATE TABLE #TEMP_ABSENT_TBL(CNO VARCHAR(20), EMPNAME VARCHAR(100), AB_DATE VARCHAR(15))
INSERT INTO #TEMP_ABSENT_TBL...
^{“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 15, 2010 at 5:32 am

#1152013
RE: Today's Random Word!

Plasticine
^{“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 15, 2010 at 5:17 am

#1152010
RE: Today's Random Word!

Tom.Thomson (4/13/2010)
ChrisM@home (4/13/2010)
Jabberwocky.
Had to look up coolats, which are known as culottes here. They're revolting, talk about the worst of both worlds!
Gödellian too. Meh. Must read more.
Mimsy.
Anyone with a...
^{“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 14, 2010 at 7:23 am

#1151319
RE: Today's Random Word!

Organoleptic
^{“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 14, 2010 at 7:10 am

#1151314

Viewing 15 posts - 7,981 through 7,995 (of 10,143 total)