In this case I would consider using a temporary table

😎

BTW: Yes a jolly good day! 😀

You can use the Window functions

😎

DECLARE @ColorList TABLE

(

CarID float

, ColorID int

)

INSERT INTO @ColorList

SELECT 1.55948815793043E+15, 9 UNION ALL

SELECT 1.55948815793043E+15, 27 UNION ALL

SELECT 1.62851796905743E+15, NULL UNION ALL

SELECT 1.62851796905743E+15, 27 UNION ALL

SELECT 1.62851796905743E+15,...

Out of curiosity, which server version and which SSMS version?

BTW: nice! 😎

According to Celko, "Machine-level things like a BIT or BYTE data type have no place in SQL."

😎

You may want to look at this first, Maximum Capacity Specifications for SQL Server, and maybe rethink the approach.

😎

KGJ-Dev (5/6/2014)

---

But i have half million records in my table and if i need to select Top 10000, i need to make this as dyncamic. Any help on making it...

So it accurately holds zero, but zero is not a real number.....?

😎

Cannot consider bit to be an integer datatype, more like a flag, kind of "fingers or no fingers" instead of "how many fingers".

😎

DECLARE @FIRST_BIT BIT = 1;

DECLARE @NEXT_BIT ...

Almost there, just missing...

First a quick question, why the dirty read (READ UNCOMMITTED)?

Without more information such as execution plans, view code, schema structure etc., it is hard to tell what the problem is.

😎

Thank you for this William, very useful!

😎

Take a look at this article, Script to create dynamic PIVOT queries in SQL Server[/url]. It should have what you need.

😎

Good question, thanks!

Did think a bit for a second:-D

Very good, thanks!

😎