He will make sure that you share his pain

If I could share his payment, I would also share his pain

Dave,

would you please use the KISS approach when writing?

You got me flipping through the pages of my dictionary

I don't know licensing stuff (and actually don't care), but I got them wrong too.

To add to Kenneth, this is what happens here.

At 8:00 PM our time recording system stops, well, err recording my time. So 8:00 PM is recorded as my check.out time....

Oh, I see.

Well, before creating a table for each and every user there is right now or might be there in the future, why not create one single table...

Why not use a temporary table? According to BOL "Local temporary tables are visible only in the current session", meaning when you do

CREATE TABLE #FRANK(

col1, char(1)

...

)

only this session can see...

Please don't get me wrong on this. But I did my civilian service ?!? (hope that's right translated ). Besides some other aspects,...

I would stay away from querying the system tables, when there is another solution at hand. Use Jonathan's suggestion, that's what the INFORMATION_SCHEMA stuff is for.

Hm, had to google on Hap Arnold.

Never thought you are that military, Brian.

May I ask, why?

Did someone noticed the 'Sisters of Mercy' avatar some days ago? I like this

But I haven't figured out yet, what Steve's avatar should...

Did you already try DBCC CHECKDB?

Dave, yes, your reply makes me happy

As for the theory behind. There is the relational model (Dr. Codd), then there is SQL (Donald...

To add to David, 01/01/1900 is SQL Server's reference date. All other dates are calculated as days before or after that date. So when you want to avoid dealing with...

Thomas,

to be honest, I don't know why we're the only ones to post in this thread?  Maybe its off-topic...

Actually I am no upholder...