Viewing 15 posts - 706 through 720 (of 2,894 total)
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 ...
February 11, 2013 at 5:29 am
ScottPletcher (2/6/2013)
No, I wouldn't use OR just because that makes a view updateable -- UPDATEs aren't typically done using views like that anyway.
What is the problem with updateable VIEW? I...
February 7, 2013 at 1:24 am
JP10 (2/6/2013)
Every 2 seconds there is about 4000 inserts and I want...
February 7, 2013 at 1:18 am
Bhuvnesh (2/6/2013)
Many Joins means "poor database design"...
Really? Did you ever worked with data warehouses?
February 6, 2013 at 3:40 am
sqlstar2011 (2/5/2013)
February 5, 2013 at 10:36 am
karthik M (2/5/2013)
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...
February 5, 2013 at 3:06 am
Mr. Kapsicum (2/5/2013)
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...
February 5, 2013 at 2:45 am
I want to delete these records from both the table in single DELETE statement. and DON'T USE CASCADING.
Need Help..............a bit urgent..........!!!!! :-):-D
It is impossible in SQL.
You can not DELETE...
February 5, 2013 at 2:31 am
This function applies offset to the given datetime. You need to keep or calculate somehow proper offset, in order to apply it.
February 4, 2013 at 4:49 am
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.
February 4, 2013 at 4:11 am
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...
February 4, 2013 at 3:44 am
Actually you don't even need CROSS JOIN, I've edited my previous post...
February 1, 2013 at 3:17 am
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 =...
February 1, 2013 at 3:15 am
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...
February 1, 2013 at 3:08 am
...
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...
February 1, 2013 at 2:25 am
Viewing 15 posts - 706 through 720 (of 2,894 total)