Great question Wayne. I knew the page would not be deallocated but I didn't know all of the details. The article was very interesting and informative read.

I wonder if Celko...

opc.three (1/15/2013)

---

Leveraging the validation built into the System.Net.Mail.MailAddress constructor is clever and I did not have to set trustworthy on to use it. The RegEx version is nice too. I...

Actually I wanna convey SMS from my database through mobile operator. That's why I want to insert data in my convenient format. If I use char(13) + char(10), it will...

Storing the results in sql is fine but the process you are describing is an application. Yes you can probably find a way to make this work but that doesn't...

This is somewhat of a shot in the dark because we don't have ddl or sample data to work with.

SELECT

A.ConsInvNumber AS [Consolidated...

Ed Wagner (1/14/2013)

---

Grant is right - you need to check your data types.

Also, you cannot have an ORDER BY clause in a view. SQL 2000 tolerated it but the...

Yeah read that article and then the code is pretty simple.

;with cte (ID, Well_id, Figure) as

(

select 1, 20, '1 2a 5 6' union all

select 2, 22, '3 4 22a'

)

select ID,...

That is a pretty good idea Lowell. I have rolled my own IsValidEmail using regex but I know it is not as robust as the .NET MailAddress object. I have...

Can you use CLR? RegEx tends to be far easier to implement in C# than in pure t-sql. There are certainly some pattern matching techniques for some basics but I...

For an in-depth look at ranking functions check out BOL. http://msdn.microsoft.com/en-us/library/ms173454.aspx

Excellent job posting ddl and sample data. Now what is the question?

shohelr2003 (1/14/2013)

---

Dear,

I want to insert multiple lines in a single row in SQL Server 2008 R2. I have tried. But it's not working. A table has only one column and...

Syntactically there...

Can you post the ddl and all indexes as well as actual execution plans? Without those details we are shooting in the dark.

Take a look at Gail's post about details...

Roland Alexander STL (1/11/2013)

---

As to the destination table already existing, that shouldn't be a problem if you're selecting into a temp table. SQL Server will give it a unique name...