CREATE PROCEDURE Process.InitiateLoad (@Area VARCHAR(150), @Domain VARCHAR(150), @BusinessDomain (VARCHAR(150), @Stage VARCHAR(100), @SliceDate DATETIME, @Months INT = 0)

AS

you have one to many opening brackets up there.

declare @len int=20declare @table table (id int identity(1,1), strin varchar(202))insert into @table select 'antidisestablishmentarianism' union allselect 'thisisatestfieldof20' union allselect 'elephant' union allselect 'otorhinolaryngological'select len(strin),strin,concat(left(strin,@len),replicate('.',len(strin)-@len)) from @table

Yes , it needs to have a CDATA section. I would have loved to work with  xmlpath instead but   CDATA section is the key here.

I recommend using temp table over table variable  when you are dealing with larger data sets  for performance reasons.  There are some advantage  you have with temp table over table variable....

I am not sure if I understand your question correctly. This could be a simple inner join on the three matching columns. Also it matters when you say the...

ymbaez (10/15/2015)

---

I'm not a fan of this SSIS catalog reports to identify errors for job failures so I had to find a way to modify a report I already had...

This is for Execute Sql Task. Its completely different in OLEDB Source in Data flow task. My issue was in OLEDB Source in DFT.

Guras (8/13/2015)

---

I am implementing CDC to capture some specific column value change in a table. With the value I need to capture who changed the value as well. Unfortunately it...

TBIG (4/8/2015)

---

This is the data source for an ASP.net dropdown list. I need to have a hyphen "-" in the first record of the dropdown list.

When I added this complex...

Start here.

https://www.simple-talk.com/sql/learn-sql-server/introduction-to-change-data-capture-%28cdc%29-in-sql-server-2008/

If you do not use ssis 2012, you need to compose your own sql to do the incremental merge.

saikumar.mca2007 (4/6/2015)

---

Good Evening All,

Currently we are trying to load the xml files into sqlserver tables by using ssis 2012,

We are getting xml files as a column in source table ,so...

ASFAIK- you would need to open the ssis package and refresh it for it pick up the metadata changes.

Eirikur Eiriksson (11/18/2014)

---

Quick solution which uses a recursive CTE, should be enough to get you passed this hurdle

😎

USE tempdb;

GO

SET NOCOUNT ON;

DECLARE @TXML XML =

'<SecureEvent EDate="08/04/2011" ID="47854303" InternalSecureEventID="154472406">

<SecureEventDate>08/04/2011</SecureEventDate>

...

Eirikur Eiriksson (10/15/2014)

---

Done this on exactly the same version/edition and the performance is brilliant so no worries there. One thing to check though is the configuration of tempdb, rule of...

Eirikur Eiriksson (10/15/2014)

---

peacesells (10/15/2014)

---

I am bulk inserting a whole bunch of xml files into a sql table using OPENROWSET. The problem is that this process is really really slow....