ChrisM@Work

Forum Replies Created

Viewing 15 posts - 1,711 through 1,725 (of 10,143 total)

RE: Group Concat

lanky_doodle (3/3/2016)
Hey,
I have a query that is returning 3 rows (because there are 3 owners). I need to concat the 3 owners into a single value, which would return...
^{“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

March 3, 2016 at 4:35 am

#1862688
RE: Are the posted questions getting worse?

TomThomson (3/3/2016)
Has something gone wrong with sending notifications over the last day or two? A lot of new posts on the thread, but I haven't had a single...
^{“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

March 3, 2016 at 1:52 am

#1862651
RE: Are the posted questions getting worse?

Sean Lange (3/2/2016)
Ed Wagner (3/2/2016)
Sean Lange (3/2/2016)
Alan.B (3/2/2016)
Sean Lange (3/2/2016)
Steve Jones - SSC Editor (3/2/2016)
Alan.B (3/1/2016)
Ed Wagner (3/1/2016)
Alan.B (3/1/2016)
jasona.work (3/1/2016)
Ah, using SQL Server DATEDIFF to figure out how many days...
^{“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

March 3, 2016 at 1:46 am

#1862649
RE: Only one expression can be specified in the select list when the subquery is not introduced...

Run the result of the query into a #temp table and reference the temp table in your email body.
^{“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

March 2, 2016 at 1:39 am

#1862293
RE: How to get active records for each date in SQL

The two rows with date '2010-02-04' have FID of 1 and 3. Your desired output lists FID of 2 and 3 for this date.
Can you explain how FID of 2...
^{“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

March 1, 2016 at 5:45 am

#1862072
RE: Merege statement giving performance issue

ravi@sql (3/1/2016)
Hi Champs,
I have a Merge statement which has both insert and update .
But source table is quite huge it is having around 70 million records or 2...
^{“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

March 1, 2016 at 4:31 am

#1862048
RE: Only one expression can be specified in the select list when the subquery is not introduced...

You have one too many SELECTs in there:
IF OBJECT_ID('tempdb..#StockManagement') IS NOT NULL DROP TABLE #StockManagement;
SELECT
STOCKCODE,
CAST(SUM((CASE WHEN TransactionTypeId IN (1, 4, 5, 7, 8, 10, 11, 13, 14) AND...
^{“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

March 1, 2016 at 2:13 am

#1862027
RE: Find Currently Running Query – T-SQL

This exact same query including comments word for word was published by Ian Stirk in 2009.
http://www.sqlservercentral.com/articles/DMV/64425/
[/url]
Edit: 2008 even!
^{“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

February 29, 2016 at 1:57 am

#1861733
RE: Are the posted questions getting worse?

Luis Cazares (2/26/2016)
Ray K (2/26/2016)
Steve Jones - SSC Editor (2/26/2016)
Ed Wagner (2/26/2016)
Sean Lange (2/26/2016)
Ed Wagner (2/26/2016)
Grumpy DBA (2/26/2016)
Hugo Kornelis (2/26/2016)
Grumpy DBA (2/26/2016)
For some unknown reason a terrible song has been...
^{“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

February 26, 2016 at 9:19 am

#1861441
RE: current and time-expired rows.

Then you should try columnstore [/url]indexes too - another weapon in your armoury. I think your sample query could benefit a great deal from a columnstore index.
^{“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

February 26, 2016 at 9:01 am

#1861435
RE: Error with syntax using ;With

There seem to be numerous syntax errors with this part:
IF ( (
@Client = 'Winco Foods'
AND EXISTS ( ;
WITH XMLNAMESPACES('http://www.w3.org/2001/XMLSchema-instance' AS ns)
SELECT
AuditNbr, VndNbr, VndName, CompanyCode, AuditorID,...
^{“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

February 26, 2016 at 8:13 am

#1861408
RE: Character string conversion to date type. char(8) to Date ( from char(8) (23022016) to date(dd/mm/yyyy) (23/02/2016)

ScottPletcher (2/23/2016)
ChrisM@Work (2/23/2016)
spaghettidba (2/23/2016)
There is no built-in CONVERT style that will handle the format DDMMYYYY. This means that you will have to code it yourself. This should do:
CONVERT(date, RIGHT(Date1,2) +...
^{“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

February 24, 2016 at 2:21 am

#1860648
RE: How to find account number of bank from given records in table

MMartin1 (2/23/2016)
ChrisM@Work (2/18/2016)
Nikku (2/18/2016)
Hi All
I have two tables t1 & t2 which contains the same records. t1 is for bank1 & t2 is for bank2
i.e t1
accno name balance
001000 ...
^{“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

February 24, 2016 at 2:17 am

#1860646
RE: Are the posted questions getting worse?

Alan.B (2/23/2016)
I don't know if anyone is aware of this but I noticed Dwain Camps hadn't posted anything in awhile so I checked his blog (dwaincsql.com), simple-talk, twitter, linkedin... then...
^{“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

February 24, 2016 at 2:03 am

#1860644
RE: current and time-expired rows.

Just to clarify, Ben - it's this system you are attempting to tune:
ben.brugman (2/23/2016)
SQL-server 1.
Has been designed from the start with clustered indexes on the subscriberid. And this has...
^{“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

February 23, 2016 at 7:53 am

#1860409

Viewing 15 posts - 1,711 through 1,725 (of 10,143 total)