There's always alternate ways of formatting a date. Whether you'd want to use them is another story.

DECLARE @product_name VARCHAR(20) = 'Vehicles'

,@expiry_date DATETIME = '2012-09-10'

SELECT...

Have you considered using MERGE?

http://technet.microsoft.com/en-us/library/bb510625(v=sql.105).aspx

ROTFLMAO! +1

Since quote is also CHAR(25), you can also do this:

CHARINDEX(CHAR(25), string_column) > 0

Ignoring the valid questions posted by Evil, something like this might get you started:

--Create Table Consumer

CREATE TABLE #Consumer(

[ConsumerID] [varchar](10) NOT NULL,

[ConsumerName] [varchar](100) NULL,

[ConsumerType] [varchar](20) NULL

) ON...

The answer to this is the delimiter appearing...

Credit to you Lonnie for being so thorough in your testing.

They say "never look a gift horse in the mouth," but I'd say on forum answers you always should.

Nothing like...

sgmunson (12/18/2012)

---

..

If I could generate a good sample of, say, 1/2 million to several million test records, I'd find a weekend and test your code. Got any easy...

Let's try a few of these solutions in a small test harness to see what we can see, shall we?

CREATE TABLE #Strings (ID INT IDENTITY, MyString VARCHAR(8000))

;WITH Tally (n) AS...

No answer to my questions so I'll ignore them.

This ain't pretty (elegant yes) but it seems to do the job.

CREATE TABLE #Employee_Leave

(emp_id INTEGER NOT NULL,

leave_date DATE NOT NULL,

NO_Of_Days...

sgmunson (12/18/2012)

---

Honestly Dwain, I'd love to see you find a solution here, but I'm afraid I'll have to see it to believe it. My primary reason for holding this...

sgmunson (12/18/2012)

---

...

You need to start a given group of records in the same industry and category with the value for AvgSales for the record with the lowest Emp_Rank value, and...

Evil Kraig F (12/18/2012)

---

support 86837 (12/18/2012)

---

I have two tables, one for Orders and then an Assiged Parcels table which can have multiple records attached to an Order. In the Order...

SG,

BTW. In case you haven't, you should probably read this article by Jeff Moden: Solving the Running Total and Ordinal Rank Problems[/url]. Look for the section on triangular...

sgmunson (12/18/2012)

---

Dwain,

A "Quirky Update" isn't going to work here, as the problem isn't just a matter of retrieving a value from a previous record. It's a matter of...