Nice one.. 🙂

roberto armellin (11/3/2011)

---

excuse me but this is my first post. I edited the script and now I wait for the publication of this issue.

This is the script :

select

...

I think script is missing. Can you please check?

Nice one. Thanks for sharing

@pveilleux: [StatusName] contains data like 'Completed' or 'Failed'. The reason why you are not getting the data like ['Completed', 'Failed'] because there is no data in column [StatusName]...

GilaMonster (10/12/2011)

---

Of course it's true, that's one of the fundamental points of an index, that the data at the leaf level is logically ordered by the key columns. If it...

Eskandari (10/12/2011)

---

Hello

My Backup file is from sqlserver 2008 r2 sp1 and I try to restore it on another pc with sqlserver 2008 r2 sp1

When I select backup file I see...

Easy & Straight forward question..

Great question.

Straight forward question. Thanks.

Hello,

This may be helpful to you. One way to resolve your query, you can also use CTEs for the same.

DECLARE @hospitals TABLE

(HospId INT,

HospName NVARCHAR(10),

UserName NVARCHAR(10))

DECLARE @OBCases TABLE

(

CaseId INT,

HospId INT,

UserName NVARCHAR(10))

DECLARE...

Great question. Good to know.

Good question. Thanks

hr_sn (8/5/2011)

---

When I figured about this tool a while ago, I was same.. WOW.. And we just ended up using this tool at one of our DW implementation for change...

Straight forward question...