The error clearly mentions that you are trying to attach a database with the same name that already exists. There is nothing wrong with SSMS doing that.

something like this??

DECLARE @Input TABLE

(

col1 INT,

col2 INT,

col3 VARCHAR(3),

col4 VARCHAR(3),

col5 VARCHAR(3)

)

INSERT INTO @Input VALUES(1, 122, 'AAA', null, null),(2, 122, null, 'BBB', null),(3, 122, null, null, 'CCC'),

(4, 156, null, 'BBB', null),...

Jack Corbett (5/2/2014)

---

Parameter sniffing won't cause the results returned to be incorrect it can cause a sub-optimal plan to be used skewing performance. If parameter sniffing causes...

If you are talking about restoring from a backup or attaching a data warehouse, I would say its quite straight forward and simple... There is no such thing like installing...

Yes using SSIS you can do this.

Are you using this query inside a stored procedure? If so there might be an issue of Parameter Sniffing.. Check in relation with that..

something like this... may be you need to modify it accordingly..

DECLARE @SomeData TABLE

(

FirstName varchar(25)

, MiddleName varchar(25)

, LastName varchar(25)

, StreetAddress varchar(25)

, Suite varchar(25)

, City varchar(25)

, [State] varchar(25)

, PostalCode varchar(10)

,...

Have you tried the concept of drilldown in ssrs? Read this article I wrote on creating a drill down report .. http://sqlsaga.com/ssrs/how-to-create-a-drill-down-report-using-ssrs/[/url]

can you show us some sample output...

are you passing the value of the select statement to a result set or a Output parameter? Using a result set would be the best option to pass it to...

see this if it helps... http://stackoverflow.com/questions/15725086/visual-studio-2012-wont-let-me-debug

Thank you Keith for the fast reply.. 🙂

I think you should change the last two line to this

where last_run_outcome <> 1',

@body_format = HTML

You can use precedence constraints in SSIS and have an expression over it to do this.

something like this should work

= "For " & MonthName(Month(Today())) & " " & YEAR(Today())