You don't need NTILE...

-- create sample table

select top 1000 4441 as groupnumber , cast(null as bit) statusbit

into #t

from syscolumns

-- update

;with cte

as

(

select *,(ROW_NUMBER() OVER (ORDER BY groupnumber)-1) % 5 ...

siva 20997 (3/12/2012)

---

I do agree with most of your points. But still fail to see couple of things from my understanding of how computers function.

Wheather the code is inLine or...

siva 20997 (3/12/2012)

---

Eugene

Would like to know if there is lot of differnce in the perfomance bitween

User Defined Functions (like what I have posted)

and system defined functions like DateAdd and...

ard5karthick (3/12/2012)

---

Hi,

Generally Uniqueidentifier is a 36 bit alphanumeric unique Value that will not be duplicated.

Its syntax is XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX.

It is a data type in SQLServer & it will be mostly used...

oops, didn't see the thread end...

But still, want to mention that it's not a good idea to use scalar-values user defined SQL function for doing it.

In-line-sql, may look a...

opc.three (3/9/2012)

Re: "you should try to make trigger as lightweight as possible"

I could not agree more, Eugene. Unfortunately your example will force a full scan of the inserted table...

ColdCoffee (3/8/2012)

---

You can not insert data into 2 tables simultaneously in a single session.

But if u split the insert statements into 2 statements, it is going to give you...

opc.three (3/8/2012)

---

...

Now the example trigger:

IF EXISTS ( SELECT *

FROM sys.objects

...

Is it an interview question?

I wouldn't too, if my database...

Then, you may miss some updates!

There was a story remembered by some one here, about the company went bust because of...

in short:

http://www.sqlservercentral.com/articles/Best+Practices/61537/

declare @dt datetime

set @dt = '20120101'

SELECT DATEADD(DAY,

CASE DATENAME(WEEKDAY,DATEADD(DAY,-1,DATEADD(MONTH, DATEDIFF(MONTH,0,@dt),0)))

...

Looks like OP is not going to listen...

Ok, you can take this and kill yourself :hehe::

CREATE TRIGGER CustomerUpdateMail

ON customer_info

FOR UPDATE

AS

SET NOCOUNT ON;

declare @message nvarchar(2000);

DECLARE crsUpd CURSOR FAST_WORWARD

FOR...

Your code is fine to me, but you can use CTE to make it "look nice":

;with duplicates

as

(

select [name] from infosys

group by...