Can you describe first and second normal forms?

And/Or What's the difference between first and second normal form and what is the importance/signifigence of that difference?

There is also a list of...

If you are trying to find which Foreign Keys reference a particular column, this link might get you going:

http://blog.sqlauthority.com/2006/11/01/sql-server-query-to-display-foreign-key-relationships-and-name-of-the-constraint-for-each-table-in-database/

Default is (18,0) if that helps.

http://lmgtfy.com/?q=sql+server+table+valued+parameter

Out of curiosity, are you using linked servers to pull data into a warehouse?

The optimizer, in general, does a pretty good job. But, with linked servers it makes it very...

You can... Not sure why you'd want to thought. Maybe this will help:DECLARE @i INT = 0

WHILE @i <= 10

BEGIN

SET @i = (@i % 10) +...

vijayakumarn (5/6/2011)

---

table -1

vijay BE ECE

table-2

vijay ECE ...

vishal.gamji (5/5/2011)

---

I was initially happy to use it but CHECKSUM; but it does not guarantee uniqueness. Since it is returns an interger value the chances of collisions are a lot...

As you discovered, SQL does not guarentee any result order without an ORDER BY clause. That is true with any query, not just CTEs.

There is also the TABLESAMPLE clause:

http://msdn.microsoft.com/en-us/library/ms189108.aspx

From the article there is another way similar to ChrisM's method like this to get aprox 1% of rows:SELECT * FROM Sales.SalesOrderDetail

WHERE...

ROUND returns the same datatype as the value being rounded. So, if you want a different type (like INT) then you need to CAST it.

I know.. pretty sad.. 😉

It might be in other places, but I know that it is in sys.indexes. Specifically, the column filter_definition.

EDIT: Too slow..

For what it is worth, here is an alternative to the Quirky Update also using Jeff's data (thanks for the data Jeff!). First here is a plain select:;WITH cte

AS

(

SELECT Number,...

I'm not sure what the data represents, but it appears that you'd be better off changing the schema rather than working on the query. Again, without knowing what the data...