He said : "We need to store both Full and Partial Dates (whichever we have)." He talks about storing the year but he doesn't say if it's enough and...

Hey Noeld, can you explain why the dual processor is screwing this operation??

To add to DC's proposition. It's what I would do in this case :

DOB datetime (or smalldatetime depending on the range). Then add a precision colum char(3) in...

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