You're missing the SELECT.

And BTW, I suggest to remove the scalar function if possible. We can help you build a faster option.

That's weird. The image is hosted in here.

Does anybody else have the same problem?

EDIT: Original source of the picture in here: http://www.moef.dk/fishfingers/

You're assigning a string to an integer variable.

This article by Wayne Sheffield should help you to get what you want.

http://www.sqlservercentral.com/articles/comma+separated+list/71700/

Calling a scalar UDF inside another scalar UDF is a call for disaster.

Sean mentioned that this could be done in a single statement because inline table-valued functions are pretty fast....

Or maybe like this:

SELECT String,

LEFT( Phone.number, CHARINDEX( '''', Phone.number) - 1)

FROM (VALUES( '@City=''New York'', @Phone=''2035551212'' (10 characters, no dashes)'),

...

I was expecting an advice from Grant involving a kilt. 😀

Seriously, now.

- Try to be very organized as your time is very limited.

- Measure the time...

Something like this should help.

SELECT String,

SUBSTRING( String, Start.Position, CHARINDEX( '''', String, Start.Position + 1) - Start.Position)

FROM (VALUES( '@City=''New York'', @Phone=''2035551212'' (10 characters, no dashes)'),

...

I finally found Dwain's secret.

As long as the columns just have DEFAULTs assigned, you can treat them as any other column.

Just as a suggestion that might not solve anything.

I'd recommend you to use QUOTENAME() instead of inserting the brackets yourself.

CREATE TABLE dbo.Areyoukidding(

My_ID int,

...

You can connect with SSMS to any version of SQL Server (AFAIK), but you might be missing some options due to compability.

You can restore a backup from 2 previous versions,...

This might get you started.

WITH SampleData(CustomerID, VisitDate) AS(

SELECT *

FROM (VALUES(908,'2012-07-28 00:00:00.000'),

...

Thank you all for your help.

After a quick speed test, I got the following execution times after 10 executions for one million rows.

-----------------------------------------------------------------------------------------

|Version | 1 |...

CELKO (4/8/2015)

I have a column which needs to be 9 digits long. The first four digits are independent from the other digits. The following digits need to be 5 and...