I like Lynn's approach of splitting it inline and keeping it to a single query instead of using temp tables. Also, his function will be usable elsewhere.

SQL is a declarative language, so a delimited list stored in a variable won't be evaluated. In short, I believe there are two ways of accomplishing this.

The first approach...

No problem. I'm glad it worked for you.

Thank you, Jeff and Dwain, for following up.

I think this is the statement that caused me to think only one of the...

mickyT (2/26/2013)

---

I may be reading the question wrong, but this may do what you want

SELECT Columns

FROM HRCandidateProject

ORDER BY CASE

WHEN TotalExperience BETWEEN 1 and 2 THEN...

You could use SELECT TOP 1, but I don't know if that's what you really want.

If you have more than one row meeting your search criteria, you should either want...

Is this what you're looking for?

SELECT a.COMCODE, a.ACTCODE, a.ACTDESC

FROM ACINF a

INNER JOIN ACPMNTA b ON b.ACTCODE = a.ACTCODE

WHERE a.COMCOD = 3305

...

My mistake. I was referring to the regular expressions approach you took in SQL working either way as opposed to some string parsing approach.

From your BULK INSERT statement, you're not actually importing from an Excel file, but from a CSV file.

This is an important distinction because it's been my experience that you have...

One other noteworthy point is that is you are set up for case insensitivity, the SQL approach won't work. The regular expression approach works either way.

Thank you, Perry. I was just getting ready to post that I couldn't do it myself with my permissions.

I just love the wide variety of stuff available for learning...

Do you have permission on the server itself? I know you need the sysadmin server role to run xp_logininfo, but I'm not sure what you need on the server...

Good point. We're back to needing the DDL.

Data definition language. It's how you create the tables. For example, CREATE TABLE Bookings ...