Quick suggestion, add a [SALES_MONTH] column to the a date dimension with the offset of 1 day for the month.

😎

USE tempdb;

GO

SET NOCOUNT ON;

DECLARE @START_DATE DATE = '2014-01-01';

DECLARE @END_DATE ...

Alan.B (12/16/2015)

---

I was being lazy.

I'm not disagreeing with you but have you ever seen that kill performance in SQL Server? I'm curious - I have never seen a performance...

Phil Parkin (12/16/2015)

---

Would you be so good as to provide an expanded example of the XML source data which includes multiple custom field definitions? Makes it easier for people to...

Ed Wagner (12/16/2015)

---

WayneS (12/16/2015)

---

Jeff Moden (12/16/2015)

---

Steve Jones - SSC Editor (12/15/2015)

---

Jeff Moden (12/15/2015)

---

@steve-2,

According to your blog, you might show up in Cleveland SQLSaturday for 2016. Any way of knowing...

Simplest way of writing this query would be a single nodes method on an XML variable

😎

DECLARE @TTXML XML = '<?xml version="1.0" encoding="UTF-8"?>

<StaffingOrder>

<OrderId validFrom="12/31/2015" validTo="12/31/2015">

<IdValue>JNJNJP00040440</IdValue>

...

Alan.B (12/15/2015)

---

another way...

DECLARE @x XML = '<?xml version="1.0" encoding="UTF-8"?>

<StaffingOrder>

<OrderId validFrom="12/31/2015" validTo="12/31/2015">

<IdValue>JNJNJP00040440</IdValue>

<Status>Submitted</Status>

</OrderId>

<StaffingPosition>

<CustomFields>

...

Jack Corbett (12/15/2015)

---

2 things:

1. That joke fell short 😀

2. I'm not sure Rodders is...

This should get you started

😎

USE tempdb;

GO

SET NOCOUNT ON;

DECLARE @JobInvoicePayload XML =

'<ns2:updateSourcingJobInvoiceRequest xmlns="http://www.tagcmd.com/beans/schema/ebs/jobInvoice" xmlns:ns2="http://www.tagcmd.com/beans/schema/ebs/jobInvoiceService">

<JobInvoiceDtls>

<MUNumber>60040132</MUNumber>

<InvoiceNumber>10000001</InvoiceNumber>

<Currency>GBP</Currency>

...

Welsh Corgi (12/13/2015)

---

How do I get out of this mess?

BACKUP LOG [PrismData] TO DISK = N'E:\Backup\PrismData_backup_2015_12_13_042945_6506526.trn' WITH NOFORMAT, NOINIT, NAME = N'PrismData_backup_2015_12_13_042945_6506526', SKIP, REWIND, NOUNLOAD, COMPRESSION, STATS...

We go travelling and take out a travel insurance, we insure our houses, our lives etc. but regularely fail to take even the most elementary measures when it comes to...

Jeff Moden (12/12/2015)

---

Someone is going to have to rewrite the proc to use iTVFs instead of scalar functions. It's the only way other than using something like a Temp...

ThomasRushton (12/11/2015)

---

Grant Fritchey (12/10/2015)

---

Grant Fritchey (12/10/2015)

---

That is beautiful. The sad thing would be...

Quick suggestion, use CASE instead of IF

😎

Too busy for RTFM

😎

hila.bar (12/8/2015)

---

SQL Server 2012 with SQL Server Data Tools installed on Windows 7. I have a very large SSIS package with many components. A specific Data Flow task throws this...