Which script?

I don't know, Steve... Good peoplem like yourself, keep saying that good enough is enough. That refactoring code should be carefully considered. That you need to get things...

Thanks, Matt... you saved me a wad of time!

Marios Philippopoulos (6/14/2008)

---

CLR is useful in such cases as these (benefit in parentheses):

- string manipulation, regular expressions etc. (performance)

- OS-level operations, previously possible only using xp_cmdshell (more granular security, ...

Aw crud... I was testing Kevin Boles code from his response above, and I found an error in my own code... I'd left a SELECT TOP in some of the...

Thanks for the feedback... glad you found a work around.

If you notice, there's a (6) footnote marker... The style with the "Z" is valid only when converting from VARCHAR to DATETIME... not when converting DATETIME to VARCHAR. Dunno...

Like RockMoose did... no cursor... no loop... no RBAR from UDF usage. Slightly different take though... for ,, I return a Null... for , , I return a blank.

Borrowing...

Tech_Newbie (6/13/2008)

---

I want to be able to increment through the ?temptable starting at the person from position 3, and insert every 7th person thereafter into the Person and PersonAddress tables.

If...

Correct... the DATETIME datatype has a resolution of 3.3 milliseconds.

I'd sure be willing to try if you'd post your distance function, the CREATE TABLE statements for the two tables, and attach the data for all 25 stores and a...

sharma (6/13/2008)

---

I am loading data from .txt file with selected column only. (4 fields out of 40 fields)

I had created a .fmt file

It shows error as invalid column number.

How...

It might be a little bit slower than a whole bunch of math, but it sure is simple thanks to STR...

DECLARE @FloatDateTime FLOAT

SET @FloatDateTime = 20080613023001...

I wouldn't worry about how long it takes to create the initial space. The important part is that you create as large a piece as you think you'll need...

It's one of the most frequently asked questions, ever... 😉