sql server 2008 - Why does @Table not work for me? -
Can someone tell why this query is not working?
DECLARE @Untered Roche Tab (ProductId INT, Product Name VARCHAR (50), Description VARCHAR (50), Category VARCHAR (50), Duplication VARCHAR (50)); Choose * from INNTOVANTROW (select *., More than Row_Number ()) as part of [repetitons] by tblProduct A) as A, where as A.Repetitons & gt; 1
error comes to me
`message 102, level 15, state 1, line 12 'continuous rows' has incorrect syntax message 156, level 15, state 1, Line 15 keyword 'AS' has the wrong syntax.
Edit:
Now it duplication
: -
INSERT @ unverified rouches Select. *, Rhn_number () over (product by id segment by product id) as [recurrence] as tblProduct a where a.Repetitons & gt; 1
`
Invalid column name 'duplication'.
An error I received was found in in Select < / Strong> Make a statement Choose
After working properly without a signal error, question:
DECLARE @ unverified ROS table (Product id INT, ProductLaman VARCHAR (50), Description VARCHAR (50), Category VARCHAR (50), Duplication VARCHAR (50)); Choose Insert INTO @InvantedRows. *, More than Row_Number () divided by product ID (by ProductId), from [recurrence] where tblProduct is from A.Repetitons & gt; 1
Inside the above query you can also try
Choose from Insert in INTOVANTROW * (select. *, Row_Number () over) Partition by ProductId, Ordering Product Id) as [recurrent] from tblProduct) d where d. Repetition & gt; 1
Comments
Post a Comment