Database

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

PIEBALDconsult wrote:

I didn't think so.

PIEBALDconsult wrote:

As do I, but none was intended.

PIEBALDconsult wrote:

I don't see the problem

I are Troll

PIEBALDconsult wrote:

Sure it is. You should have the SQL do as much as possible and avoid having to do work in code. That's one of the functions of views.

jschell wrote:

I would say that without qualification that is not true.

jschell wrote:

producing a format that represents a 'report'. So it must of course provide
headers.

jschell wrote:

if I am writing a java/C# application whose point is to produce a report

PIEBALDconsult wrote:

I wrote such a reporting system on my last job and there is one at my new job. Neither has the ability to alter the column headings so it must all be done in the query. The engine simply outputs the contents of a DataTable.

I are Troll

PIEBALDconsult wrote:

That's generally a rather poor scheme, unless the reports are very specialized and something like Crystal ( ) won't do.

PIEBALDconsult wrote:

<layer>I wrote such a reporting system on my last job and there is one at my new job. Neither has the ability to alter the column headings so it must all be done in the query. The engine simply outputs the contents of a DataTable. I can add the ability to mine a couple of different ways.

select PID
      ,sum(qty)/(sysdate-min(date))  <<-- fixed this to account for sign.
  from (
  select PID
        ,qty
        ,date
    from your_table
   where date >= sysdate - 182
  )
group by PID;

SELECT
	PID,
	AVG(qty)/DATEDIFF	(d,MAX(date),	MIN(date))
FROM TableName
WHERE date > DATEADD(-6, GETDATE())
GROUP BY pid