Urgent - please solve this issue...

[VijayAnand Gopalakrishnan]

hi folks,

Here is my input

Platform ID_Linked dec_data
--------------- ------------- -----------
NULL ID Linked 281
NULL ID Not Linked 552
DEC axia04 ID Linked 2746
DEC axia04 ID Not Linked 387
DEC axiw01 ID Linked 499
DEC axiw01 ID Not Linked 12
DEC axiw02 ID Linked 2592
DEC axiw02 ID Not Linked 418
DEC bondm ID Linked 240
DEC bondm ID Not Linked 11
DEC buzard ID Linked 241
DEC buzard ID Not Linked 13
DEC dove ID Linked 96
DEC dove ID Not Linked 6
DEC swan ID Linked 96
DEC swan ID Not Linked 6
DEC wallstreet ID Linked 307
DEC wallstreet ID Not Linked 4
DEC wboro1 ID Linked 50
DEC wboro1 ID Not Linked 64


I need to sperate it into two tables which has only ID Linked and ID Not LInked..

if possible how can we write a query...

how can we do it..

Please lemme know...

Thanks for ur help,,,

[Ivo]

Hi folk
you don't write what structure of your input is, is it text, or table, or excel or what ?
If it is a table on the SQL Server, there is nothing to solve, 2 select commands.
If it is so urgent, write answer to me directly.
Bye
Ivo


------------
VijayAnand Gopalakrishnan at 8/13/01 2:00:16 PM


hi folks,

Here is my input

Platform ID_Linked dec_data
--------------- ------------- -----------
NULL ID Linked 281
NULL ID Not Linked 552
DEC axia04 ID Linked 2746
DEC axia04 ID Not Linked 387
DEC axiw01 ID Linked 499
DEC axiw01 ID Not Linked 12
DEC axiw02 ID Linked 2592
DEC axiw02 ID Not Linked 418
DEC bondm ID Linked 240
DEC bondm ID Not Linked 11
DEC buzard ID Linked 241
DEC buzard ID Not Linked 13
DEC dove ID Linked 96
DEC dove ID Not Linked 6
DEC swan ID Linked 96
DEC swan ID Not Linked 6
DEC wallstreet ID Linked 307
DEC wallstreet ID Not Linked 4
DEC wboro1 ID Linked 50
DEC wboro1 ID Not Linked 64


I need to sperate it into two tables which has only ID Linked and ID Not LInked..

if possible how can we write a query...

how can we do it..

Please lemme know...

Thanks for ur help,,,