I would be worried that the drive gets pulled out or falls out at some stage/.

From a quick look that syntax seems okay, i would create a variable called something like 'ValidFileToLoad' .

And then put the script inside the loop ,...

you could use the GetCreationTime method of the file class to detemine if it was created today and then skip the file

I can't think of anything that would tell you how the table was created, there may be a way that i do not know however, one thought though...

Scale will not change the data, I would check the data sources that you are using to see whether or not the values in there have the decimal point.

This sounds like a really really bad idea, and i am not even sure that it is possible as the transaction log has to be on a local disk.

you would write the join statement as per normal, however to refer to a table on the linked server you would use a Four part naming convention ...

Changing the scale is not going to automatically put two numbers behined the decimal point, it just says that you can now have numbers there.

You are chaning the value of...

Its the same in the UK, after you pass the 6 month probation period then it can be really difficult to fire people. There have been several high profile...

That looks good and definately improves on the logic, nice work..

I guess in the end it depends on the business rules that the OP are running under would determine...

This is because you are passing in a valid money data type so this will return true

from BOL

ISNUMERIC returns 1 when the input expression evaluates to a valid integer, floating...

Under your sever name there are various nodes, server objects is the third one down

If the servers are on the same network then it is possible to add the other server as a linked server and then query this using a four-part name.

Using...

you can use link servers and do a select into...

or you can use SSIS.

Steve-3_5_7_9 (6/15/2010)

---

Thanks for the comment.

Ok, I see the point about company secrets, but this has to do with the data in a specific system.

Additionally it's illegal for me to sell...