miss.delinda (5/23/2011)

---

My mistake. My table as following,

declare @tMenuCollection table(idx int,parentID int,menuNme varchar(50),navigateUrl varchar(50));

insert into @tMenuCollection values(1,0,'Bayar Zakat','void(0)');

insert into @tMenuCollection values(2,0,'Amil','void(0)');

insert into @tMenuCollection values(3,0,'Kira Zakat & Simpan','void(0)');

insert into @tMenuCollection values(4,3,'Tambah','void(0)');

insert into...

I can't get your solution to work Wayne (which is irritating because mine...

Please read this link[/url] for how to best get answers to your questions.

If you set-up and post create table scripts plus sample data and expected results then you'll get back...

Plenty of different ways to do that. Here's two: -

--CTE Option

;WITH CTE AS (

SELECT CartesisRU, CartesisBU, HFMEntity, WBU,

ROW_NUMBER() OVER(partition by CartesisRU, CartesisBU ORDER BY CartesisRU, CartesisBU) AS rn

FROM #Cartesis_to_hfm)

SELECT b.CartesisRU,...

Not too difficult - there are two of us that work on the database servers and it wasn't me. . . 😀

We've solved our issue, it was a D'OH moment 😉

Basically, the code I posted above is an older version of what had been deployed to the server (must've been changed...

Ninja's_RGR'us (5/19/2011)

---

When the backup is taken, the space is marked available for reuse. so the log doesn't need to grow.

You can schedule it more than once... maybe every...

I'm not sure that would solve the issue I'm having (I'm not saying it won't, just that I'm confused as...

;WITH highest_attendance AS (

SELECT subject, attendance,

ROW_NUMBER() OVER (ORDER BY attendance DESC) AS rn

FROM (SELECT 'math' AS subject, COUNT(math) AS attendance

FROM results

...

What sort of result are you after?

SELECT attendedMath, attendedPhysics, attendedChemistry

FROM (SELECT COUNT(math) AS attendedMath

FROM results

WHERE math <> 0)...

Had you written that the first time I wouldn't have...

Ninja's_RGR'us (5/18/2011)

---

Just the heads up. NEVER EVER use nolock unless you're prepared to get crap data (not enough or too much of the valid data). Nolock is not...

ashok.faridabad1984 (5/18/2011)

---

🙁 Hi, my problem is simple, if you go through my replies, i hope you got the problem and now..

logic to obtain the result is if the attrib is...

I think I'd go for two stored-procedure.

In your roll-out script, create the 2000 code in a stored-procedure if 2000 is detected. Then execute the 2000 stored-procedure that does your index...

--Sample data--

DECLARE @TABLE AS TABLE(id INT, attrib INT, begda VARCHAR(10), endda VARCHAR(10))

INSERT INTO @TABLE

SELECT 1, 100, '3/10/2010', '3/31/2010'

UNION ALL SELECT 1, 100, '4/1/2010', '4/10/2010'

UNION ALL SELECT 1, 2, '4/11/2010', '5/15/2010'

UNION...