Results are nice, but what also is needed is what the tables look like and some sample data to work on.. (not that I'm promising anything

Could you post the function?

It's pretty hard to see whats happening without the source.

/Kenneth

I would guess the answer is no.

SQL Server has no supported encryption functions that I know of

/Kenneth

Two ways comes to mind.

Either bcp out all your data to textfiles (not native), drop tables and recreate them and bcp data back in, or....

Alter table alter column... for each...

I assume you have read up on OLAP, building cubes, dimensions, members, snowflake schemas etc etc..?

(no, I'm not the guy to ask about those things

There is only one date format that will cause you no trouble, no grief, no nothing wherever in the world you'll go.

This is the standard ISO format ssyymmdd (eg 20040609)

In...

This would be a perfect example when it's a good thing to provide the table DDL's involved and a few rows of data showing the output along with the desired...

Depends on what each step is doing...?

Perhaps you could try out the 'retry attempts' and 'retry interval' options on the 'edit job step' 'advanced' tab..`?

/Kenneth

Your office should have this information. (ie what #licenses is already owned)

Whatever info you may be able to extract from any installation would only be what was entered when the...

If you must guarantee that the proc uses XACT_ABORT ON setting, then you have no other choice than to add this to the procedure code and recompile, or make sure...

Options 1 and 2 represent two different approaches.

1) Keep the underlying data and modify the result.

2) Change the underlying data and just show the result.

The real question is: should the...

I don't quite understand the question.

Could you give an example on what you're trying to do, and what the results are when trying to do so?

/Kenneth

AFAIK, DATEADD has no knowledge of timezones or daylightsavings.

But if the users offset from GMT is known and you have your date in myGMTtime column, then something like this would...

Perhaps most users there has run out of tricky questions..?

No, it's not dead to my knowledge.. Posts keep trickling in still, but maybe not as many as before. It goes...

...another caveat may be that it will show the server's time, not the clients - so the server won't now which offset the client has anyway..