Jeff Moden (3/28/2013)

---

OCTom (3/28/2013)

---

Where I work mass mailings are done using mail merge in MS Word. We set up a data source on the user PC pointing to the SQL...

Lynn Pettis (5/22/2013)

---

One thing I learned in a Marketing class many years ago. If someone has a good experience with a product or company they tell 3 people. ...

Eugene Elutin (5/22/2013)

---

Spot on!

If you run the query on 2013-05-19 06:00:00.000 - what output would...

And of course, it must say:

SELECT s.*

to be precise. 🙂

I believe Sean's solution has an extra unnecessary step.

If to use the filtering subquery in the JOIN it may provide sorting criteria as well.

Then CTE query may be excluded:

SELECT *...

I guess because DECIMAL (9,0) (same capacity as INT)...

Alan.B,

I think you missing the point.

The question was not about use of XML in real life, but about why we cannot store XML files using good old nvarchar/ntext data type.

Your...

First of all you need to make sure the Sourcetable (a1, a2,a3,a4,a5) have clustered index on (CompanyIdentifier,FieldIDNumber)

Second, if I understand correctly those joined tables are actually the same one joined...

probably this would help:

http://msdn.microsoft.com/en-us/library/bb522493(SQL.105).aspx

Try the proper one:

http://www.sqlservercentral.com/articles/Tally+Table/72993/

😎

???

Did you actually read the question?

Right there at the top:

Abu Dina (5/7/2013)

---

Morning all,

Could someone help me generate the following grouping please? Sample data...

OP asked for the last (most right) part of the string, not for the second.

You are missing column RowNo in your table Heap.

Files keep the data in physical order as they've been added to the file (because that's a definition of "file").

tables in relational...

SQL_Enthusiast (5/7/2013)

---

I did read BOL, along with 50 other articles that really didn't help. So I figured it out on my own. I'm open to suggestions on how to make...