ChrisM@Work

Forum Replies Created

Viewing 15 posts - 1,591 through 1,605 (of 10,143 total)

RE: Split string using multiple delimiters

Iwas Bornready (5/18/2016)
Thanks for the script.
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

May 18, 2016 at 6:47 am

#1879819
RE: Split string using multiple delimiters

Interesting - does this work out faster than using the REPLACE function?
;WITH N1 (n) AS (SELECT 1 UNION ALL SELECT 1),
N2 (n)...
^{“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

May 18, 2016 at 2:16 am

#1879756
RE: Are the posted questions getting worse?

Brandie Tarvin (5/16/2016)
Regarding the federal guidelines for bathroom use... I didn't want to start a fight on The Thread. I posted the news because I thought it was good news,...
^{“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

May 16, 2016 at 5:30 am

#1879194
RE: Query to compare two views and find non-matching record ??

Have you tried this?
;WITH
CTE1 AS (
SELECT [Emp_no.], Org_Code, Org_Num FROM #Employee
EXCEPT
SELECT [Emp_no.], Org_Code, Org_Num FROM #Class
), CTE2 AS (
SELECT [Emp_no.], Org_Code, Org_Num FROM #Class
EXCEPT
SELECT [Emp_no.], Org_Code,...
^{“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

May 13, 2016 at 9:41 am

#1878951
RE: Are the posted questions getting worse?

Luis Cazares (5/13/2016)
ChrisM@Work (5/13/2016)
Sean Lange (5/13/2016)
Brandie Tarvin (5/13/2016)
For those who hadn't heard, THIS happened.
Yay.
EDIT: I should add I'm not trying to start a debate. I just wanted to pass along...
^{“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

May 13, 2016 at 9:34 am

#1878946
RE: Are the posted questions getting worse?

Sean Lange (5/13/2016)
Brandie Tarvin (5/13/2016)
For those who hadn't heard, THIS happened.
Yay.
EDIT: I should add I'm not trying to start a debate. I just wanted to pass along the news.
IMHO people...
^{“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

May 13, 2016 at 9:16 am

#1878942
RE: Query to compare two views and find non-matching record ??

rk1980factor (5/13/2016)
Looks like this query displays the correct result but it display on separate window. i want one query which will show me one result:
SELECT [Emp_no.], Org_Code, Org_Num FROM #Employee
EXCEPT...
^{“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

May 13, 2016 at 8:20 am

#1878917
RE: Need help on Sorting...

viralbpandya (5/13/2016)
is it possible to sort data other way?
Death by function!
Functions are overused in this query. The two most significant consequences are obfuscation, which is sometimes good but not...
^{“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

May 13, 2016 at 5:39 am

#1878872
RE: Query to compare two views and find non-matching record ??

rk1980factor (5/12/2016)
Chris, Looks like you solution might work. Only point i forgot to mention was that both the views(tables) are in different database
On the same server? Then use three-part naming....
^{“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

May 12, 2016 at 10:05 am

#1878713
RE: Query to compare two views and find non-matching record ??

rk1980factor (5/12/2016)
1) I was referring to following query which you suggested to resolve the original problem at the top in the first post, this query does not solve the problem
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

May 12, 2016 at 9:42 am

#1878707
RE: Query to compare two views and find non-matching record ??

rk1980factor (5/12/2016)
this query is incorrect, looks like you mixed up org_code with city
also beside that it gives me emp_no : 43232 in the result which is incorrect since combination of...
^{“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

May 12, 2016 at 8:11 am

#1878677
RE: Query to compare two views and find non-matching record ??

-- get rows which are unique to Employee:
SELECT Emp_no, Org_Code, Org_Num FROM [dbo].[Employee]
EXCEPT
SELECT Emp_no, Org_Code, Org_Num FROM [dbo].[Class]
-- get rows which are unique to Class:
SELECT Emp_no, Org_Code, Org_Num 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

May 12, 2016 at 7:01 am

#1878551
RE: Are the posted questions getting worse?

BLOB_EATER (5/12/2016)
Is it wrong that I no longer have the desire to do SQL certification exams? Do I need to look in the mirror and slap myself very hard?
Don't...
^{“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

May 12, 2016 at 1:47 am

#1878452
RE: A deadlock issue that killing me dead

douglasbrown880 (4/14/2016)
Here you go.
This is from a different app server and database, however the issue is the same
It's an estimated plan - can you post an actual plan?
^{“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

May 11, 2016 at 3:54 am

#1878088
RE: Are the posted questions getting worse?

Sean Lange (5/10/2016)
ChrisM@Work (5/10/2016)
Sean Lange (5/10/2016)
ChrisM@Work (5/10/2016)
Sean Lange (5/9/2016)
So I brought back some yummy foods from New Orleans. I got some crawfish and pork sausage, some gator and pork sausage...
^{“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

May 10, 2016 at 8:38 am

#1877814

Viewing 15 posts - 1,591 through 1,605 (of 10,143 total)