I can't test this right now because I don't have a 2012 instance available, but it uses Eirikur's idea.

WITH e1(N) AS(

SELECT N FROM (VALUES(0),(0),(0),(0),(0),(0),(0),(0),(0),(0))e(N)

),

e2(N) AS(

SELECT a.N FROM e1 a, e1...

Eirikur Eiriksson (3/21/2014)

---

Just a quick thought;

Splitting the string is somewhat like crossing the stream for a sip of water, when all that is needed is to get the position of...

There are 2 options available:

DECLARE @sql varchar(8000) = '';

--Option 1

select top 3

@sql = @sql + 'select top 3 * from '+name + CHAR(10)

from sysobjects where type =...

Assign it to a variable and execute the variable with sp_executesql or EXEC().

That's not what I asked for. I need table definitions and sample data in a way that I can copy and paste them in SSMS and use them without any...

Congratulations Jason, that sounds great.

These are my observations about your answer, they're not wrong but I can partly understand the interviewer.

first, check whether the query is using index? If yes, check it is a...

You're looking for CROSS TABS or PIVOT. Take a look at this article to know more about it: http://www.sqlservercentral.com/articles/T-SQL/63681/

Here's an example:

SELECT id , name,

SUM(...

Another option is to use http://poorsql.com

It has SSMS and notepad++ plugins plus, plus a stand-alone formatter.

Koen Verbeeck (3/21/2014)

---

In your second query, you also left out the data range where clause in the subquery on [dbo].[tblClientLog].

This means you will now have the entire table of tblclientLog...

Note that there are better ways of doing this. As explained in here: http://www.sqlservercentral.com/articles/comma+separated+list/71700/

Sure, you can do many things, but we need some help from you. Could you post sample data, and expected results in the form of CREATE TABLE and INSERT statements?...

I would suggest that you start with Stairway to Data[/url], continue with Database Design[/url] to understand SQL objects, then T-SQL DML[/url] and continue with whatever you're interested as the topics...

If I understand correctly, you want to check if there's a continuous character string in the column, it doesn't matter the position of it.

You could do this with a string...

Your WHERE clause is converting your LEFT JOIN into an INNER JOIN.

You need to change your query a little bit.

Here's a nice article on the subject: http://www.sqlservercentral.com/articles/T-SQL/93039/

SELECT Users.Code AS FE

,COUNT(Matters.FeeEarnerRef)...