Gail

I think this is on-topic and you seem to know as much (or more) than anyone on the subject of index behavior that I'd like to ask a question that...

Here's another option you might consider:

-- First we need to set up some sample data.

-- I'm using the Tally table just as an example--any table or

-- tables would work...

[off topic]

Jeff, keep it up!

I've learned more from your articles and posts here and elsewhere just in the last year or so than in the previous decade. I started...

Luis Cazares (6/5/2013)

---

You'll be surprised, but programming isn't something...

This is what I would do:

- Create an audit table to store whatever data you need to save from the file to be deleted.

- Create an "INSTEAD OF DELETE" trigger...

Personally--and I mean this only as constructive criticism--I've always felt that phone interviews are more a time saving screening tool for the employer than a valid method for evaluating a...

Michael Meierruth (5/28/2013)

---

Steven Willis (5/26/2013)

---

I'm late to this party, but here's my entirely TSQL offering to remove duplicate spaces. Most of the code below has been not so shamelessly borrowed...

Lucy08 (5/27/2013)

---

Hi,

I need to fetch rows from a table in SP depending on input parameter value.

@var is an input parameter which i am passing

if @var = no owner assigned'...

Oooops. :blush:

I have re-posted the correct function in the post above. The difference is that the correct "...WithSpaces" version...

I'm late to this party, but here's my entirely TSQL offering to remove duplicate spaces. Most of the code below has been not so shamelessly borrowed from Jeff Moden's work,...

How about something like...

Jeffrey Williams 3188 (5/16/2013)

---

Total WAG...but I have seen things like this where the developers were informed (for whatever reason) that stored procedures require a parameter and therefore they built everything...

Maybe I'm missing something but perhaps all this procedure needs is to make sure the table and column names are enclosed in brackets ([]) due to the odd naming convention.

 

When writing a procedure I always assume that some of the data will be bad or non-existant. Thus, I almost always set up defaults so SOMETHING is returned to the...

This issue has been discussed before. I've posted a date validation procedure before at Date Validation.

To make it even easier, I'll re-post the code here. These are the two procedures...