Sorry for that, will be back with you in a short while.

😎

Jeff Moden (5/6/2014)

---

rhythmk (5/6/2014)

---

Jeff Moden (5/5/2014)

---

Even though I strongly [font="Arial Black"]disagree [/font]that BIT is an integer datatype simply because it can't be used in certain bits of math, such as...

How about select top(x) from y where z > v order by z?

😛

bedmett 9 (5/6/2014)

---

I'm sure Andy misapplied the triangle analogy.

The triangle analogy could have been applied to how long it took to get to 2014 and the kind of computers available...

Be careful here, all dynamic sql strings must be defined as N' string ', if missing the "N" in front, it will cause an implicit cast from (v)char to n(v)char,...

sbaer (5/6/2014)

---

If possible, establish a single data collection point. From there it is easy to distribute the client's data to the appropriate destinations. In the central repository, maintain all the...

sbaer (5/6/2014)

---

I am fairly new to database design and haven't been able to find a lot on this question.

I work for a marketing and advertising firm. We don't have...

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.....?

😎