Many Thanks

regards

P

Many Thanks

P

Thanks,

yeah the length function does work is some cases where users have made a typo.

There must be some way of splicing up the date so you can check...

Ten Cen, what a douch I am.

I mean Scott,

Soz dude. :hehe::hehe:

Thanks for all your help.

I'd need never be puzzled by this again.

Thanks especially to Ten Cen. you make it sound so simple when you put it like that.(straight talking)

You...

Many Thanks, I'm learning all the time here. Good crack 🙂

If its just a warning then OK, i will let it run.

May I lastly ask (if not too much inconvience)...Why...

Thanks for your reply,

Being a bit of a novice, how would i go about identifying the value that exceeds the limits.

(if in fact this is the way to...

OK, thanks.

i shall persevere and see how i get on. At least with what you have provided, i have a good starting point.

Thanks again for all your help.

P

Just one last thing since you seem to know your stuff (tell me get lost of you want 🙂 )

Having gained access to the RS server and underying tables I'm...

Thank you ever so much. This is exactly what i needed.

Thanks Again.

P

script used ...(thanks)

DECLARE @ReportName VARCHAR(100)

SET @ReportName = NULL;

CREATE TABLE #morepower (MonthDate BIGINT,N BIGINT,PowerN BIGINT PRIMARY KEY CLUSTERED

,NameofMonth VARCHAR(25),WkDay VARCHAR(25))

;

WITH powers(powerN, n) AS (

SELECT POWER(2,number), number

FROM master.dbo.spt_values

WHERE...

Firstly, Thanks again for your time and help.

OK, spoke to the techies at work today, appparently i had insufficient acces rights.

This is now sorted, can connect to our RS Server...

I am using 2008.

Thanks

Many Thanks for your reply.

Just to check , i need to be in 'SQL server Man Studio' ?

I select OBJECT EXPLORER then CONNECT?

From there, I select 'REPORTING...

got it, so simple as er usual i was over complicating things..

insert into table_names select ............

duh !!!!