ChrisM@Work

Forum Replies Created

Viewing 15 posts - 1,846 through 1,860 (of 10,143 total)

RE: Are the posted questions getting worse?

Phantom forum post!
Go to this thread
Click on the Quote button
Scroll down to view earlier posts (click on the [+] icon if necessary)
^{“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 7, 2016 at 6:16 am

#1850160
RE: How to insert data from localdb to amazon redshift?

sqlbidev (7/7/2015)
Hi,
I have a populated table on my local machine, I have created the linked server and connection is working fine.
I have also created the same table on redshift...
^{“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 7, 2016 at 6:13 am

#1850159
RE: Today's Random Word!

Grumpy DBA (1/7/2016)
Ed Wagner (1/7/2016)
Stuart Davies (1/7/2016)
Belated?
Late
Pregnant
paws
^{“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 7, 2016 at 5:55 am

#1850155
RE: Longest Common Substring in an ITVF

Eirikur Eiriksson (1/5/2016)
For a laugh, I'm just going to post a query I wrote yesterday based on some work I did years ago
Very fast code! It wouldn't take much tweaking...
^{“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 6, 2016 at 4:20 am

#1849789
RE: Longest Common Substring in an ITVF

Hi Alan, nice job 🙂
Here's a completely different take on the problem, loosely based on some fuzzy matching stuff I've worked on over the years. It looks promising and you...
^{“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 5, 2016 at 8:43 am

#1849546
RE: LEAP and LAG behind the scenes

rs80 (12/23/2015)
Sorry, there isn't any source code that I have. It's more of a theoretical question. What's the best way to learn how these functions work behind the scenes?...
^{“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

December 23, 2015 at 8:19 am

#1847763
RE: Are the posted questions getting worse?

Brandie Tarvin (12/23/2015)
Thank you, everyone for the sympathy. She's getting her surgical biopsies today and we'll know in a week. The SO is kind of moping around (she's his cat)...
^{“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

December 23, 2015 at 6:49 am

#1847709
RE: How to add record on linked server

chris92mars (12/22/2015)
I tried to add a new record on the linked server but it fail.
The Errror is Column Name or number of supplied values does not match the table...
^{“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

December 23, 2015 at 3:05 am

#1847663
RE: Are the posted questions getting worse?

Brandie Tarvin (12/22/2015)
Sorry to interrupt a valuable discussion on posters, but I need some sympathy.
Cancer cat (Formerly had a sarcoma removed) now needs to go back in for some surgical...
^{“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

December 23, 2015 at 1:20 am

#1847649
RE: Are the posted questions getting worse?

Phil Parkin (12/22/2015)
It seems that everyone in this thread spends their spare time shooting things :exclamationmark::-D
Usually, yes
>>>>>------------------->
^{“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

December 23, 2015 at 1:18 am

#1847648
RE: Calculating a Year Number and Sequence number using a date field

Something along these lines should do the trick, however I'd recommend you don't do it. If the number you are storing with the date of the visit is of any...
^{“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

December 22, 2015 at 3:06 am

#1847370
RE: Duplicates After Self Join

This should get you started:
SELECT *
FROM workorders i
CROSS APPLY (
SELECT *
FROM workorders tc
WHERE tc.JobType = 'TC'
AND tc.AccountNumber = i.AccountNumber
AND tc.ScheduledDate BETWEEN i.ScheduledDate AND DATEADD(DAY,30,i.ScheduledDate)
) x
WHERE i.JobType...
^{“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

December 17, 2015 at 9:50 am

#1846610
RE: Pivot query using dates between 2 dates

Tallboy (12/17/2015)
Hi Chris,
Wow, thank you so much... looks the business!
I had been reading about the Tally Tables but can't claim to understand it!
I copied and pasted you code into...
^{“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

December 17, 2015 at 5:08 am

#1846519
RE: Pivot query using dates between 2 dates

-- make up some sample data to work with
DROP TABLE #Sample;CREATE TABLE #Sample (NStartDate DATE, ApptTime TIME, Duration SMALLINT, Frequency SMALLINT, ClientID INT, NEndDate DATE)
INSERT INTO #Sample (NStartDate, ApptTime, Duration,...
^{“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

December 17, 2015 at 4:05 am

#1846512
RE: Help with CONCAT

CONCAT is designed for stuff on the same row. For concatenating stuff from different rows you need an alternative approach, most of which are covered in Aaron Bertrand's article here.
Try...
^{“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

December 17, 2015 at 3:26 am

#1846506

Viewing 15 posts - 1,846 through 1,860 (of 10,143 total)