jasona.work (2/4/2016)

---

Man, there's a reply to one of my topics (which really already has been answered, although Gail raised an important point) by CELKO, and I can't read it...

The curiosity...

What's wrong with LIKE operator if it does exactly what you're asking for?

SELECT *

FROM #Source s

JOIN #result r ON ' ' + r.column_result + ' ' LIKE '% ' +...

I'm not asking for a data set with thousands of rows. I'm just asking for something that can replicate the infinite loop problem and we can fix the issue.

I'm not...

Chris,

Is there any particular reason for using 1900 + DATEDIFF(YEAR,0,GETDATE()) instead of YEAR(GETDATE()) ?

Data source views(DSV) are stored as XML which is not that hard to get. You just need to explore a bit as I can't remember the exact tag that it's...

I'm not sure what you're trying to do. You're not really using a hierarchy, but concatenating values.

Maybe this could work better for you.

CREATE TABLE #Table(

col1 ...

Your columns are not varchar, otherwise you wouldn't have the conversion error.

Also, mm/dd is not a date format valid for SQL Server. Dates need a year to be stored/showed as...

gain

Phil Parkin (2/4/2016)

---

Grant Fritchey (2/4/2016)

---

Grumpy DBA (2/4/2016)

---

In the past I worked with a couple developers (SQL and Oracle) who used Select * quite often. At every code review I...

This got me by surprise. I'm not searching for jobs, but it got my attention because it was totally unexpected (but possibly logical).

https://www.linkedin.com/jobs2/view/99695736

The code that I posted previously is giving the expected results (after correcting your sample data script). What's your question/problem?

No, definitively not a loop. However, I'm not sure what to recommend without more information and sample data.

You might also want to check the following article about importing flat files into SQL Server.

http://www.sqlservercentral.com/articles/BCP+(Bulk+Copy+Program)/105867/

You certainly showed more information, but you didn't post it as it was requested. You're new here so I'm including the full example.

Be aware that if you don't have enough...

Brandie Tarvin (2/3/2016)

---

Luis Cazares (2/3/2016)

---

Brandie Tarvin (2/3/2016)

---

Luis Cazares (2/3/2016)

---

Brandie Tarvin (2/3/2016)

---

SQLian (2/3/2016)

---

Not sure if I am missing something here, but why can't the following be used?

delete [FROM] Customers

where ...