var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: how to write a query for..
I've compiled the question onto a image, just to explain it clearly and here are the links
please help me, I'm newbie for database.. any help will be appreciated..thanks in advance
Last edited by shhash; 05-15-09 at 11:18.
What version of SQL Server?
For 2005 and up, use a Common Table Expression (CTE).
For earlier versions, there is an efficient technique using a temporary table.
I'm using sql 2000 developer edition.
You should upgrade to (at least) 2005, but until you do you can use this method: sqlblindman - Returning Child Records
yep, I installed .NET 2008 sp1 and sql sever 2008.