Recent content by ChrisDodgson

We have a number of regular repeating tasks that are currently managed using an outlook calendar. I was wondering if those calendar entries could initiate a workflow to start which would then direct people to create a specific document / set of documents? This would enable the whole workflow...

Hi, we are about to purchase SQL 2005, and I'm trying to work out what spec the PCs need to be in order to run client tools effectively. Having looked about in MSDN etc I can't find anything that gives me minimum / recommended requirements. Does anybody know the location of where this might...

Yes. But I'm trying to find a way of automating this, as the overall process could be producing upto 300 spreadsheets every day.

I am running SQL 2000. I have a stored procedure that creates a set of data, which then needs to be put into Excel, the excel spreadsheet password protected and then emailed to a recipient. I have the sp sorted, and was going to use xp_sendmail to send the spreadsheet to the required...

Many thanks, that does the job! Chris

I have a server whereby 3 or 4 databases all relate to each other. Occasionally it has been necessary to make changes to the schema of one or more of these databases to incorporate new requirements. Is there a way to autodocument 3 or 4 databases in tandem so I can view dependancies. (eg...

Having thought about it some more for about 20 seconds, if the report has a fixed number of columns you could create a table as follows: create table veg(colA varchar (50), colB varchar (50) etc...) then insert into the table: insert into table Veg select 'Veg', dateadd(dd, -14, getdate())...

I believe that the only way that a crosstab approach works in SQL is if you specify the actual column names and the logic of what you want them to contain... so that being the case you would need something that looks a little like: select Veg, sum(case [relevantdate] when '2005-11-19' then 1...

What is it you're trying to do exactly? Chris Dodgson

Hi, I have got a DTS package that exports the results of some SPs to an Excel workbook on a daily basis, because it's a daily job, I've set up a dynamic properties task (to be the first thing that happens in the DTS) and this datestamps the name of the Excel spreadsheet to something like...

Many thanks that works a treat!

Hi, I'm a bit stuck and any and all advice / help would be greatly appreciated. I have a server (called for arguments sake: server1), this server and all the tables in all the databases on it have the following collation type: SQL_Latin1_General_CI_AS. Server1 is linked to Server2. The server...

James, your answer gave me exactly what I needed... the logic of it was escaping me. A much appreciated star for you! Thanks, Chris

I've had a go with your codes, but what they don't actually do what I need them to... If you apply your code to my example, using parameters of Startdate of 1st April 2003 and enddate of 30th April 2003 it counts patients 1 and 2 as being in bed at midnight on 3rd April and on the 19th...

I'll give that a try, thanks Logicalman! Chris