That's correct, neither optional parameters nor default values can be defined for User Defined...

Useless

Jeff,

what I've found is that there are two thresholds, one for the well formed XML and other for the CSV to XML, the former is lower than the latter, partly...

Jeff Moden (12/20/2015)

---

Eirikur Eiriksson (12/20/2015)

---

Piling on, while the string splitting method works fine when working with small number of values the performance degrades very quickly when the number of values...

jayaprabhalnt (12/18/2015)

---

Hi,

I am trying to execute 32 bit dtexec from 64-bit ssms.

Give below is the command that i am trying to execute

exec master..xp_cmdshell '\\<RemoteServername>"\D$\Program Files (x86)\Microsoft SQL Server\110\DTS\Binn\dtexec.exe"' / f"\\RemoteServername\C$\\Package3.dtsx"'

I...

Borut Olenik (12/20/2015)

---

hm, ok.

But what if I have dynamic day from - day to and I am doing dynamic filter on my factsales. Because of that once I will...

Piling on, while the string splitting method works fine when working with small number of values the performance degrades very quickly when the number of values increases. If you expect...

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>

...