Missing root note reference and root note namespace

😎

Another way is to use XMLNAMESPACES

DECLARE @TXML XML...

decreale (1/12/2016)

---

I am trying to execute the following script but need to pass two parameters, I'm not sure how too, I know the script works with a stored procedure not...

You are very welcome.

😎

Hugo Kornelis (1/11/2016)

---

GilaMonster (1/10/2016)

---

Sure, with the same general idea.

t1 INNER JOIN t2 on t1.Col1 = t2.Col2 OR t1.Col1 = t2.Col3 OR t1.Col1 = T2.Col4

Don't know what the performance will be,...

Steve Jones - SSC Editor (1/11/2016)

---

Grant Fritchey (1/11/2016)

---

Continuing my role as the harbinger of death, Ziggy Stardust is no more.

One of my favorite songs. Although Bauhaus actually did it...

Match

have2much (1/11/2016)

---

I want to do this because dbcc command waits for very long time with waittype CXPACKET, when I tried running it with MAXDOP 1 all the wait time is...

Lynn Pettis (1/11/2016)

---

Eirikur Eiriksson (1/10/2016)

---

rahulsahay123 (1/8/2016)

---

I am getting a data feed with date column of type integer.Format is mmddyyyy.

Values are like : 01092015

Now i want to convert...

And here as an inline table-valued function

😎

USE tempdb;

GO

SET NOCOUNT ON;

GO

IF OBJECT_ID(N'dbo.ITVFN_GET_LAST_THREE_BUSINESS_DAYS') IS NOT NULL DROP FUNCTION dbo.ITVFN_GET_LAST_THREE_BUSINESS_DAYS;

GO

CREATE FUNCTION dbo.ITVFN_GET_LAST_THREE_BUSINESS_DAYS

(

@TODAY DATE

)

RETURNS TABLE

WITH SCHEMABINDING

AS

---------------------------------------------------------------------

-- 2016-01-11 Eirikur Eiriksson

--...

fara (1/11/2016)

---

Hi Guys, I need your help, I'm trying to create a script that will get Current 3 Business days data, what's the best approach please?

Today is 11/01/2016- Monday

I need...

RIP Major Tom

😎

That would be me, the OP doesn't help, so far your responses have been calmer than mine;-)

😎

Cannot help it when seeing the ads for the Surface to think of "scratch the ..."

😎

Now it's time for you to post the full requirements and all...

Quick thought, 3Gb for a W2K12 Server is pretty meagre especially if there is any other activity than the SQL Server Service active, RDP should be a no-no and SSIS...