ChrisM@Work

Forum Replies Created

Viewing 15 posts - 8,566 through 8,580 (of 10,143 total)

RE: How to insert into table based on previous results

Yes, that's pretty much it. As you can see, you can do a whole set at a time, no fiddling about with single rows.
What do you want to do with...
^{“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 6, 2009 at 3:03 pm

#972924
RE: Getting a sub-select query to work with 2 MAX(column)

Jack Corbett (4/6/2009)
I think?
It's one of those, Jack, but the requirements are so ambiguous it's kinda hard to tell 🙂
^{“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 6, 2009 at 2:38 pm

#972906
RE: Getting a sub-select query to work with 2 MAX(column)

JacekO (4/6/2009)
Chris,
I thought you were heading to a pub...:-P
Nah Jacek, the kitchen! Leffe brune, just the one...gonna stop now, keep bumping into Jack. Good luck, Jack 😎
^{“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 6, 2009 at 2:35 pm

#972902
RE: How to insert into table based on previous results

jbuttery (4/6/2009)
I can't seem to figure how to insert new records into a database based on previous records. I want to read a record, increment or modify several columns and...
^{“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 6, 2009 at 2:28 pm

#972896
RE: Getting a sub-select query to work with 2 MAX(column)

I reckon this is what you are looking for
DROP TABLE #Temp
CREATE TABLE #Temp (col1 CHAR(1), col2 CHAR(1), col3 CHAR(1), col4 CHAR(1), col5 CHAR(1))
INSERT INTO #Temp (col1, col2, col3, col4, col5)
SELECT...
^{“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 6, 2009 at 2:22 pm

#972890
RE: Multi Column Sort

jsanborn (4/6/2009)
I agree. I think an application solution would be best. It looks like any possible SQL solution is going to be very cumbersome. Thanks all.
As they say here "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 6, 2009 at 11:43 am

#972772
RE: Getting a sub-select query to work with 2 MAX(column)

Jack Corbett (4/6/2009)
Chris Morris (4/6/2009)
Good Lord, sorry Jack, what was I thinking :blush: time for more coffee!
No worries. I was just a little surprised you said that, and knew...
^{“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 6, 2009 at 11:24 am

#972757
RE: Getting a sub-select query to work with 2 MAX(column)

Jack Corbett (4/6/2009)
Chris Morris (4/6/2009)
Jack Corbett (4/6/2009)
One problem with your first query is that it includes the columns you want the MAX for in the GROUP BY so you get...
^{“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 6, 2009 at 9:36 am

#972650
RE: Getting a sub-select query to work with 2 MAX(column)

Jack Corbett (4/6/2009)
One problem with your first query is that it includes the columns you want the MAX for in the GROUP BY so you get all the rows. ...
^{“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 6, 2009 at 9:13 am

#972615
RE: Multi Column Sort

Bob Hovious (4/6/2009)
This has certainly been an interesting problem to follow.
Hey Bob, I'm still messing about with derivatives of this - have you got...
^{“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 6, 2009 at 9:04 am

#972601
RE: Multi Column Sort

Bob Hovious (4/6/2009)
Sweet. This has certainly been an interesting problem to follow.
Anyone heard from the OP lately?
Nope. Bet he's busy with his nose...
^{“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 6, 2009 at 8:39 am

#972576
RE: Multi Column Sort

GSquared (4/6/2009)
Chris, on the case-statement version, running on the same hardware as the prior tests, took 8:59 (nearly 9 minutes) the first run, 8:54 the second.
If that was exactly as...
^{“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 6, 2009 at 7:51 am

#972530
RE: error of sintax

pedro.ribeiro (4/6/2009)
Hi,
Yap, there's other reason.
With the result of the select i will trie to produce a txt file (script) that as insert statements.
This script will be sent to other...
^{“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 6, 2009 at 5:08 am

#972419
RE: Query Doubts

pandeharsh (4/6/2009)
SELECT Table1.code
FROM Table1, Table2
WHERE Table1.code not in(select code from Table2)
GROUP BY Table1.code;
I get the result,but i do not want to use group by or distinct clause.
Can I acheive...
^{“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 6, 2009 at 12:46 am

#972308
RE: Multi Column Sort

john.arnott (4/3/2009)
Chris Morris (4/3/2009)
GSquared (4/3/2009)
Anyone else have any ideas on this?
There were two other ideas which I've not had time to follow up yet. The first was to derive an...
^{“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 5, 2009 at 7:09 am

#972164

Viewing 15 posts - 8,566 through 8,580 (of 10,143 total)