GilaMonster (4/27/2011)

---

Dan.Humphries (4/27/2011)

---

Most managers hear of someone who did not actualy do much work from hom enad assumed that all work from home employees must not work more than a...

I for one would love to get in a position where I could work from home. There is absolutley nothing I do now that I could not do...

My suggesstion would be to use the import Data wizard and import the data one time. When you run through the package you can use the option to save...

Shawn Melton (4/25/2011)

---

Dan.Humphries (4/25/2011)

---

I am curious about this...

I am curious about this part. Why...

I quess I am not sure what the question is yet. Better option for what? row_number?

if that is the question then no there is not a better option although...

*******I think the wording could be fixed. Since the question asks what is the quarenteed results it should be none of the above. A Quarentee is a certainty...

if you can post the full script that would be helpful. usually in the order by you would see a column name not a number:unsure:

If the error is recreatable then I would have profiler running on the SQL server and see what you find there. Also check the SQL Logs to see if...

I do not see where a value is written to your two variables @cust_cd or @pu_del_dt if the value is NULL then the entire sting becomes NULL.

I agree mostly with what has been said about expierence but I would offer the following advice.

Take your time and target your first job. The more flexible you...

Good SQL programmers would never use aliases to do display formatting. You are still writing 1950's COBOL. You even put a comma at the start of a line – that...

Let me be the first to say huh?:unsure:

in that case you likely whant to replace the variables with the actual values before you send the input over from asp or are you simply calling a stored procedure...

I can't beleive I forgot this on earlier but here is a script from Michael Valentine Jones that provides a great deal of useful information.

-- Script to analyze table space...