Is it possible to give all the information that Gail asked in the other thread?

Please don't crosspost. It wastes people's time and fragments replies.

Original thread with replies can be found here:

http://www.sqlservercentral.com/Forums/Topic1221436-391-1.aspx

http://www.sqlservercentral.com/Forums/Topic988685-391-1.aspx

I wouldn't list forum activity directly on my resume. What if they check "the thread"? :blink: :hehe:

I would just put "active in SQL community".

You can discuss details at the interview...

Furthermore, try to get rid of functions in your join clause or where clause:

http://www.mssqltips.com/sqlservertip/1236/avoid-sql-server-functions-in-the-where-clause-for-performance/

Do you have any indexes?

Check out the following article for some best practices:

http://www.sql-server-performance.com/2006/tuning-joins/

Is it possible to have error handling on the source and to redirect all error rows to somewhere else?

If that works, you could put a derived column on the error...

Christian Buettner-167247 (12/14/2011)

---

Koen Verbeeck (12/14/2011)

---

I have a question:

why doesn't the second 'drop table' statement drop the table in the master database?

Won't the statement look for the table in the master...

chris.stuart (12/14/2011)

---

Hi

Im reading in data in from a text file. This is SMS replies from clients. My whole database is designed to cater only for non unicode characters, but every...

Great question!

I have a question:

why doesn't the second 'drop table' statement drop the table in the master database?

Won't the statement look for the table in the master database, just as...

Did a bit of research (you can do this too, don't be afraid):

http://msdn.microsoft.com/en-us/library/b873y76a.aspx

Split the string using = as a delimiter. You get the substrings in an array.

Loop over this array...

Indeed. If the OP doesn't have a calendar table that indicates holidays, than the request can't be solved, as holidays vary from...

johnmcpherson1 (12/13/2011)

---

IF(Exists(Select top 1 myColumn from myTable))

do something...

ELSE

do something else...

This will always return 1 row and 1 row...

Do you have a date table somewhere that lists all the dates together with an holiday flag or something like that?

deepmustang 90114 (12/13/2011)

---

I have some 100+ SSIS packages that have connection strings embedded with-in the packages. We are moving to a new server. I can redesign the packages to pull...