Well...SSRS is a reporting service that uses a myriad of web services and web pages. IIS is the service that hosts those web services and pages. I don't really understand...

You will need to use an update trigger. In this trigger are two virtual tables (inserted and deleted). Inserted is the new values and deleted contains the values prior to...

I think you asking if you can find out which SSIS package is inserting data? I don't know of any way to do that. You will most likely have to...

The problem is right here

You define the variable but nothing is assigned to it so at this point it's value is NULL. NULL + anything will...

-- Insert statements for procedure here

declare @cols nvarchar(150)

declare @pivotIn ...

tfifield (3/9/2011)

---

jojupi01,

You can't use a variable in an IN () construct. It's one of those things we've all wished for. You will have to do the whole query...

nevermind, I missed the grouping. Gus's is the correct way. I misread and thought you were just looking for a total count. :blush:

I assume this is a bit field?

select COUNT(*) - sum(cast(c2 as Int)) as Zero,

sum(cast(c2 as Int)) as One

from table1

Use the technique I showed you above and then just remove the columns you don't want to show.

pawan.boyina (3/9/2011)

---

Please provide a query which would be similar to......which would be helpful for table containing more number of columns and you want to remove few.

select * from a table...

That looks pretty good. Now just execute it.

take a look at sp_executesql

I don't think you want the hardcode group, that is why you are passing it in. Other than you just need to execute it.

you pretty much did it above...

just change your variable names to ones that work and use the insert.

You showed using dynamic sql in your first post. Just modify that insert to use variable names instead of the hardcoded ones and execute it.

set @sql = 'insert ' +...