Database

Thanks for Help!
But its about 200 to 500 of this items!

How can i do that ?<br />
<br />
and why doesn't the SQL create correct scripts.

jojoba2011 wrote:

and why doesn't the SQL create correct scripts

Bastard Programmer from Hell

Thanks!<br />
but this is not good trick!<br />
and no use in here cause i have different parameters;<br />
this was example @Param.

SELECT opdetm.warehouse, opdetm.product, opdetm.net_price, opdetm.despatched_qty, opheadm.date_despatched 
FROM vektron.scheme.opdetm INNER JOIN vektron.scheme.opheadm ON opdetm.order_no = opheadm.order_no ,
(SELECT ROW_NUMBER() OVER (PARTITION BY opheadm.order_num ORDER BY date_entered DESC) , *  FROM vektron.scheme.opheadm inner join vektron.scheme.opdetm on opdetm.order_no = opheadm.order_no) as ordlist
WHERE(((opheadm.status) = '8') And ((opdetm.warehouse) = '06') And ((opdetm.net_price) > 0) And ((opdetm.despatched_qty) > 0)) and ordlist.order_no = 1 and opdetm.product = ordlist.product
ORDER BY opdetm.product, opheadm.date_despatched DESC

WITH original_query AS (
    SELECT scheme_opdetm.warehouse, scheme_opdetm.product, scheme_opdetm.net_price, scheme_opdetm.despatched_qty, scheme_opheadm.date_despatched
    FROM scheme_opdetm INNER JOIN scheme_opheadm ON scheme_opdetm.order_no = scheme_opheadm.order_no
    WHERE (((scheme_opheadm.status)="8") AND ((scheme_opdetm.warehouse)="06") AND ((scheme_opdetm.net_price)>0) AND ((scheme_opdetm.despatched_qty)>0))
    ORDER BY scheme_opdetm.product, scheme_opheadm.date_despatched DESC;
    )
,last_despatched AS (
    SELECT  product,Max(date_despatched) AS date_despatched
    FROM    original_query
    GROUP BY product
    )
SELECT  o.warehouse, o.product, o.net_price, o.despatched_qty, o.date_despatched
FROM    original_query o,last_despatched l
WHERE   o.product = l.product
AND     o.date_despatched = l.date_despatched

ORDER BY scheme_opdetm.product, scheme_opheadm.date_despatched DESC;

Ramkumar_S wrote:

Please suggest proper way to do.

• Add the MySql server as a linked server and sync using triggers
  
• Write an app to do the synchronization, using the Sync Framework
  
• Upgrade Sql Server
  

Bastard Programmer from Hell

SELECT Distinct(A.x), A.Y FROM @TEST A, @TEST B WHERE A.X = B.y

DECLARE @TEST TABLE (X VARCHAR(10),Y VARCHAR(10))
 
insert into @TEST values ('A','B')
insert into @TEST values ('C','D')
insert into @TEST values ('E','F')
insert into @TEST values ('B','A')
insert into @TEST values ('D','C')
insert into @TEST values ('F','E')


SELECT A.X
,(
select  top 1 b.y from @test as b where b.y > a.x  and b.x<a.y
) as subY

 FROM @TEST A
where 
(
select  top 1 b.y from @test as b where b.y > a.x  and b.x<a.y
) is not null
order by a.x