A datetime datatype has no internal format or representation distinctions AFAIK, they're all the same. More likely, there is another column that it is using to keep track of...

Great article Perry! And very useful given the trend toward virtualization these days.

karthikeyan (5/12/2009)

---

Hi All,

We are planning the db migration from sqlserver 2000 to sqlserver 2005 in one of our production box soon.

We are going for backup and restore option.

Please help me...

emzero (5/12/2009)

---

Bad news, cycles has to be considered =P

Let's say we have:

A->B->C->A

...

So this approach doesn't work well with cyclics. In fact, it doesn't work at all because it's getting into...

Heh. Yeah, well they did except those three for a reason....

Like this:

...

Declare @sql as Varchar(MAX)

Select @sql = 'DELETE FROM '+@WE_ClientCode+'_ReEnrolment;'

+' INSERT INTO '+@WE_ClientCode+'_ReEnrolment ;'

+' SELECT EmpID, Sin FROM '+@tbCueUp+';'

EXEC(@sql);

...

UMG Developer (5/12/2009)

---

Paul White (5/12/2009)

---

I believe he is referring to...

Glad I could help. 🙂

FYI, then this problem is called a "Topological Sort".

Yes, the problem is right here:

...

DELETE FROM + @WE_ClientCode + '_ReEnrolment '

INSERT INTO + @WE_ClientCode + '_ReEnrolment '

SELECT EmpID, Sin FROM @tbCueUp

...

You cannot use a...

Which is it, a multi-parent tree or a digraph? They are not the same thing.

In particular, a multi-parent tree would be a digraph that is connected and has no...

The three general cases for SQLCLR use are:

1) Access to external...

Well it still seems like something is missing, but this code does what you have specified:

;WITH cteBinary as (

Select

SUM(

Case [status]

When 1 Then Power(2, ResID)

Else 0...

Snacks for later. 😀

Try using dynamic SQL to do this.