I think (not a hardware guy) that you could make a vdirectory that pointed to the directory that contains the files.... the caveat being that you would have to open...

Mitch,

a couple questions to clarify.

Are you storing the PDF on your SQL Server or just the Box the SQL server is on?

If it is just as files on the box...

could you post your whole stored proc?

there is more here than you think

tal

sorry, I cannot think of any easy way with a subquery,  what you have is a mess ...lol

I have never seen a good way to compare details from different rows...

just to get it straight. you want the time from his last shift end to his next shift start?

and you have some method to get the entries in correct order?

tal

Barsuk,

Are you stuck with and existing table or are you still developping?

this structure implies that you have some method for putting the entries in order so that you always have the...

From BOL under escape Characters

You can search for wildcard characters. There are two methods for specifying a character that would ordinarily be a wildcard:

• Use the ESCAPE keyword to...

hello,

there seems to be nothing wrong with your code.  The error you referred to in the subject would not come into play in this instance.

the statement:

UPDATE    employee

SET              fname = fname...

just my 2 pennies,

you said you were using asp. Have you thought of asp.net? they have a very easy to implement Forms Authentication that allows your user once logged in...

hello,

your problem lies with your string concant.  any time a null is added to a string it yields null. to that end:

Declare @date as smalldatetime

Print 'this is the date '+...

Hi, I thought I was smart when I made my avatar my baby sone.... guess you thought of it too...

anyway, for your problem Yes it can be done with xp_cmdshell....

Doug,

your question was a bit vague.  I have had to wrestle with this in using encryption to store images here was the solution in total:

1. Make a Class that will...

jb,

unless there is more to it that you are not telling us...if you are already calculating days are your days all 8 hrs? just do the math for the number...

Paul,  One way to use conditionals is to use a case statement to separate the info. 

As an example I have mashed two tables together (named GarbageData) into a view...

Just a thought on the regional settings and capitalization. does hungarian use extended characterset.  I would guess that it does.  The prolem then may be that the  extended Characters my not always...