ChrisM@Work

Forum Replies Created

Viewing 15 posts - 976 through 990 (of 10,143 total)

RE: t-sql 2012 compare datetime fields

wendy elizabeth - Thursday, January 12, 2017 9:13 AM
In t-sql 2012, I have 2 datetime fields where I need to compare the datetime...
^{“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

January 12, 2017 at 9:42 am

#1922361
RE: SSC Forum Updates

robert.chipperfield - Thursday, January 12, 2017 9:22 AM
DamianC - Thursday, January 12, 2017 9:19 AM
I seem...
^{“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

January 12, 2017 at 9:26 am

#1922353
RE: Index Seek - ConvertImplicit

luiz.sopmac - Thursday, January 12, 2017 9:14 AM
Lynn Pettis - Thursday, January 12, 2017 8:59 AM
^{“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

January 12, 2017 at 9:25 am

#1922352
RE: Index Seek - ConvertImplicit

Ed Wagner - Thursday, January 12, 2017 9:11 AM
ChrisM@Work - Thursday, January 12, 2017 8:59 AM
^{“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

January 12, 2017 at 9:16 am

#1922348
RE: Index Seek - ConvertImplicit

luiz.sopmac - Thursday, January 12, 2017 8:49 AM
Hi all!
i'm running a stored procedure, which receives a single parameter and returns a single row...
^{“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

January 12, 2017 at 8:59 am

#1922334
RE: Are the posted questions getting worse?

Jeff Moden - Thursday, January 12, 2017 8:29 AM
Not sure if it's just me or not. Under forums, the "Latest" posts don't ever...
^{“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

January 12, 2017 at 8:31 am

#1922315
RE: Are the posted questions getting worse?

jasona.work - Thursday, January 12, 2017 7:05 AM
ChrisM@Work - Thursday, January 12, 2017 6:32 AM
^{“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

January 12, 2017 at 7:17 am

#1922258
RE: SSC Forum Updates

Dave Convery - Thursday, January 12, 2017 6:46 AM
We've just deployed an update that should concatenate empty space at the start and end...
^{“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

January 12, 2017 at 7:12 am

#1922250
RE: Are the posted questions getting worse?

Brandie Tarvin - Thursday, January 12, 2017 6:14 AM
Unrelated to the forums upgrade...
Some of you know I was working on a project 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

January 12, 2017 at 6:32 am

#1922226
RE: Conver varchar date to date only

adonetok - Thursday, January 12, 2017 5:45 AM
Sergiy - Wednesday, January 11, 2017 6:59 PM
adonetok (1/11/2017)
One...
^{“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

January 12, 2017 at 6:12 am

#1922211
RE: http://shaperich.com/alpha-monster-advanced/

Reported as spam.
^{“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

January 12, 2017 at 4:15 am

#1922141
RE: SSC Forum Updates

First spam dammit!
https://www.sqlservercentral.com/Forums/Topic1849984.aspx
^{“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

January 12, 2017 at 4:14 am

#1922140
RE: Conver varchar date to date only

adonetok (1/11/2017)
Output is
2015-10-25 00:00:00.000
How to remove 00:00:00.000 portion and still keep date type?
Output of 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

January 11, 2017 at 10:04 am

#1921997
RE: Any tips on speeding this SQL up would be most helpful

douglas.t (1/11/2017)
@arjun, I had charge_amount at first - charge_qty does fix the number of records. So both queries give the right results, but ChrisM is a little faster.
So 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

January 11, 2017 at 9:57 am

#1921994
RE: Are the posted questions getting worse?

rodjkidd (1/9/2017)
Eirikur and Chris,
Sorry for the late notice but I only booked today!
I'm near Oxford Circus tomorrow for a camera flash course. It finishes at 4 30. So could meet...
^{“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

January 11, 2017 at 1:31 am

#1921834

Viewing 15 posts - 976 through 990 (of 10,143 total)