is this a stored proc?

if so, extend the variable declaration to accept the additional text.

this works in excel, sure it would in SSRS

get minutes EG(120)/1440 =0.08

format as HH:MM =02:00

Another option apart from all listed above is an aggregated table. All this does is stores the calc result by the group by you select/chose.

As a rule of thumb, you...

think I remember this error.

copy the URL

right click brower and run as Administrator

once open grant access to your user role

hope this works

Some more details would help...

Under the 'Web Service URL' tab, it should give you the URL link

Howdy,

My 2 cents is build now to scale later.

Store data on the most granular level.

Based on your requirements, cubes will be ideally suited.

Different dimensions can later be added to view...

Ian Scarlett (3/25/2011)

---

Almost every post I have seen from Celko has been arrogant, dismissive and...

An alternate to the row_number() function would be to create a table with an identity (1,1) column.

All we are trying to acheive is a sequential increase by 1, which the...

This was the original version that I created.

The only difference is, should it fail eg space limitations, it will not give the effected DB.

By adding '@DBName' + errormessage() on the...

Hi Ken,

Sorry about that.

please try below:

USE [master]

GO

/****** Object: StoredProcedure [dbo].[USP_BackupDatabasesOnPr01] Script Date: 02/14/2011 09:04:17 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

alter Proc [dbo].[USP_BackupDatabasesOnPr01] -- exec USP_BackupDatabasesOnPr01 'V:\Data\January...

Pleasure bud,

I'm glad you can use it.

Yes you can,

But give it a shot and post for any assistance reqiured.

EML (1/12/2011)

---

Hi Shanu,

I'm really sorry i did not reply to your message straight away.

I did get it all working in the end. Very similar to the code above.

If you need...

Pleasure,

If your table is rather large, I would insert the subquery in a temp table.

thank you very much..........

still i need to refine like this........here we r printing year,mth,day in a single column..can u tell how to put that yr,mth,day in a seperate columns..

can...