ChrisM@Work

Forum Replies Created

Viewing 15 posts - 1,501 through 1,515 (of 10,143 total)

RE: Calculating Duration

SELECT *,
[Duration] = DATEDIFF(SECOND, c.TakenDate, c.CompletedDate),
[Response Time] = DATEDIFF(SECOND, c.CreatedDate, c.TakenDate)
FROM #CONSULTATION c
^{“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

June 20, 2016 at 3:49 am

#1885801
RE: Calculate attendance based on another table

ganapathy.arvindan (6/17/2016)
I have table called logininfo where each employee gets on record if he is present on that day..i need ur help to calculate total working days of the month
CREATE...
^{“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

June 17, 2016 at 7:06 am

#1885589
RE: Computed column with leading static number

nilknarf (6/17/2016)
static number (12345) + ID number
What does the 12345 represent?
^{“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

June 17, 2016 at 6:40 am

#1885581
RE: Closest less date

DECLARE @FromDate DATE = CONVERT(DATE,'01.05.2016',104);
WITH Table1 (ItemNr, FromDate) AS (
SELECT 1 , CONVERT(DATE,'01.01.2016',104) UNION ALL
SELECT 1 , CONVERT(DATE,'01.02.2016',104) UNION ALL
SELECT 2 , CONVERT(DATE,'01.01.2016',104) UNION ALL
SELECT 2 , CONVERT(DATE,'01.02.2016',104) UNION ALL
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

June 17, 2016 at 5:16 am

#1885563
RE: Performance difference with filter index and with out filter index

dudekula.kareemulla (6/17/2016)
Hi,
I have a table 'AAA'
Structure:
CREATE TABLE AAA (ID BIGINT PRIMARY KEY CLUSTERED,Name VARCHAR(225) NULL,UAN BIGINT NOT NULL)
Assume that this Table Having 75 million of records.
Here I am going 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

June 17, 2016 at 3:56 am

#1885558
RE: Touble with query using a temp table to compare and update existing table

eleduke (6/16/2016)
2 posts up the sq.png shows the results
When I query the entityname table with a value copied from the namefile table I get the results I was looking...
^{“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

June 16, 2016 at 9:09 am

#1885441
RE: Touble with query using a temp table to compare and update existing table

This remains unanswered:
ChrisM@Work (6/16/2016)
eleduke (6/16/2016)
I checked the raw file and did not see any extra special chr that would cause a LF/CR.. I was using Notepad++ to check it
Choose a...
^{“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

June 16, 2016 at 8:51 am

#1885432
RE: Touble with query using a temp table to compare and update existing table

eleduke (6/16/2016)
ok so
This works fine select * from EntityName e where e.EntityName = '17L-52W7 KVAR'
But this returned nothing select * from namefile n where n.Listname = '17L-52W7 KVAR'
So there seems...
^{“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

June 16, 2016 at 8:14 am

#1885409
RE: Touble with query using a temp table to compare and update existing table

eleduke (6/16/2016)
I checked the raw file and did not see any extra special chr that would cause a LF/CR.. I was using Notepad++ to check it
Choose a single value from...
^{“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

June 16, 2016 at 7:57 am

#1885402
RE: Touble with query using a temp table to compare and update existing table

Check your column names.
What does the staging table contain? select * from namefile.
^{“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

June 16, 2016 at 7:11 am

#1885386
RE: Problem with update in procedure

Terje Hermanseter (6/16/2016)
Both tests should produce the same results, are you 100% sure you executed the statements in the same order as listed in your post?
Unable to repeat OP's results...
^{“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

June 16, 2016 at 4:34 am

#1885332
RE: Are the posted questions getting worse?

jasona.work (6/15/2016)
/me jiggles door handle...
/me knocks softly, tries to open door...
/me pokes head into room, quietly calls out "hello? Anybody here?"
/me leaves when no one answers...
Is this you testing...
^{“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

June 16, 2016 at 2:13 am

#1885319
RE: Dynamic SQL

astrid 69000 (6/15/2016)
Hi 🙂
I am trying to build a procedure that given a table name will do a select from that table...
Just curious...since EXEC DailyReport_sp 'MyTablename' is exactly equivalent 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

June 15, 2016 at 5:52 am

#1885122
RE: Syntax error using WITH

;WITH MyOne AS (yada yada yada)
INSERT INTO #dummy1
(tqm_call_data_id, std_questions_selected, Dept, call_reference_no)
SELECT tqm_call_data_id, std_questions_selected, Dept, call_reference_no
FROM MyOne
^{“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

June 15, 2016 at 2:00 am

#1885093
RE: find substring...and count...

llouw1 (6/14/2016)
I have read the article...and I really cannot see the link between my question and the article.
Kingston's link doesn't work for me either.
Find section [Figure 22: Testing Functionality]...
^{“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

June 14, 2016 at 7:51 am

#1884898

Viewing 15 posts - 1,501 through 1,515 (of 10,143 total)