Hi,
I have a parent table and Child table.
For example SKU Description Table and MODEL Table,
one sku can have several Models
say model1,model2,model3,model4
I want to return columsn like
COLUMNS sku, model1,model2,model3,model4
ROW skua,A,NULL,B,NULL
skub,A,NULL,NULL,D
In Oracle you can do it using decode.
Can anyone tell me how to do it in TSQL for MS SQL Server.
Thanks,
Mingle,.
[Non-text portions of this message have been removed]
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/AspClassicAnyQuestionIsOk/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
