Sorry just realised the above won't work for all values, will post back when I've worked it out

Try this as your field expression:

=((Fields!hours.Value-Fields!hours.Value Mod 24) / 24) + (Fields!hours.Value Mod 24)/10

Changing the field name as appropriate, obviously

Try this:

select DATEADD(dd,-1,DATEADD(mm,3,DATEADD(qq, DATEDIFF(qq,0,DATEADD(mm,-3,getdate())), 0))),
       DATEADD(dd,-1,DATEADD(mm,3,DATEADD(qq, DATEDIFF(qq,0,DATEADD(mm,-6,getdate())), 0)))

What about this:

select DATEADD(qq, DATEDIFF(qq,0,DATEADD(mm,-3,getdate())), 0),
       DATEADD(dd,-1,DATEADD(mm,3,DATEADD(qq, DATEDIFF(qq,0,DATEADD(mm,-3,getdate())), 0)))

select * from yourTable

where dateadd(yy,18,convert(varchar(10),dob,112)) < getdate()

There are problems rendering to Excel, depending on the version of Excel you are using.

Have you installed the Reporting Services service pack?

If not its here:

http://www.microsoft.com/downloads/details.aspx?FamilyId=580FEBF7-2972-40E7-BCCF-6CD90AC2F464&displaylang=en

There are two ways to do this:

1. From the Build menu in Visual Studio

2. From the command-line useing the rs utility and a script

From your question I assume you nned...

You don't need to select anything.

In your updated event handler do this :

object newid = args.Row["<your id column name here>"] ;

HTH

You'll need to use the InStr function eg.

Iif( InStr("CPRVX", Fields!COST_ELEM_CTGY.Value)>0 , ...

See docs here:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vblr7/html/vafctinstr.asp

Try this, creates a temporary table (#tmp), populates it with the output from 'sp_helpdb' using EXEC.  You can then select from the  temp table as normal :

create table #tmp...

You can fix the orginal timeout by setting the SqlCommand.CommandTimeout property in your code, the default is 30 seconds. See http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfsystemdatasqlclientsqlcommandclasscommandtimeouttopic.asp

But as Ray said you should definitely review the...

I am assuming you have RS installed and you want to deploy reports, if so you can use the tools provided with RS, look in the Reporting Services books online...

There are some useful encryption/decryption functions here:

http://www.sqlservercentral.com/scripts/contributions/610.asp

Not pleasant looking I admit but the following logic (or some variant of it) may do what you want:

insert into myTable (id) select coalesce(max(id)+1,0) from myTable

The coalesce is required simply...

Oops! Sorry about the typo