Viewing 15 posts - 1 through 15 (of 32 total)
Why aren't you using Project Deployment? There's very little we can do to...
November 29, 2018 at 4:39 am
November 29, 2018 at 3:45 am
August 2, 2017 at 5:16 am
WITH C1 AS (
SELECT id, EffectiveDate, Enddate,
CASE...
March 24, 2017 at 3:02 am
Luis Cazares (6/22/2016)
June 23, 2016 at 1:16 am
"severe damage"?
How many rows are you expecting the query to return, and what consumes those rows?
250 MILLION
June 23, 2016 at 1:12 am
ChrisM@Work (6/22/2016)
SELECTa.ID, a.TestDate, a.Score,
b.dt AS dates
FROM Calendartable b
OUTER APPLY (
SELECT TOP 1 a.ID, a.TestDate, a.Score
FROM testdata a
WHERE a.TestDate <= b.dt
ORDER BY a.TestDate DESC
) a
Test data is huge...
June 22, 2016 at 9:53 am
can anybody suggest me some links to learn processing the xml in sql ?
May 9, 2016 at 10:57 pm
Any example driven links to learn the xml querying techniques?
April 29, 2016 at 12:20 am
any set based approach? with out using cross apply ?
April 28, 2016 at 4:15 am
J Livingston SQL (4/26/2016)
SQL developer edition is now available freehttp://www.sqlservercentral.com/blogs/another-sql-geek/2016/04/01/sql-developer-edition-is-now-free/
thanks my dear friend.. you are amazing. How may I aware about all the latest news about SQL server as...
April 26, 2016 at 4:23 am
Hugo Kornelis (1/6/2016)
January 6, 2016 at 5:18 am
So you can reference it by either substream1 or substream2? Regardless this is pretty much a typical recursive cte. There are thousands and thousands of examples of how to...
September 16, 2015 at 3:14 am
Viewing 15 posts - 1 through 15 (of 32 total)