pietlinden (11/19/2013)

---

If you're fairly new to SQL, I would do this in SSRS, because you can get SSRS to do pretty much all the hard work for you (sorting, grouping,...

No

This could do this trick:

IF OBJECT_ID('tempdb..##ssrs_candidates') IS NOT NULL DROP TABLE ##ssrs_candidates;

CREATE TABLE ##ssrs_candidates (c_id int identity, ssrs_db varchar(100));

EXEC sp_msforeachdb'

INSERT INTO ##ssrs_candidates

SELECT TABLE_CATALOG

FROM [?].information_schema.columns

WHERETABLE_NAME =''Catalog''

ANDCOLUMN_NAME =''ItemID''

ANDORDINAL_POSITION =1

ANDDATA_TYPE=''uniqueidentifier''

'

SELECT * FROM...

krish.sett (8/3/2011)

---

Thanks for the info.....so basically i need to create a XSLT file for my XML file so that i can use XML Task Editor for the conversion.

This is really...

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...