ChrisM@Work

Forum Replies Created

Viewing 15 posts - 7,336 through 7,350 (of 10,143 total)

RE: Need help on rounding number

Michael Valentine Jones (9/21/2010)
You can just use the ROUND function to round the age up or down.
.....
You can Michael, and there's a 50/50 chance it will work as-is here. Depends...
^{“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

September 22, 2010 at 2:12 am

#1225373
RE: concatenating CASE stmt results

scott.pletcher (9/21/2010)
I don't see how that's a disadvantage of the simple CASE. The complex CASE will have the same issue for the same reason. The first version 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

September 21, 2010 at 10:12 am

#1225009
RE: blasted INSERT-EXEC limitation has me stumped

BenWard (9/21/2010)
Hi Chris,
thats essentially what I'm doing but twice.. im trying to call that sproc from another and copy data into a table from that exec which sql cant do.
Oh...
^{“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

September 21, 2010 at 10:06 am

#1224999
RE: blasted INSERT-EXEC limitation has me stumped

Hi Ben, not sure if this is any good to you, I wrote it in a previous life and can't even test it here:
CREATE PROCEDURE [dbo].[CopyDiskFile]
@FileFrom VARCHAR(200), @FileTo VARCHAR(200)
AS
SET...
^{“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

September 21, 2010 at 9:58 am

#1224989
RE: Today's Random Word!

RichardDouglas (9/21/2010)
Syrup - the guys here bought me two litres of coffee syrup complete with optic style dispensers, it's not helping my caffeine addiction 😀
They sit nicely next to...
^{“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

September 21, 2010 at 9:34 am

#1224966
RE: Are the posted questions getting worse?

CirquedeSQLeil (9/21/2010)
Alvin Ramard (9/21/2010)
CirquedeSQLeil (9/21/2010)
So T-time is at 4? Sounds good to me:cool:
Is it ok if I have coffee instead of tea? 😎
My powers of divination told me...
^{“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

September 21, 2010 at 9:08 am

#1224924
RE: Are the posted questions getting worse?

CirquedeSQLeil (9/21/2010)
Chris Morris-439714 (9/21/2010)
khanameerkhan (9/20/2010)
Is there any way to determine who deleted the database in sql server 2008.
Look under tables and in cupboards for one of these :blush:
If 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

September 21, 2010 at 8:51 am

#1224899
RE: Rows to columns

Have a read through Jeff Moden's excellent article[/url]. If you are still experiencing difficulty, then post again. It's a little tough going to begin with but you'll soon get 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

September 21, 2010 at 8:49 am

#1224897
RE: Are the posted questions getting worse?

khanameerkhan (9/20/2010)
Is there any way to determine who deleted the database in sql server 2008.
Look under tables and in cupboards for one of these :blush:
^{“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

September 21, 2010 at 8:43 am

#1224886
RE: concatenating CASE stmt results

drew.allen (9/21/2010)
Jeff Moden (9/20/2010)
I don't like the short version at all because it "lies".
That's very interesting, but, realistically, how often do people use nondeterministic functions like NEWID() in the comparison...
^{“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

September 21, 2010 at 7:25 am

#1224794
RE: Datetime format issue in SQLServer2k5

mail4sha (9/21/2010)
is there any possibility to set the date format "dd-mon-yyyy hh24:mm:ss " in SQLServer2k5?... not using convert funtion... i want this format permanently to the database... can anyone suggest...
^{“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

September 21, 2010 at 7:06 am

#1224768
RE: Today's Random Word!

dbowlin (9/21/2010)
Ray K (9/21/2010)
WOTD: Coffee (as in I need some! :doze:)
Lemon Zinger is my morning brew.
We have a zero tolerance policy to alcohol here :Whistling:
^{“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

September 21, 2010 at 7:03 am

#1224765
RE: concatenating CASE stmt results

Jeff Moden (9/20/2010)
I don't like the short version at all because it "lies".
So a Simple CASE, which on the face of it should work quicker than a Searched...
^{“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

September 21, 2010 at 6:25 am

#1224732
RE: Stored Provcedure question...

So, why don't you just put "exec dbo.rpt_HS_BedsMI @insurer=@ins, @lwrDate=@lowerDate, @uprDate=@upperDate" at the end of what you've 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

September 21, 2010 at 6:04 am

#1224712
RE: Problems with select

ColdCoffee (9/21/2010)
Chris Morris-439714 (9/21/2010)
Edit: Oops, ColdCoffee beat me to it.
Ah , never CM.. i always enjoy reading through your innovative ideas of solving questions, makes me learn a lot.. i...
^{“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

September 21, 2010 at 5:42 am

#1224701

Viewing 15 posts - 7,336 through 7,350 (of 10,143 total)