tnx, problem solved 🙂

any body here ?!

check this out :

http://technet.microsoft.com/en-us/library/cc966414.aspx

dwain.c (6/21/2012)

---

Here's a tested solution including the test harness to validate that it seemed to be producing random results.

CREATE TABLE #tblLottery

(

...

Lowell (6/14/2012)

---

you'd have to explain the rules. for example, if i have a "score" of 5, do i have...

Tnx for your replies

Dave Ballantyne (6/14/2012)

---

Something like this ?

Untested

with ctenum

as

(

Select top(100) Row_number() over (order by (select null)) as rown

from sys.columns

)

SELECT TOP 5...

Problem solved :w00t:

SELECT name

INTO #test

FROM sys.sequences

DECLARE @c INT ,

@name NVARCHAR(50)

SELECT @c = COUNT(1)

FROM #test

WHILE @c...

I found my problem, it was because of this : pk was non-clustered index i change it 2 cluster index and everything is ok now.

tnx

I know pal, but I just want to get my post up 😛

any one here !

TheSQLGuru (5/17/2011)

---

1) Federated databases, where you have data spread across different physical servers, was NEVER a fully functional and useful thing in SQL Server. If you need to be...

tnx a lot for your attentions 😀

No one comments?

No one comments?

Yes, I have 2 servers, one for live data and other one for archived...