ChrisM@Work

Forum Replies Created

Viewing 15 posts - 1,816 through 1,830 (of 10,143 total)

RE: Count issue/replace between!!!

jcachado (1/25/2016)
This is run with a string in VS 2012, the database table is a mdb (access):
Dim SQLStringtempprd123 As String = "SELECT CAST([create_dtim],'dd-mm-yyyy'),COUNT(*) AS tot FROM Back_ickpt_prd1 WHERE CAST([create_dtim],'dd-mm-yyyy') between...
^{“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 25, 2016 at 8:09 am

#1854176
RE: Count issue/replace between!!!

jcachado (1/25/2016)
ChrisM@Work (1/25/2016)
jcachado (1/25/2016)
Ok,
The statment is:
SELECT format([create_dtim],'dd-mm-yyyy'),COUNT(*) AS tot FROM Back_ickpt_prd1 WHERE format([create_dtim],'dd-mm-yyyy') GROUP BY format([create_dtim],'dd-mm-yyyy') order by format([create_dtim],'dd-mm-yyyy') desc
Its run, but i think the DESC dont work...
^{“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 25, 2016 at 7:57 am

#1854169
RE: Count issue/replace between!!!

jcachado (1/25/2016)
Ok,
The statment is:
SELECT format([create_dtim],'dd-mm-yyyy'),COUNT(*) AS tot FROM Back_ickpt_prd1 WHERE format([create_dtim],'dd-mm-yyyy') GROUP BY format([create_dtim],'dd-mm-yyyy') order by format([create_dtim],'dd-mm-yyyy') desc
Its run, but i think the DESC dont work because 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

January 25, 2016 at 7:48 am

#1854161
RE: Count issue/replace between!!!

jcachado (1/25/2016)
My mistake , already run but not accept the CAST.
Thks ,
JC
Did you get an error message? If so, posting it here would reduce the number of guesses we have...
^{“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 25, 2016 at 7:36 am

#1854156
RE: Count issue/replace between!!!

jcachado (1/25/2016)
Hi again,
Already work in this way:
SELECT Format([create_dtim],'dd-mm-yyyy'),COUNT(*) AS tot FROM Back_ickpt_prd1 WHERE Format([create_dtim],'dd-mm-yyyy') GROUP BY Format([create_dtim],'dd-mm-yyyy' order by Format([create_dtim],'dd-mm-yyyy'
But when i put ORDER BY dont run.
What is the error?
Thks...
^{“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 25, 2016 at 6:18 am

#1854139
RE: Count issue/replace between!!!

jcachado (1/25/2016)
Hi,
I need help for this statement:
SELECT whse_id as wh,count(*) as tot FROM Back_ickpt_prd1 where Format([create_dtim],'hh:nn:ss') between '21-01-2016 00:00:01' and '22-01-2016 00:00:01' group by whse_id
This statement work and show :
wh...
^{“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 25, 2016 at 4:49 am

#1854120
RE: Are the posted questions getting worse?

Eirikur Eiriksson (1/23/2016)
Ed Wagner (1/23/2016)
Eirikur Eiriksson (1/23/2016)
ChrisM@Work (1/22/2016)
Ed Wagner (1/22/2016)
Greg Edwards-268690 (1/21/2016)
Eirikur Eiriksson (1/21/2016)
Greg Edwards-268690 (1/21/2016)
Steve Jones - SSC Editor (1/21/2016)
Greg Edwards-268690 (1/21/2016)
It seems he has an elephant on 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

January 25, 2016 at 1:53 am

#1854099
RE: Are the posted questions getting worse?

Ed Wagner (1/22/2016)
Greg Edwards-268690 (1/21/2016)
Eirikur Eiriksson (1/21/2016)
Greg Edwards-268690 (1/21/2016)
Steve Jones - SSC Editor (1/21/2016)
Greg Edwards-268690 (1/21/2016)
It seems he has an elephant on the menu, and a 6 quart pot 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 22, 2016 at 9:39 am

#1853838
RE: Are the posted questions getting worse?

SQLRNNR (1/19/2016)
BL0B_EATER (1/19/2016)
Anybody notice the new hair style?
Jabba the Hat.
^{“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 19, 2016 at 9:18 am

#1852821
RE: Are the posted questions getting worse?

rodjkidd (1/19/2016)
Ed Wagner (1/19/2016)
Grumpy DBA (1/19/2016)
RIP Glenn Frey, co-founder of the Eagles. Only 67 years old, left this world much too soon.
Did Ramsey play last night?
Yeah, I heard about...
^{“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 19, 2016 at 6:57 am

#1852744
RE: Are the posted questions getting worse?

rodjkidd (1/19/2016)
BL0B_EATER (1/19/2016)
ChrisM@Work (1/19/2016)
BL0B_EATER (1/19/2016)
So I just took a phone call and the chap on the other end says I am "average" at best and wont hit the ground running........
^{“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 19, 2016 at 2:58 am

#1852675
RE: Are the posted questions getting worse?

BL0B_EATER (1/19/2016)
So I just took a phone call and the chap on the other end says I am "average" at best and wont hit the ground running..... uhmmm how can...
^{“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 19, 2016 at 2:34 am

#1852669
RE: Joining Tables with Right Function

Jeff Moden (1/18/2016)
ChrisM@Work (1/18/2016)
Jeff Moden (1/18/2016)
ChrisM@Work (1/18/2016)
Jeff Moden (1/18/2016)[hrCan we agree on "SARGable in one direction only" as it's often sufficient to permit tweaking a decent plan?
With the battles I'm...
^{“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 18, 2016 at 10:06 am

#1852538
RE: Joining Tables with Right Function

Jeff Moden (1/18/2016)
ChrisM@Work (1/18/2016)
Jeff Moden (1/18/2016)[hrCan we agree on "SARGable in one direction only" as it's often sufficient to permit tweaking a decent plan?
With the battles I'm currently facing at...
^{“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 18, 2016 at 8:05 am

#1852521
RE: Joining Tables with Right Function

ChrisM@Work (1/18/2016)
Jeff Moden (1/18/2016)[hrCan we agree on "SARGable in one direction only" as it's often sufficient to permit tweaking a decent plan?
With the battles I'm currently facing at work on...
^{“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 18, 2016 at 7:59 am

#1852518

Viewing 15 posts - 1,816 through 1,830 (of 10,143 total)