two tables and two *.mdf ? - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

two tables and two *.mdf ?

Author

Topic

oguzkaygun
Yak Posting Veteran

53 Posts

Posted - 2009-03-05 : 05:49:58

hi

My StoredProcedure is below.

if amagazlar (table) belong to A.mdf and urunlistesi (table) belong to B.mdf, how can i join them ?

Thanks

begin

;WITH ListEntries AS

( SELECT ROW_NUMBER() OVER (ORDER BY UserId desc)

AS Row, UserId, madi, maciklama,

resim1, urunsayisi

from amagazalar

),

secondlistentries as(

SELECT ROW_NUMBER() OVER (ORDER BY UserId desc)

AS GroupRow, UserId

FROM urunlistesi

where ilanturu = @ilanturu

)

SELECT ListEntries.UserId, ListEntries.madi, ListEntries.maciklama, ListEntries.resim1, ListEntries.urunsayisi

FROM ListEntries full join secondlistentries on ListEntries.UserId = secondlistentries.UserId

WHERE GroupRow between @StartRowIndex and @StartRowIndex+@NumRows

end

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2009-03-05 : 07:23:19

Your query has nothing to do with mdf-files.

Webfred

No, you're never too old to Yak'n'Roll if you're too young to die.

oguzkaygun
Yak Posting Veteran

53 Posts

Posted - 2009-03-05 : 11:07:00

i know.. so i asked for how i should do with different mdf files?
thanks

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources