On interview, I would just go with the following:

SELECT TOP 12 IDENTITY(INT,1,1) N INTO #sample FROM sys.columns

SELECT s1.N, s2.N, s3.N, s4.N

FROM #sample s1

JOIN ...

What is the problem with updateable VIEW? I...

JP10 (2/6/2013)

---

How do we avoid blocks or performance down grade against a table that has deletes and inserts against it?

Every 2 seconds there is about 4000 inserts and I want...

Really? Did you ever worked with data warehouses?

sqlstar2011 (2/5/2013)

---

I would like to create a trigger that only gets executed when a specific field in a table is updated or a new record with a non null value...

karthik M (2/5/2013)

---

I have recently read about this in the below link.

http://www.sql-server-performance.com/2013/tsql-incorrect-union-operator/

I just heard about "NP-Complete Problem" first time 🙂

From Joe Celko...

This UNION vs OR problem has been in SQL...

Mr. Kapsicum (2/5/2013)

---

thanks sscrazy.........!!!!

it's a quick response.

There is nothing about consistency......... its just a question that someone asked me to do so..... he says its possible....!!!!

Trigger,OUTPUT, cascading are possible solution...

It is impossible in SQL.

You can not DELETE...

This function applies offset to the given datetime. You need to keep or calculate somehow proper offset, in order to apply it.

http://msdn.microsoft.com/en-gb/library/bb630289.aspx

There is datetimeoffset T-SQL function to help you. You will need to keep time offset in form of [+|-] hh:mm, in order to use it.

Do you know in what "zone" your datetime is saved? If not, then there is no way to convert it reliably to UTC.

Usually, if your system needs to...

Actually you don't even need CROSS JOIN, I've edited my previous post...

Another one:

declare @Word1 varchar(100), @Word2 varchar(100), @Word3 varchar(100)

declare @str varchar(100) = 'Word1,Word2,Word3'

--declare @str varchar(100) = ',Word2,'

--declare @str varchar(100) = ',,Word3'

--declare @str varchar(100) = 'Word1,,'

--declare @str varchar(100) = ',,'

SELECT @Word1 =...

If you are talking about splitting single string (let say passed as parameter) into three variables, you don't really need a function, as you will not get much benefits from...

...

I am just going from what my Europe users have complained all along: The invoices/reports coming out of the "american" system when the currency is Euros, are difficult to read...