Xfigs14

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

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

Jj9jx]

File Edit View insert Project Build Jools Window Help

! B * H & Q

■±\z\

- PubDB

i--® pubs (PENTIUM)

B l__) Database Diagrams El O Tables B G Views B-G Stored Procedures B ^ byroyalty Ę] ^ reptgl

s MiSSSS.

B ^ reptq3 B ^ sp_adduserobject B ^ sp_checkproperties B ^ sp_dropproperties B ^ sp_droppropertiesbyid B ^ sp_dropuserobject B ^ sp_dropuserobjectbyid B ^ sp_getobjwithprop Ę~S sp_getproperties B ^ sp_getpropertiesbyid B-l sp_setproperty IŚ ^ sp_setpropertybyid

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 = 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

li

■■Cl.

lU Fil... § D... t? In

Ready

ig9Starli r: M...I _i|P: I eys-1 aU W... I |^Mi...| t^P;

im

1:48 PM