Yes, it is possible to do what you want, but it's both difficult and a bad idea.

You should use the dataset from your query and do that kind of thing...

I'm not sure, but it's probably possible.

However, I can see all kinds of problems coming up from it, even if it is possible. What happens if one of the...

Good...

I was including the dropserver/addserver step as part of the rename step.

The current server doesn't have any SSIS packages running, so I don't have to worry about those.

I'll check the...

Okay, I definitely have mixed...

SQL Server probably has all the tools you need already available.

My first suggestion would be to post the table definition, the stored procedure, and some sample data here, and see...

Try using DateDiff(second, T1, T2), then divide by 3600 to get hours, then divide the modulus of that by 60 to get minutes, then use the modulus to get seconds.

My...

jcrawf02 (4/15/2010)

---

Yes,...

I should blog, but not at work. Just never seem to have the time for it. Too busy with all the things I should blog about. 🙂

seeteshh (4/15/2010)

---

Its excel limitations of having just 65536 records in one sheet.

The code must be modified if pulling data into excel exceeds 65536 records without storing header info else its...

You can use DateDiff to get that.

Here's a sample. Doesn't do the whole job, but should get you started:

CREATE TABLE #T (

ID INT IDENTITY PRIMARY KEY,

T1 NVARCHAR(50),

T2 NVARCHAR(50));

INSERT INTO...

Are you using table-level partitioning, or a federated (partitioned) view?

For a view, you'll need to have the table physically split, and have a column in the table that uniquely identifies...

If the report server login can't access the images, the reports won't be able to either.

James Stover (4/14/2010)

---

GSquared (4/14/2010)

---

kevin77 (4/13/2010)

---

GSquared's comment is a good one, but I'm still waiting for Microsoft or someone else to write a plug-in that warns you if you try to...

Switch to a Nested Sets hierarchy, and it will do all that and more.

Here's an article that will help explain some ways to implement this: http://www.sqlservercentral.com/articles/T-SQL/65540/

If you have questions after...