ISPALUSER Deep Dive

Chris Morris-439714 (12/1/2010)

---

WayneS (12/1/2010)

---

Chris Morris-439714 (12/1/2010)

---

Good Lord Wayne...

I have a question for clarification:

Ascii Codes 36 (Dollar sign), 128 (Euro sign), 163 (British Pound sign), and 164 (Yen sign) are included because they are frequently used as enumerators...

1. Are the numbers at the end a record identifier, or part of the name?

2. The row that you don't want to return also contains "corporate". Since you're using an...

For this, I would bulk insert into a one column staging table (you should use a staging table anyway to do validations on the data before inserting into the permanent...

Chris Morris-439714 (12/1/2010)

---

Good Lord Wayne you're morphing into...

Just the pizza -...

It's not "my" function - it comes from Jeff Moden. It's just what is in use around here, with little...

To all the Threadizens that have presented - how have you incorporated this public speaking into your resume? Examples would be great!

Shawn Melton (11/30/2010)

---

YSLGuru (11/30/2010)

---

I’m looking only because I’d like to see if there are alternatives because I’ve had some issues recently with these scheduled tasks running reliably and so my...

Try this:

-- See how this starts off with a table and data in it?

-- If you had provided us the data in this format,

-- it would have made things...

Using BCP:

-- declare and initialize variables

declare @sql varchar(8000),

@q varchar(255),

@fn varchar(255),

...

You're thinking strictly of how the procedure runs. The error is being generated at compile time - sql evaluates the statement(s), sees that the column doesn't exist, and throws the...

No problem - glad I could help you out.

The latest (and fastest) Delimited String Splitter Function can be found here. It avoids all the RBAR of the while loop. It does require a tally or numbers table, but...