Thanks Lutz;

I was under the impression he didn't have a handle on the bit operator yet.

your example toggles the bit, right? mine was lamer and tries to set the bit,...

noone has mentioned the TSQL bitwise operators yet. pipe (|)and carat(^) for flipping bits, and ampersand for comparisons(&)

here's an example for you all:

declare @myBitField int

SET @myBitField = 42 --meaning of...

there's no direct way to append to the top of a file;

you have to do it in this order:

1.create a new file. with your Filesystem object

2.write the new stuff to...

After Dave inferred that it was the # seconds since 01/01/1970, it was pretty easy...but how the heck did he figure out the starting date?

Dave had you tripped over...

the script below might help a little;

Assume you grab your 200 backups in a number of folders/subfolders.

you probably need to RESTORE HEADER ONLY to see the DatabaseName that is associated...

I'm a little confused by the question;

a script to backup all the databases is very easy, and so is putting it in a job so it runs on a regular...

kabaari (8/18/2009)

---

I am using Coldfusion to INSERT and SELECT data. I used a to do this:

When I <cfdump> this, it works. The empty values return [empty string]. But when...

my pleasure; something like this is much easier to understand visually like that. glad i could help.

here's something to help visualize it:

Dave Ballentine showed you step by step how the conversion is going to work; but if you use the final answer, you don't get the timne portion, just the correct...

Yes = You meant something else?

or

Yes = That was the solution i was looking for?

ok if there could be multiple spaces before the period,

here's how i would do it: i thought about STUFFing it, but relized there's a simpler solution:

i would simply grab the...

if you mean when you copy and paste from Management Studio to Excel, it's an option you'll want to turn on:

did you mean something else?

conversions like this are a pain; obviously, whenever possible, this kind of data should be placed in a datatime filed, instead of a varchar/char; if you can, convert your original...

ajith.ranjan (8/17/2009)

---

Thanks Lowell

Your code worked for me. Next step is I have to workout how to pickup one file at a time from the directory.

It is great if...