For the lazy reader :

EndDate >= '8/1/04' AND StartDate =< '8/10/04'

Here's another thread that discuss a problem very similar to this one, maybe the solution can be applied somehow here :

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=7&messageid=153524

Here's another link for access forums :

http://www.accessmonster.com/

It looked pretty deep for most of the persons browsing this forum .

Here's what sushila means. I made two working versions, but they don't seem to provide any usefull results.

Select MIN(DatePart(YYYY, crdate)) as Year, count(*) as Total from dbo.SysObjects

group...

I'm not sure why you're getting this error. But on another note, shouldn't this read ELSE 'Unkown' instead of

WHEN (os_g.ClientType = NULL) THEN 'Unknown'

BTW null = something is never...

6 managers or 6 servers .

Good, then I'm still gona go with Sql server .

Maybe you could convert the date to varchar for the import then toy with sql server to sort out the wrong dates...

Can't he just use dts to export the data to file?? Would be easier to solve the problem that way.

Please do not cross-post.

Finish the thread here : http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=146&messageid=194872

Please do not cross-post, we monitor all boards.

Finish the thread here : http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=194861

Please do not cross-post, we monitor all boards.

Finish the thread here : http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=9&messageid=194832

Yes, but you can always grant access to the application only to view and insert new file/directory, not to delete them. That way you minimize the risk of errors.

I still have to see a situation where I need to do this. I'm sure it's gonna happen, but maybe not this year