Forum Replies Created
Viewing 15 posts - 91 through 105 (of 1,439 total)
-
Reply To: Query Help Pivot
Try this
with src as (
select day,budgethead,sum(amount) as amount,row_number() over(partition by day order by budgethead) as rn
from [dbo].[exp]
group by day,budgethead
)
select isnull(max(case when day=1 then budgethead end),0) as Day1,
...____________________________________________________
Deja View - The strange feeling that somewhere, sometime you've optimised this query before
How to get the best help on a forum
http://www.sqlservercentral.com/articles/Best+Practices/61537
-
Reply To: Selecting non-overlapping Date Ranges
This is a gaps and islands problem
WITH Src AS (
SELECT SampleDate, SampleValue,
ROW_NUMBER() OVER(ORDER BY SampleDate) -
ROW_NUMBER() OVER(PARTITION BY SampleValue ORDER BY SampleDate) AS grp
FROM #SampleRanges
)
SELECT MIN(SampleDate) AS...____________________________________________________
Deja View - The strange feeling that somewhere, sometime you've optimised this query before
How to get the best help on a forum
http://www.sqlservercentral.com/articles/Best+Practices/61537 -
Reply To: How to find a set of sequential values within a list
Not a full solution, but see if this helps
WITH Src AS (
SELECT VEHICLEID,LAT,LON,MSGDATE,MSGTIME,SPEED,CRETIME,
DATEADD(SECOND,MSGTIME,CAST(CAST(MSGDATE AS VARCHAR(8)) AS DATETIME)) AS MSGDATETIME,
ROW_NUMBER() OVER(PARTITION BY VEHICLEID ORDER BY MSGDATE,MSGTIME) AS rn
FROM...____________________________________________________
Deja View - The strange feeling that somewhere, sometime you've optimised this query before
How to get the best help on a forum
http://www.sqlservercentral.com/articles/Best+Practices/61537 -
Reply To: Create objects under multiple schemas
Have you looked at synonyms for this?
____________________________________________________
Deja View - The strange feeling that somewhere, sometime you've optimised this query before
How to get the best help on a forum
http://www.sqlservercentral.com/articles/Best+Practices/61537 -
RE: Recursive CTE Duplication
Is this what you're after?
WITH CTE AS (
SELECT ID as Descendent,ID AS TOPBU,Parent
FROM #TEMPUNION ALLSELECT c.Descendent,t.ID,t.Parent
FROM #TEMP t
INNER JOIN CTE...____________________________________________________
Deja View - The strange feeling that somewhere, sometime you've optimised this query before
How to get the best help on a forum
http://www.sqlservercentral.com/articles/Best+Practices/61537 -
RE: Alternative for OCI(Oracle Call Interface) to bulk insert records
For .NET use SqlBulkCopy, for native e.g. C/C++ use BCP ODBC.
____________________________________________________
Deja View - The strange feeling that somewhere, sometime you've optimised this query before
How to get the best help on a forum
http://www.sqlservercentral.com/articles/Best+Practices/61537 -
RE: For XML question
This will sort of give you what you want, but you have to be able to order your results and also what happens with more than 3 items. If you...____________________________________________________
Deja View - The strange feeling that somewhere, sometime you've optimised this query before
How to get the best help on a forum
http://www.sqlservercentral.com/articles/Best+Practices/61537 -
RE: XML XQuery shred into fully encapsulated individual rows
There's a ton of info here
https://docs.microsoft.com/en-us/sql/xquery/xquery-language-reference-sql-server?view=sql-server-2017____________________________________________________
Deja View - The strange feeling that somewhere, sometime you've optimised this query before
How to get the best help on a forum
http://www.sqlservercentral.com/articles/Best+Practices/61537 -
RE: XML XQuery shred into fully encapsulated individual rows
Not sure if this is what you want, it returns the non-L1Data sibling nodes for all rowsSELECT
c.query('
let $a := .
return...____________________________________________________
Deja View - The strange feeling that somewhere, sometime you've optimised this query before
How to get the best help on a forum
http://www.sqlservercentral.com/articles/Best+Practices/61537 -
RE: FOR XML - Remove attributes from FOR XML EXPLICIT
r.gall - Monday, February 11, 2019 8:15 AMEirikur Eiriksson - Monday, February 11, 2019 6:43 AM____________________________________________________
Deja View - The strange feeling that somewhere, sometime you've optimised this query before
How to get the best help on a forum
http://www.sqlservercentral.com/articles/Best+Practices/61537RE: XML
This should do it
SELECT '001' AS "area",
(SELECT --'admin@company.com' AS "notify",
(SELECT 'TELRCM' AS "field/@table", 'COMPANY' AS "field/@field", Company AS "field", null,
'TELRCM' AS...____________________________________________________
Deja View - The strange feeling that somewhere, sometime you've optimised this query before
How to get the best help on a forum
http://www.sqlservercentral.com/articles/Best+Practices/61537RE: XML
Try this
SELECT '001' AS "area",
(SELECT 'admin@company.com' AS "notify",
(SELECT 'TELRCM' AS "field/@table", 'COMPANY' AS "field/@field", Company AS "field", null,
'TELRCM' AS "field/@table", 'POSTCODE'...____________________________________________________
Deja View - The strange feeling that somewhere, sometime you've optimised this query before
How to get the best help on a forum
http://www.sqlservercentral.com/articles/Best+Practices/61537RE: Get all Attributes from this XML
info 58414 - Wednesday, December 12, 2018 8:24 AM____________________________________________________
Deja View - The strange feeling that somewhere, sometime you've optimised this query before
How to get the best help on a forum
http://www.sqlservercentral.com/articles/Best+Practices/61537RE: Get all Attributes from this XML
SELECT 'Attribute ' + t.c.value('local-name(.)', 'varchar(50)') + ' : ' +
t.c.value('.', 'varchar(100)') AS Result
FROM @x.nodes('/SessionStart/*//attribute::*') AS t(c);____________________________________________________
Deja View - The strange feeling that somewhere, sometime you've optimised this query before
How to get the best help on a forum
http://www.sqlservercentral.com/articles/Best+Practices/61537RE: Prevent SQL from locking at the table level
See if this helps
https://support.microsoft.com/en-us/kb/323630
____________________________________________________
Deja View - The strange feeling that somewhere, sometime you've optimised this query before
How to get the best help on a forum
http://www.sqlservercentral.com/articles/Best+Practices/61537Viewing 15 posts - 91 through 105 (of 1,439 total)