Great example... Sadequal...

Very useful.. Thanks

skjoldtc (5/7/2009)

---

ALZDBA (5/7/2009)

---

skjoldtc (5/7/2009)

---

I find the intellisense helpful in SS2008. But then, I haven't coded in T-SQL forever. I've gotten used to the intellisense in Visual Studio. Maybe that's helped...

Hi, Sylvia

I totally agree with you, many of the developers are using meaningless aliasing and that would be very tough to debug in future and waste of time. even i...

Here is another simple SP for Paging that works even in SQL-2k.

------------------------------------------

CREATE Procedure usp_GetPagedOrders

@PageIndex integer,

@PageSize integer

---*** HOW TO USE USE...

This query takes care if some IDs are missing..... 🙂

SELECT Accounts.ID, CONVERT(varchar(50),TransactionDate,101) AS TransactionDate, Balance,

( SELECT Sum( Balance )

FROM ( SELECT Top 5 A.Balance

FROM...

Below my Query is taking if some IDs are missing... 🙂

SELECT Accounts.ID, CONVERT(varchar(50),TransactionDate,101) AS TransactionDate, Balance,

( SELECT Sum( Balance )

FROM ( SELECT Top 5 A.Balance

...