ChrisM@Work

Forum Replies Created

Viewing 15 posts - 8,581 through 8,595 (of 10,143 total)

RE: Multi Column Sort

jsanborn (4/2/2009)
using a case statement to include multiple columns simultaneously when zero is encountered will not work.
Not so. Here's a solution using just that:
drop table #test
create table #test (
ID int...
^{“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:00 am

#972163
RE: Birthday alert

KTTHOOL (4/4/2009)
The problem is that the SQL SERVER 2005 stores in yy/dd/mm format.
No, the problem is that you think it does, and it does not. SQL SERVER 2005 stores dates...
^{“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 4, 2009 at 5:07 am

#972022
RE: How to write this SELECT better

WHERE exists (select USERID from dbo.tblUserdesignees)This will return true if there are any rows in the table dbo.tblUserdesignees.
Do you mean this?WHERE EXISTS (SELECT 1 FROM dbo.tblUserdesignees WHERE USERID =...
^{“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 3, 2009 at 2:14 pm

#971851
RE: Multi Column Sort

Bob Hovious (4/3/2009)
Both "Ping Pong Ball" and "Elephant" have three vowels.
Both "Ping Pong Ball" and "Cricket" contain the letter "I".
Elephant and cricket each have one bowel. Dumbo 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 3, 2009 at 10:51 am

#971725
RE: Multi Column Sort

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 average slope for...
^{“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 3, 2009 at 10:23 am

#971714
RE: How to write this SELECT better

Thang.Nguyen10 (4/3/2009)
Thanks Chris.
As you suggested, I start running your script in Dev environment (where I am the only user) at 10:11am and now is 11:09am, the script is...
^{“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 3, 2009 at 9:17 am

#971662
RE: How to write this SELECT better

GilaMonster (4/3/2009)
Looking at the nicely cleaned up version posted by Chris (Thanks Doc) part of your problem is fairly easily apparent.
You're welcome, poppet.
Next thing I'd do is test out some...
^{“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 3, 2009 at 8:53 am

#971637
RE: T-Sql rant

Anye Mercy (4/3/2009)
Guys & gals, I think it's time to stop feeding the troll.
Shhhhhh.... he's asleep, let's keep it that way:satisfied:
^{“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 3, 2009 at 8:10 am

#971587
RE: How to write this SELECT better

Let's start at the beginning. You will want to test any suggestions without affecting the data, so I've stripped out the INSERT part leaving the SELECT which feeds it. Some...
^{“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 3, 2009 at 8:01 am

#971577
RE: Are the posted questions getting worse?

GilaMonster (4/3/2009)
Chris Morris (4/3/2009)
No need, Barry - somehow in my misspent youth I managed to "satisfy the requirements" for a PhD. GF bullies me to use the title.
So we need...
^{“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 3, 2009 at 7:43 am

#971552
RE: My query takes long time to execute

panpaliachanchal (4/3/2009)
I need code to navigate data without using Vb6 Adodb.recordset
I have used for navigation code. But It takes a long time.
I can't used stored procedure because my condition...
^{“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 3, 2009 at 7:06 am

#971499
RE: My query takes long time to execute

panpaliachanchal (4/3/2009)
I need code to navigate data without using Vb6 Adodb.recordset
I have used for navigation code. But It takes a long time.
what is SP. (You can do all your...
^{“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 3, 2009 at 6:06 am

#971437
RE: My query takes long time to execute

panpaliachanchal (4/3/2009)
My database consists of 60 tables & 50 views.
One single table contains nearly 6,00,000 records.
When i use Adobd.recordset to fill it takes a long time .
Why do...
^{“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 3, 2009 at 5:12 am

#971415
RE: Insert using a join

Nice work Karl, Happy Friday!
^{“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 3, 2009 at 4:29 am

#971400
RE: Are the posted questions getting worse?

Jeff Moden (4/2/2009)
After just the first couple of posts from that self appointed, ring knocking, side stepping beach creature
from the shallow end of the gene pool 😎
RBarryYoung (4/2/2009)
Chris...
^{“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 3, 2009 at 4:27 am

#971399

Viewing 15 posts - 8,581 through 8,595 (of 10,143 total)