getting error

Question

SELECT *
INTO #newtable
FROM (select wp.PickListNo,wp.OrderNo,wp.ArtNo,wp.Aielse_Code from
wms_picking wp
inner join
wms_loose_transaction lt
on wp.PickListNo=lt.StatusTemp
where wp.PickListNo='PKL035311'
and left(lt.monoboxno,7)='1619199')

Msg 102, Level 15, State 1, Line 9

Incorrect syntax near ')'.

Sanjeeb Lenka · Answer

try this one it may help you select wp.PickListNowp.OrderNowp.ArtNowp.Aielse_Code INTO #newtable from wms_picking wp inner join wms_loose_transaction lt on wp.PickListNo=lt.StatusTemp where wp.PickListNo='PKL035311' and left(lt.monoboxno7)='1619199'

Ravi Shekhar · Answer

sanjeev and iftikhar sir your code is running .Thanks. I have done with below query create table #TempTable ( PicklistNo varchar(30) orderno varchar(50) artno varchar(25) Aielse_Code varchar(20) Monoboxno varchar(50) ) insert into #TempTable select wp.PickListNowp.OrderNowp.ArtNowp.Aielse_Codelt.MonoboxNo from wms_picking wp inner join wms_loose_transaction lt on wp.PickListNo=lt.StatusTemp where wp.PickListNo='PKL035311' and left(lt.monoboxno7)='1619199'

Iftikar Hussain · Answer

try like this you need to give alias name for your sub query SELECT * INTO #newtable FROM ( select wp.PickListNowp.OrderNowp.ArtNowp.Aielse_Code from wms_picking wp inner join wms_loose_transaction lt on wp.PickListNo=lt.StatusTemp where wp.PickListNo='PKL035311' and left(lt.monoboxno7)='1619199' ) as Data Regards Iftikar

Alistair Cook · Answer

Hi try this approach can help you INSERT INTO @tbl (ProductID ProductName ProductDescription price ) SELECT ProductID ProductName ProductDescription price FROM MyTable Select ProductID ProductName ProductDescription price FROM @tbl

Muralidharan Deenathayalan · Answer

I hope you should have a table name after FROM clause and I don't know the sub-query will act as table here. Let me open sql server for you.

Muralidharan Deenathayalan · Answer

What is the error ?

Iftikar Hussain · Answer

Hi What error you are getting? Can you explain more? Regards Iftikar