I have managed to "bodge" a solution together.

created a while loop with the dates static and looped through

then worked out leap years and updated feb to 29 days not 28

something...

Thanks alot guys

using this link http://www.sqlservercentral.com/articles/T-SQL/70482/ which is great for month based calendars, how would I adapt it to handle for the number of days in a month and have...

you can install bids just not ssis, only install bids if they need it the less someone has the less damage they can do

you can install all of shared features except ssis without needing a licence

for client tools all you need to install is management tools and if you want to use...

when you purchased your 2005 licenses did you buy them with software assurance (SA) if so what SA period did you buy, 12 months, 24 months 36 months? If...

could grant execute on sp_start_job only to the account in question, then pass it the job_id

maybe this will help

http://msdn.microsoft.com/en-us/library/ms177410.aspx

SELECT

ID, Name, [English] AS English, [Math] AS Math, [Hindi] AS Hindi, [Marathi] AS Marathi

FROM

@TMP

PIVOT

(max(marks) for subjectname

IN ([english],[math],[hindi],[marathi])) as p

Will give results like this

IDNameEnglishMathHindiMarathi

1A808090NULL

2B801009080

this works for me,

create table #dates1 (Date1 DATETIME)

create table #dates2 (Date2 DATETIME)

insert into #dates1 values ('2011-05-05 08:00:00.000')

insert into #dates2 values ('2011-05-05 08:00:00.000')

insert into #dates2 values ('2011-05-05 08:12:14.000')

select

d1.*,

d2.*

from

#dates1 d1

inner join

#dates2...

please dont quote me on this as i'm not the best person on dos, but I think you will need to get the script to fail as the script will...

this link may help

http://blogs.msdn.com/b/joaol/archive/2010/01/05/sql-server-2005-patch-fails-to-install-with-an-error-unable-to-install-windows-installer-msp-file.aspx

can you explain which part is not working?

currently trying to find a licensing document where I believe that SQL, AS, RS, IS are the licensed parts of SQL, so you cannot install SSIS on client machines unless...

No I haven't

Also you have posted a 2005 question in the 2008 area.

You might get better help if you ask in the SQL 2005 area.

Have you looked through the log...

I know in McAfee you have to disable the mass mail worm in order to get it to send emails

If McAfee is controlled by an ePO server, get your ePO...

I think the way to do this would be to create a 32 bit DSN and then use a linked server to do the export, as I know 64 bit...