Xfigs15

Xfigs15



Publishing - Microsoft Developer Studio - [reptq2 : Stored Procedurę (pubs)]

1) File Edit View insert Project Build Jools Window Help

Publishing - Microsoft Developer Studio - [reptq2 : Stored Procedurę (pubs)]

£ ! ii II


i © -    CB {S §* % Phone


"3    «*©


_l*


B-tj§P PubDB

i -i pubs (PENTIUM)

0 1_] Database Diagrams ffl P~1 Tables Ę O Views


< I ' • "

►r

■1CL R... I *] Fil... 9 D...

7^


CREATE PROCEDURĘ reptq2 AS

select type, pub_id, titles.title_id, au_ord, Name = substring (au_lname, 1,15), ytd_sales froi titles, authors, titleauthor where titles.title_id = titleauthor.title_id AND authors.au_id = titleauthor.au_id AND pub_id is NOT NULI order by pub_id, type

COMPUTE avg(ytd_sales) BY pub_id, type COMPUTE avg(ytd_sales) BY pub_id

AJ

Running dbo.reptq2.

type

pub_id

title_id

au_ord

Name

ytd_sales

business

0738

BU2075

1

Green

18722

(1 row(s) affected)

AVG

18722

(1 row(s) affected)

type

pub_id

title_id

au_ord

Name

ytd_sales

psychology

0736

PS2091

2

Ringer

2045

psychology

0736

PS2091

1

Ringer

2045

psychology

0736

PS2106

1

Ringer

111

psychology

0736

PS3333

1

Uhite

4072

psychology

0736

PS7777

1

Locksley

3336

(5 row(s) affected)

AVG

a

4 1 ► )>ug \ Find in Files 1 \ Find in Files2 \

Results

SQL Debugging / | 4 \

►r


Ready


Start

r:, m...

t3P:-

6Js-

il w..

BFMi...

t3P:-

8 A...

1^*1 K...

tfE...


«©P...


IFr...


Ln 13, Col 65    RE AD

W


2:07 PM



Wyszukiwarka

Podobne podstrony:
Xfigs25 Publishing - Microsoft Developer Studio - [Diagraml : Database Diagram (pubs) *] -*a File Ed
Xfigs14 Publishing - Microsoft Developer Studio - [reptq2 : Stored Procedurę (pubs)] mi Publishing -
Yfigs06 exception1 - Microsoft Developer Studio - [exception1 .cpp] -Ifll x
Ufigs12 uery - Microsoft Developer Studio - [QueryDlg.cpp] B00 £3 File Edit View insert Project Buil
Sfigs18 Microsoft Developer Studio - [DierolICtl.cpp] ■0B [El File Edit View insert Project Build Jo
KKfig14 ieRollControl - Microsoft Developer Studio - [PA..ADieRollControl.idl]B0E 1) File Edit View
Sfigs07 ieroll - Microsoft Developer Studio - [P:..ADierollDierollCtl.cpp]-
Hfig07 icrosoft Developer Studio - scroll - [lnfoViewer Topie] B0E File Edit View insert Project Bui
Hfig08 m icrosoft Developer Studio - scroll - [lnfoViewer Topie]B00 File Edit View insert Project Bu
Ifig10 icrosoft Developer Studio - printl - [P:..Aprint1print1Doc.cpp] [?] File Edit View insert Pro
Ifig11 icrosoft Developer Studio - printl - [P:..Aprint1print1Doc.cpp] [?] File Edit View insert Pro
Ifig12 icrosoft Developer Studio - printl - [P:..Aprint1print1View.cpp] [?] File Edit View insert Pr
Ifig14 icrosoft Developer Studio - printl - [P:..Aprint1print1View.cpp] [?] File Edit View insert Pr
Kfigs02 Iicrosofl Developer Studio - ShowString - [ShowStringView.cpp] [El File Edit View insert Pro
Pfigs10 icrosoft Developer Studio - ShowString - [ShowStringView.cpp *] m B00 File Edit View in

więcej podobnych podstron