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...
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...
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...
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...
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...
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...
Hi,
I have a table which shows an 'In date & time' and an 'out date & time' for people in hospital. I have to calculate how many patients were occupying a bed at midnight per day, between any two dates that the user might choose...
For example:
patientid startdate...
Yes, using the .exe is absolutely necessary as it adds a column of data to mine using a logic which I have no access to (or I'd implement it myself). It is the .exe file that exports the results to a csv file, which is why I then have to reimport it.
Thanks for the suggestion though,
Chris
I'm trying to build a DTS package that runs a win32 executable. (not designed by me). This package looks at data puts the data through a processor and assigns another code to the data before exporting it all out to a csv file which I will then reimport to the server... (hope this makes sense)...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.