Doesn't sound too tough. Please take a look at the first link in my signature for best practices when posting questions. Once we have the necessary information you will find...

16 posts into what should have been a 1-2 post answer if ddl and sample data were provided...

Here is my last shot in the dark.

SELECT

CASE LEFT(cast(Customer.STARTDATE as varchar(20)), 2)

WHEN...

Glad you...

Welsh Corgi (1/21/2013)

---

Thanks. Not sure why I'm getting an error on the substring function.

Msg 8116, Level 16, State 1, Line 1

Argument data type numeric is invalid for argument 1 of...

Also your script does not take into account if the current and updating values are the same. If you prevent updating the column like you have in your trigger it...

Had not heard about this function until now. Like others I assumed they got it right. The question actually pretty much answers itself. The first 3 sets of choices are...

Load it into a table which I would assume you are doing anyway. Then you just query sys.columns to get your list.

SELECT Stuff((SELECT ', ' + name

FROM ...

Can you be a bit more specific about what you are trying to do? Is the first row in your spreadsheet the column names? If you can explain in more...

I would say it is mostly preference but I would agree with you. Why have all your variable declarations at the top? This isn't Pascal or Delphi. It makes sense...

kenneth.bucci (1/18/2013)

---

Thank you both for your replies.

Unfortunately I have to be careful what gets posted publicly as I work for a hospital. I am not sure I could get you...

kenneth.bucci (1/18/2013)

---

Yes that is what I am saying @Issues is a SQL Paramerter with multiple delimited values separated with a comma. SPL.IssCode contains a different set of multiple delimited values...

kenneth.bucci (1/18/2013)

---

Thank you for your reply.

I am still not sure how to compare the two sets of delimited string items. Each item in one list must be in the other...

The N forces conversion to Unicode.

Yes it is certainly possible. Take a look this article. http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/%5B/url%5D

mak101 (1/18/2013)

---

I have created a view where I join a table from different database on same database server. In that another database, tables are dropped and created every night from...