Database

WITH Ordered AS (
    Select  IDColumn,DateColumn,ROW_NUMBER() OVER(ORDER BY DateColumn) as rn
    FROM    YourTable
    )
SELECT  o2.IDColumn,DateDiff(seconds,o2.DateColumn - o1.DateColumn)
FROM    ordered o1
join    ordered o2
on      o1.rn = o2.rn - 1

-- Copy Article stuff
DECLARE @List VARCHAR(1000), @Sql VarChar(5000)
SET @List = ''
SET @Sql = ''

IF EXISTS (SELECT * FROM tempdb.sys.objects
		WHERE name LIKE '#tblX%' AND type IN (N'U'))
	DROP TABLE [dbo].#tblX
	
CREATE TABLE #tblX(MixDate DateTime, NoMixes Int, MixPlant_Name VarChar(50) )
INSERT [#tblX]
SELECT DISTINCT(mp.MixDate), SUM(mp.NoMixes) As NoMixes, Mixplant.MixPlant_Name
	FROM MixProduction mp
	  INNER	JOIN MixPlant
	    ON mp.MixPlant_ID = Mixplant.ID And MixPlant.IsActive =1
	WHERE mp.MixDate BETWEEN '2/1/2011' AND '2/28/2011'
	Group By Mixplant.MixPlant_Name, mp.MixDate	
	
	
	
DECLARE @tblY TABLE(MixPlant_Name VarChar(50))
INSERT @tblY
  SELECT DISTINCT MixPlant_Name
    FROM #tblX
      ORDER BY MixPlant_Name
		
 SELECT @List = ISNULL(@List, '') +
		 CASE WHEN ISNULL(@List,'') = ''
		 THEN '[' + MixPlant_Name + ']'
		 ELSE ',[' + MixPlant_Name + ']' END
FROM @tblY
ORDER BY MixPlant_Name
		
SET @Sql = 'SELECT MixDate, ' + @List + CHAR(13)
SET @Sql = @Sql + 'FROM (SELECT MixDate, NoMixes, MixPlant_Name ' + CHAR(13)
SET @Sql = @Sql + 'FROM #tblX ) As P ' + CHAR(13)
SET @Sql = @Sql + 'PIVOT (SUM(NoMixes) FOR MixPlant_Name IN (' + @List + ')) As Pvt' + CHAR(13)
	
-- test output
--print @sql
--SELECT * FROM #tblX
	
-- exucute dynamic sql
Exec (@Sql)
	
-- Drop Table
DROP TABLE #tblX
GO

select * from tblPackages where id = 1 and code = 58
UNION
select * from tblPackages where id = 3 and code = 31

SELECT * 
FROM tblPackages main
WHERE Id IN (1,3)
AND   Code IN (58, 31)
AND   Package = (SELECT DISTINCT Package 
                 FROM (SELECT Package 
                       FROM   tblPackages
                       WHERE  id = 1 
                       AND    code = 58) a,
                      (SELECT Package 
                       FROM   tblPackages
                       WHERE  id = 3 
                       AND    code = 31) b
                 WHERE a.Package = b.Package)

... WHERE (id = 1 AND code = 58) OR (id = 3 AND code = 31)

CodingLover wrote:

all the package details that id = 1 / code = 58 and id = 3 / code = 31

pak 3 | 3 | 8 | 31

Luc Pattyn wrote:

The enquirer will have to make up his mind and tell us what he really wants

DECLARE @Currency VARCHAR(50) -- doesn't need to support unicode
SET @Currency =' USD' -- add a space for readability

-- you can only concatenate strings, so cast the value to NVARCHAR
SELECT CAST(Currency AS VARCHAR) + @Currency AS [Currency] 
  FROM tbl_Emp

I are Troll

Eddy Vluggen wrote:

Sql isn't the correct place to change the fieldname into a headername

Eddy Vluggen wrote:

Not my downvote

Eddy Vluggen wrote:

I appreciate sarcasm

Eddy Vluggen wrote:

hard to globalize