There are many ways to do it, but I prefer the CROSS APPLY way as it seems to be faster than other methods.

SELECTT.RID, T.Posi, T.BusTypeCode, T.TripName, AB.BusN AS RandomBusN

FROM@tTrip T

CROSS...

I am glad I could help.

Here is the link that you were looking for http://msdn.microsoft.com/en-us/library/ms157285.aspx

Yes, you can use the Hidden property of report items to conditionally suppress the items based the report data.

RBarryYoung (2/6/2010)

---

Ramesh Saive (2/6/2010)

---

The Dixie Flatline (2/5/2010)

---

Ramesh, I don't believe he has to worry about that. If he first does a crosstab or pivot as Jack suggests,...

After few modifications, I came to this solution and I hope it should work fine this time.

/****** Object: Trigger [dbo].[Trg_Insert_Temp2] Script Date: 02/06/2010 13:09:18 ******/

SET ANSI_NULLS...

Jeff Moden (2/5/2010)

---

Heh.. Let's...

The Dixie Flatline (2/5/2010)

---

Ramesh, I don't believe he has to worry about that. If he first does a crosstab or pivot as Jack suggests, he can just...

As Jeffrey said, if you just need incremental values without bothering about gaps then an IDENTITY column would do the best job. All you have to do is mark...

Jeff,

Nobody has mentioned about the deprecated procedure expect you, so I was little confused, but now everything is fine.

Upto this I've understood correctly. But you mentioned that one can also update other columns such as Product_ID, Market_ID etc., What would be the impact of these updates on...

At first look at your code, I really don't think you need any cursors at all. But to proceed further, you need to provide some more information such as table...

You might need to do running decremental total, for this follow this article http://www.sqlservercentral.com/articles/T-SQL/68467/[/url]

This should work, it uses ROW_NUMBER() function to generate sequential no for each row.

USE [TRAIN]

GO

DECLARE @inspkey int,

@inspno int, ...

Can you give a more elaborate example with input/output data?