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)
 tsql

Author  Topic 

Martin Knotek
Starting Member

1 Post

Posted - 2007-10-05 : 10:55:15
Hi,

Knows anybody solution for this problem:

[url]http://blog.vyvojar.cz/dotnet/archive/2007/10/05/226475.aspx [/url]

Thx a lot

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2007-10-05 : 11:01:11
Why not post your question over here ? It will be easier for those intend to help you.
And what is the expected result ?


KH
[spoiler]Time is always against us[/spoiler]

Go to Top of Page

jsmith8858
Dr. Cross Join

7423 Posts

Posted - 2007-10-05 : 11:44:38
looks like a simple CROSS JOIN followed by an outer join to me.

see:

http://weblogs.sqlteam.com/jeffs/archive/2005/09/12/7755.aspx


- Jeff
http://weblogs.sqlteam.com/JeffS
Go to Top of Page
   

- Advertisement -