I have never found a use for the CHOOSE function. Has anybody used this in production for anything? If so I would be curious to hear about the situation in...

There are actually 2 different, but related, errors:

The date is included in the literal;

the time contains a letter "p" that is not recognised;

therefore, answers 2 and 3 are equally...

Unexpected gifts from nowhere... I now have a second "Ice Breaker/Litmus Test" question for interviews. No need to pile on folks.  I'm just a little gob-smacked that...

As mentioned by Jeff tbl-ing is really setting up an environment for bad things. What happens when you have a table tblEmployee and you need to make some changes but...

This really isn't helpful. This code is POSTGRE but this is a sql server forum.

Often times around here we get the "urgent" request which will be followed up with a response asking for clarity about the details of what they actually want. And so...

Sharing the error message would be helpful. The code as posted is perfectly valid.

He did but the semicolon is...

You could try this STRING_SPLIT function I'm in the process of writing and give me some feedback.

It's like SQL Server's STRING_SPLIT function but will work with SQL 2012...

Sorry , I was in a hurry and looking out for solutions and couldn't respond immediately.

Here is what I'm trying to do . There is a table called Locations...

Hi Guys ,

I have column with Values like 1111\123132\34342323\1212. I used the above code to split it . But this doesn't work. The code returns blank. Can you please...

Not to worry Steve. We appreciate all the work you do for the site. And this QOTD was quite interesting.

I have to agree this is an execution error and not a syntax error. Even simpler would be to Parse the query. That checks for syntax errors regardless of objects...

He changed his URLs a few months ago. That article is now here....

SELECT 'CREATE VIEW ' + tb.TABLE_SCHEMA + '.vw' + tb.TABLE_NAME + ' AS SELECT '+

(SELECT STUFF((SELECT ',t.' + vp.Column_Name FROM information_schema.columns vp

WHERE vp.Table_Name=tb.TABLE_NAME and vp.Table_Schema=tb.TABLE_SCHEMA FOR XML PATH('')), 1,...

• This reply was modified 5 years, 10 months ago by Sean Lange.