CREATE TABLE Table1(
pnr VARCHAR2(11) PRIMARY KEY,
fnamn VARCHAR2(20),
enamn VARCHAR2(20),
bor_i VARCHAR2(20),
jobbar_i VARCHAR2(20));

CREATE TABLE Table2(
regnr VARCHAR2(6) PRIMARY KEY,
pnr REFERENCES bilägare(pnr),
tillverkare VARCHAR2(20),
modell VARCHAR2(20),
årsmodell NUMBER(4),
hk NUMBER(4),
datum DATE); 

CREATE TABLE Table3(
pnr VARCHAR2(11),
fnamn VARCHAR2(20),
enamn VARCHAR2(20),
regnr VARCHAR2(6),
tillverkare VARCHAR2(20),
modell VARCHAR2(20));

SET DATEFIRST 1

DECLARE @Date datetime
DECLARE @Year int

SET @Date = '2011-01-01'
SET @Year = YEAR(@Date)

WHILE YEAR(@Date) = @Year
BEGIN
    IF DATENAME(DW, @Date) = 'Monday' AND @Date<=GetDate()
    BEGIN        
        SELECT 
            [Week],
            SUM(CASE TypeOfInvoice WHEN 'Kredit' THEN 1 ELSE 0 END) AS [OpenKredits],
            SUM(CASE TypeOfInvoice WHEN 'Debet' THEN 1 ELSE 0 END) AS [OpenDebets]
        FROM 
            tblInvoices 
        WHERE
            [CreatedDateTime] <= @Date
            AND ([ResolvedDateTime] > @Date OR [ClosedDateTime] > @Date) 
    END
    SET @Date = DATEADD(d, 1, @Date)
END

Citat

	SQL = "UPDATE bib_loan SET "
	SQL = SQL & "return='" & Now & "' "
	SQL = SQL & "WHERE loan_id='"& strLoanID & "'"
	Connect.Execute(SQL)

<!--#include file="inc/pagehead.asp"-->

<%
	Set RecSet = Server.CreateObject("ADODB.RecordSet")
	SQL = "SELECT * FROM bib_book Where id=" & Request.QueryString("ID")
	Set RecSet = Connect.Execute(SQL)
		strLoanID = RecSet("loan_id")
	RecSet.Close
	Set RecSet = Nothing 
	
	SQL = "UPDATE bib_loan SET "
	SQL = SQL & "return='" & Now & "' "
	SQL = SQL & "WHERE loan_id='"& strLoanID & "'"
	Connect.Execute(SQL)
	
	SQL = "UPDATE bib_book SET "
	SQL = SQL & "loan_userid=0, "
	SQL = SQL & "loan_id=0 "
	SQL = SQL & "WHERE id='"& Request.QueryString("ID") & "'"
	Connect.Execute(SQL)

Response.Redirect(Request.ServerVariables("HTTP_REFERER"))
%>


<!--#include file="inc/pagefoot.asp"-->

	             kolumner med kriterium		
rader med kriterium     | kol2=1     | kol2=2     | kol2=3
                        -------------------------------------
             kol1=A     |     A1     |     A2     |     A3
             kol1=B     |     B1     |     B2     |     B3
             kol1=C     |     C1     |     C2     |     C3

select count (nvl(årslön,0)) antal
from kund
where (årslön) < 300000;

USERNAME PASSWD   FNAMN     ENAMN     YRKE         REGDATUM   ÅRSLÖN
-------- -------- --------- --------  ------------ ---------- ------
XXXL     IRule    Margareta ek        VD           2001-06-29 942000
KLÖven   bintje   Tomas     kvist     Potatisbonde 2000-02-28 198000
h01hanro T56xxL   Sven      Larsson                2003-08-09 
OlleBull Bullas   hans      Lindqvist              2002-05-05 116000
MEZcal   P33kssa  maria     Nyberg    psykolog     1999-08-29 435000
IceMan   Quantos  Maria     Nyberg    Ingenjör     1998-02-14 412000
Rolven   revolver roger     nyberg                 1998-10-29 240000
MrBig    MBisKING Roger     nyberg    Officer      1998-11-29 317000
King25   asdf1234 charlotte Ortiz     tandläkare   2003-12-10 586000
MrMDI    MDIisit  Hans      Rosenboll adjunkt      1997-01-15 307000 10 rows selected

SELECT tbl1.col 
FROM pd_mounting_details 
WHERE col = 1 AND col2 IN 
   (
   SELECT id FROM 
      (
      SELECT top 2 MIN(prod_week) AS te 
      FROM pd_mounting_details 
      WHERE status=4 
      GROUP BY oe.prodplan_id 
      ORDER BY te
      )
   AS ta
   )
ORDER BY prod_week ASC

SELECT oe.id AS oeID,
   oh.ordernumber,
   oe.order_line,
   oe.prodplan_id,
   oe.amount AS amountOfDoors,
   oe.door_type,
   oe.inner_color,
   oe.outer_color,
   oe.prod_week,
   i.amount AS iAmount,
   md.status AS mdStatus,
   i.width,
   i.LENGTH, 
   c.color_name AS innerColor,
   c2.color_name AS outerColor,
   pp.status,
   oe.pos,
   md.starttime
FROM 
   pd_mounting_details AS md
   LEFT OUTER JOIN pd_order_eco AS oe ON md.order_data = oe.id
   LEFT OUTER JOIN pd_article AS a ON md.article = a.id
   LEFT OUTER JOIN pd_inventory AS i ON md.id = i.pp_id
   LEFT OUTER JOIN pd_order_head AS oh ON oe.order_head = oh.id
   LEFT OUTER JOIN pd_colors AS c ON oe.inner_color = c.id
   LEFT OUTER JOIN pd_colors AS c2 ON oe.outer_color = c2.id
   LEFT OUTER JOIN pd_production_plan AS pp ON oe.prodplan_id = pp.id
WHERE 
   (a.production_group = 1)
   AND (NOT (oe.amount = 0))
   AND (pp.status = 4)
   AND (md.stoptime ='' OR md.stoptime IS NULL)
   AND (NOT a.name='Al.pr ligg'
   AND NOT a.name='Al.pr stå')
   AND oe.prodplan_id IN 
      (
      SELECT prodplan_id
      FROM
         (
         SELECT top 2 
            MIN(oe.prod_week) AS te,
            oe.prodplan_id
         FROM 
            pd_mounting_details AS md
            LEFT OUTER JOIN pd_order_ecolid AS oe ON md.order_data = oe.id
            LEFT OUTER JOIN pd_article AS a ON md.article = a.id
         WHERE 
            oe.status=4
            AND (md.stoptime ='' OR md.stoptime IS NULL)
            AND (a.production_group = 1)
            AND (NOT oe.amount = 0)
            AND (NOT a.name='Al.pr ligg'
            AND NOT a.name='Al.pr stå')
         GROUP BY 
            oe.prodplan_id
         ORDER BY 
            te
         ) 
         AS ta
      )
ORDER BY 
   oe.prod_week ASC,    oe.pos

SELECT *, MATCH(tagText) AGAINST ('+bull*' IN BOOLEAN MODE) AS score FROM tag WHERE MATCH(tagText) AGAINST ('+bull*' IN BOOLEAN MODE) ORDER BY score DESC, tagText ASC LIMIT 0,5