You can use the SSIS XSLT task. It is not well documented but here...

dastagiri16 (11/19/2013)

---

hi,

I have a table class

classname section Marks

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

first a ...

Keeping in mind that maintenance plans are SSIS packages you could start here: Importing and Exporting Packages.

In SQL Server 2008 Your maintenance plans usually live in msdb.dbo.sysssispackage.

FYI: This...

ahperez (11/14/2013)

---

The optimizer doesn't know the value of the variable in the second query it is changing the query plan to use a clustered index scan rather than a seek...

First, here's the problem (looking at the 45 sec plan):

This looks like parameter sniffing; your cardinality estimates are messed. Your query is scanning an index that has 5M+ rows to...

Edward Boyle-478467 (11/14/2013)

---

If OBJECT_ID('TEST_procedure','P') is not Null Drop procedure TEST_procedure

Go

create procedure TEST_procedure

@exampleid XML

as

update tablea

set text_field = 'Y'

where

example_id in (Select x.value('(.)','varchar(100)') from @exampleid.nodes('/List/Field/text()') as x(x))

Go

If object_id('tablea') is Not Null Drop...

subbareddy542 (11/13/2013)

---

hi,

first can u create one function to use below code.

CREATE FUNCTION SPLIT(@VAL VARCHAR(MAX))

RETURNS @T1 TABLE(COL1 VARCHAR(MAX))

AS

BEGIN

WHILE CHARINDEX(',',@VAL)>0

BEGIN

INSERT INTO @T1 VALUES(SUBSTRING(@VAL,1,(CHARINDEX(',',@VAL))-1))

SET @val=SUBSTRING(@VAL,(CHARINDEX(',',@VAL))+1,LEN(@VAL))

END...

It sounds like you are trying to do a drill-through report. This should get you started:

Drillthrough Reports (Report Builder 3.0 and SSRS)

Dhruvesh Shah (11/12/2013)

---

Hi,

I have a table as per below.

CREATE TABLE #TEMP

(

ID NVARCHAR(200) NOT NULL,

SIMNO NVARCHAR(200) NULL,

IMEI NVARCHAR(200) NULL

)

iNSERT INTO #TEMP VALUES ('0412345678','0412345678','013275009174916')

iNSERT INTO #TEMP VALUES ('013275009174916','0412345678','')

iNSERT INTO...

Shaun2012 (11/12/2013)

---

We are moving from SQL 2008 to 2012. What are the big differences... As we have lot of packages around 30-40. To migrate these packages into 2008, what should...

Paul Treston (11/11/2013)

---

Hello there,

I'm currently working on extracting a load of xml elements out of a dynamic blob of xml. I have over 100 columns nailed down but 1 column...

Shadab Shah (11/11/2013)

---

Hi Floks,

I am trying to get my hands dirty with XML in SQL Server. I have tried MSDN and some other links which google suggested but i think...

Using DelimitedSplit8k (link in my signature), you could accept a delimited list like so:

use tempdb;

-- create tablea for demo

IF OBJECT_ID('tempdb..tablea') IS NOT NULL drop table tablea;

CREATE TABLE tablea(id int identity...

timvil (11/11/2013)

---

Thanks MM for your fast reply!

However I didn’t get it to work. Maybe problem is in Column1 data type, it is ntext. I read somewhere that it couldn’t be...

First, in the future try including your sample data like this:

DECLARE @Store TABLE (s_yr int, s_mo tinyint, storeName varchar(10))

DECLARE @Store_Sales TABLE (s_yr int, s_mo tinyint, storeName varchar(10), NumberOfSales int)

INSERT...