Hi every one
This is my House_info and House_product table
House_info
|
Id
|
Behcode
|
Name
|
Description
|
address
|
H_name
|
|
1
|
1111
|
Jack
|
Test test
|
India
|
Cloth
|
|
2
|
2222
|
Ana
|
Test test
|
england
|
Electric
|
|
3
|
3333
|
Edvard
|
Test test
|
Italy
|
electric
|
|
4
|
4444
|
Math
|
Test test
|
Franch
|
Furniture
|
House_product
|
Id
|
Behcode
|
Name
|
Description
|
Date
|
H_name
|
|
1
|
2222
|
Iron
|
Test
|
1/1/2011
|
Electric
|
|
2
|
4444
|
Sofa
|
Test
|
1/2/2011
|
furniture
|
|
3
|
1111
|
Scarf
|
Test
|
5/3/2011
|
Cloth
|
|
4
|
3333
|
Laundry
|
Test
|
6/7/2011
|
electric
|
And this is my SP that fill my datalist with this SP from House_info
ALTER procedure [dbo].[test1]
as
begin
select substring([Description],0,45)+'...' As Description , substring([address],0,26)+'...' As address, Name
from House_Info
end
COlumn Behcode is same in 2 table
I want SORT column in House_info table by DATE COLUMN in House_product
how I can do it?
thanks
