Author: Jacob Ross

6 ways to avoid scope creep in your next BI project

One of the greatest threats to a successful Data Warehouse/Business Intelligence project is scope creep, and the consequence is often a poor return on investment – or even failure, if not managed properly. We define “scope creep” simply as having a project scope that increases in size due to initially unintended or unanticipated changes to requirements and expectations. We propose six practical methods to handle the risk of scope creep in your next Data Warehouse and Business Intelligence project.

Let’s start with a small analogy to illustrate scope creep, using a situation most people can relate to: Grocery shopping at the supermarket. We have three scenarios:

First shopper has been busy all day and hasn’t planned dinner, and didn’t spend any time planning the shopping trip. But the shopper needs food and has a pretty good idea what is needed. The shopping trip is completed by memory, but while cooking, the unfortunate shopper realizes that ingredients are missing and needs to go back to the store to buy the rest.

Second shopper enters the store with a shopping list and knows exactly what is needed. While having a plan, the shopper still evaluates bargain items on sale and ends up making a few impulse purchases, resulting in a more expensive shopping trip than expected.

Third shopper spends considerable time on planning the trip and enters the store with a shopping list and only brought just enough money to fulfill the list. There is no room to deviate from the plan.

In the world of business, we often appreciate toScope Creep reduce risk, thus most people would argue that “we want to be the third shopper” with a solid plan backed up by a solid budget. But one may find that planning a project down to the very detail may be unfeasible, or at least too costly. When it comes to planning a project, time and budget are not exact science. Too rigid planning may also include the cost of not taking advantage of unanticipated opportunities during the project. The first shopper represents the opposite extreme of having no sense of direction, and resources may be wasted on both unnecessary “ingredients” and a need for a larger scope to finish the “meal”. However, by not planning, the first shopper may still use less time compared to the third shopper, even with the extra shopping trip, and it becomes a matter of defining cost of time versus money. The second shopper represents the type of scope creep we see most frequently, the “forever-moving goalpost.” Any progress in the project spurs new additions, and we end up having a much larger and expensive project than initially anticipated…or even worse, the project gets stuck in the “sales aisle,” with the customer not being able to decide.

So how to avoid scope creep? We offer 6 methods that might save your next DW/BI project!

1. Fewer cooks in the kitchen

Narrow the channel between the business side and the BI development side, so that all requirements and scoping flow through the same people. You want to avoid business requirements being specified to the developers without having been weighed against the existing list of requirements. The downside of having just one person handling the scope is, obviously, that a lot of crucial information walks out the door should that person change careers. This risk can be mitigated with documentation.

2. Playing the “zero-sum game”

The zero-sum game is very simple: Every addition to the scope implies giving something else up in the scope. Consider the third shopper, who only can afford what was initially planned and would need to sacrifice items of equal value with any unplanned additions. Every request of “we also would want…” should be met with “okay…so what else don’t you want?” This is an extremely effective method in managing the size of the project. The downside to this method is that the business user requesting the change may not be able to evaluate the value of existing requirements, and/or does not have the political clout to make such decisions. This would risk great requirements being squashed.

3. Start a second project

Rather than try to fit in new requirements to an existing project, it can be better to simply start drafting a second project. Once the original project has met the defined expectations, the project team can engage in the new project and include the new requirements. The main benefit is that the project team can “worry about new stuff later” and focus on the project at hand. This method helps build a culture of continuous improvement, while keeping project scopes locked down. The downside is the risk of having a more valuable project waiting for the first project to finish.

4. Price the increase of scope

Recall that the second shopper brought home more than what was initially planned, which could be defined as “scope creep,” or it could be the result of poor planning. Either reason does not negate that every addition to a shopping basket must come with a price (our metaphors are law abiding). We recommend that any additions to a project should be estimated and priced. Similar to the zero-sum game, with the difference that you don’t insist on excluding something else, but align all stakeholders expectations to the reality of how much extra time and budget is required for the additions to the scope.

5. Start a backlog

Every additional request to an existing scope can in fact be treated as a request for improvement, which is a compelling alternative to the discussion of whether something is “in” or “out.” We recommend recording the requests on a prioritized list and/or visualized on a chart with difficulty vs. value axis. Have the list/chart available to the development team so they can decide what is possible to add within existing budget constraints. The key is managing the expectations, and the project team can evaluate when the backlog justifies starting a second project.

6. Say no

The simplest yet hardest way to avoid scope creep is simply to say no. Lock down the scope and refuse to accept any additional requests. Like the third shopper, realize that the project team has a plan and a budget with no room for change.

We invite any feedback and comments to our 6 ways you can avoid scope creep in your next project.

Recap of Day 2 at SQL Pass Summit 2013

SQL Pass Summit 2013 day 2 sessions! Another great day at the “office”, with great sessions and great opportunity for networking. The keynote was the hot topic at the water cooler, and it was interesting to listen on how it was perceived among participants (Doug Hoogervorst gives his thoughts on the summit keynote).

Most agreed that the future release of SQL Server 2014 was promising, especially “column stored indexes” and the in-memory OLTP engine was highlighted as a great new feature and Quentin Clark emphasized that improvements were built-in to the existing engine and upgrading to SQL Server 2014 demanded no modifications to existing applications.

Watch Quentin Clark’s keynote: Microsoft’s Data Platform – The Road Ahead by Quentin Clark

The demo on Power Query was the epicenter to the greatest disagreements. Kamal Hathi demonstrated how a Skype analyst could use Power Query to connect to HDinsight in Azure (Microsoft’s Hadoop store), pull in the JSON records, and convert the big data into structured tabular data. Then, he mashed up this data with online country data via built-in search engine connected to Bing’s engine. In a few clicks he had created a “calls per country” using two different data sources…easy as that! I’m not claiming that this was not impressive, and that Power Query opens up a wide range of opportunities. However, it was interesting to learn  that most people I talked to, and that liked it, had little or no contact with the Business users. I personally belong to the more skeptic group that does not see the average CIO going to access the Hadoop store, knowing how to delimit the unstructured data, mash it up with online data and have no data validation. I question that online sources, like Wikipedia that Kamal mentions, always gets it right, and will stay consistent over time as users replicate their analysis. Also, spelling errors, difference in pages depending on what country it is accessed and many other caveats that makes “easy as that!” difficult. I do however, believe that the talented analyst can leverage value from Power Query.

My very favorite session of the day, was the “From Minutes to Milliseconds: High-Performance SSRS Tuning” by Doug Lane. He demonstrated how one can squeeze out every drop of performance improvements in a constrained environment. The biggest reason why this session was my favorite is because I learned how to improve reporting without using any capital and the second biggest reason was the confirmation that I’m already applying a lot of Doug’s suggestions in our solutions. The best advice, in my opinion, is caching large reports, i.e. you essentially pre-load the report so the user saves the time it takes to retrieve the data and process it. I do know some of our clients that are going to get a pleasant surprise next week… that’s a promise!

I’ll also promise that I won’t grab the microphone at SQL PASS Karaoke tonight… no reason to ruin the evening for everybody. I’ll stick to the beverage department – cheers!

Filter Reports in Report Manager using Keywords

Microsoft’s Report Manager has already proven its capabilities as a powerful frontend portal, for easy distribution of reports to the business. The folder based interface in a browser makes navigation intuitive and comfortable for most users (even the “technical challenged”!) and allows for great flexibility on security settings down to the individual report, folder or user/user-group. The main challenge for the business, is to decide on how to best group the reports into folders that makes sense. We often see reports grouped in Report Manager based on logical departments like: “Finance”, “Production”, “Customer Service” or more focused on activities like: “General Ledger”, “Quality Assurance”, “Audit”, “Sales” or even a mix of the two. The obvious goal is what makes the most sense to the end user!

Regardless of the naming conventions of reports and how they are categorized, most companies experience increasing difficulty in maintaining the ease of navigation as the portfolio of reports grows alongside new needs and more users pulling reports in the daily operation. We have several clients that has more than 30 reports in their Report Manager environment and add new reports on a monthly basis. It’s not difficult to imagine two different departments essentially building the same reports but with different analytical perspectives, hence introducing a degree of redundancy hidden by differentiation of titles. Sadly we also see companies simply loosing track of what some reports are used for, as changes in business or employee turnover renders them simply unnecessary or worse, unexploited. Additionally, we also often find a special category of important reports that is not intended for the daily operation, but to help mitigate crisis when they occur (e.g. external audits, tracking lost shipments, documentation for licensing purposes etc.) that gets forgotten over time.

So how do we avoid all this?

First, it still needs to be emphasized that nothing beats thoughtful titles on reports and placing them in folders that makes sense to the end-users. Additionally, Report Manager offers the opportunity to attach a small description to the reports, visible in the interface. This is a great way to offer the potential reader an understanding of what the report has to offer besides what the title suggests. Report Manager has two views, illustrated in the two pictures, Tiles View and Detailed View.

[frame src=”https://businessimpactinc.com/wp-content/uploads/2013/06/4.png” width=”640″ height=”155″ lightbox=”on” title=”Report Manager Tiles View” align=”left” ]

Notice that Tiles View offers the first few words of the description and rest will appear as a tooltip when hovering the mouse on the title.

[frame src=”https://businessimpactinc.com/wp-content/uploads/2013/06/1.png” width=”640″ height=”140″ lightbox=”on” title=”Report Manager Detailed View” align=”left” ]

Another powerful function in Report Manager is the search engine usually placed in the upper right corner and this will bring us the magic. The engine pulls not only all reports that contains the search term in the title, but also matching terms in the description. The growing use of hashtags (i.e. “#”) in Social Media applications like Twitter and Instagram has successfully taught users how to attach topic related tags onto entries. Thus, creating simple filters that seamlessly compiles shared content across users on a given topic. Same approach can be used with the description on a report.

[frame src=”https://businessimpactinc.com/wp-content/uploads/2013/06/2.png” width=”283″ height=”118″ lightbox=”on” title=”Report Manager Search Engine” align=”right” ]

Imagine a scenario with a financial controller, faced with an extensive audit, and uses various reports across all departments/categories in Report Manager, to compile the necessary documentation. Having to figure out what report returns the right information for each department can be a daunting task. If the controller adds e.g. the keyword (tag) “#audit” to the report description, for each relevant report, the search engine will easily return ALL the necessary reports for a future audits.

[frame src=”https://businessimpactinc.com/wp-content/uploads/2013/06/3.png” width=”640″ height=”219″ lightbox=”on” title=”Report Manager Audit Search Example” align=”left” ]

In conclusion, by adding keywords/tags to descriptions, an organization can easily filter relevant reports across different folders and save significant time on browsing in Report Manager. This method are especially valuable to the report users that has cross departmental responsibilities, like e.g. finance and upper management.

Three reasons why you shouldn’t even hesitate to do this?

[list type=”logobullet”]

  • Easy to implement – It does not take much technical skills to add, modify and delete descriptions.
  • Cheap – It does not add any overhead to report processing, and the only noticeable cost is the time used to add the tags.
  • Hashtags and keywords are concepts used in many popular applications like e.g. Twitter and it may not be difficult to train the user group to also utilize the search engine when browsing for reports.

[/list]

Hiding Unrelated Dimensions in a BI Tool!

A Step-by-Step Guide On How To Hide Unrelated Dimensions in a BI Tool.

Hiding Dimensions Title Page 2

The main power of OLAP viewers (Business Intelligence Tools) is the ability for employees to do Ad Hoc reporting and analysis.  If one simply chooses the measures and dimensions they want to look at, the tool will return the data they are requesting from the Cube.  This is great reporting information at the employee’s finger tips, as long as the dimensions they request are related….

If the dimensions requested are unrelated, it’s often difficult for employees analyzing the data to identify they did not find a result.  The average business user may be busy, and the lack of relationship may go undetected if related and unrelated dimensions are used in the same table.  This causes frustration, and quite frankly lack of trust in the data, from employees.

To learn how to overcome these frustrations in 5 easy steps click below:

Business Impact’s Easy Step-by-Step Guide: How To Hide Unrelated Dimensions in Your Business Intelligence Tool.

 

The Next Big Thing: TARGIT 2k13

Targit 2k13 Presentation @ ViewPoints

Business Impact hosted last month ViewPoints, our customer appreciation day in Napa, where we invited our partner TARGIT to present their new product, TARGIT 2k13 – coming out this summer (expected in June). We were all excited to finally see a live demonstration, as we had heard good things about the product and most of our clients use earlier versions of TARGIT. Needless to say, the TARGIT-boys had their work cut off with a room full of users and BI consultants working with the tool every day. Every tool has its limitation, and a few of us initially remained skeptical, as we could not help searching for the famous “catch” in an otherwise great demo. This attitude was largely brought to shame by almost every question getting answered before being asked, and the tool sustained all the natural sidetracks coming from audience requests. This demonstration was nothing less than brilliant and the the networking / wine tasting afterwards revealed that everybody seemed to be very impressed and TARGIT certainly sold themselves well. The room was filled with “we are gonna get this!”, “this is awesome”, “when can we have it?” and so on… which brings me to the earlier mentioned catch: The tool was still a couple of month away from release and people wanted it NOW. It is still very new, but we will definitely take a closer look on TARGIT 2k13 as we get closer to the release, but here are a few of the great features worth waiting for from our perspective:

Touch Client (Mobile BI)

We have been talking about mobile Business Intelligence for years now, and TARGIT are now ready to offer a credible solution that is fully integrated with the Desktop Client. The presenters tossed out a few tablets into the crowd and let them do the magic while they continued the demonstration. Easy, intuitive and was still easy to use after 20 curious souls had played around with it. I only saw pretty dashboards with drill down functionality, so can’t attest to any Ad Hoc analysis capabilities, just yet.

  Targit 2k13 Touch Client

Intelligent Wizard

One of the awesome features in TARGIT, has always been the intuitive drag and drop functionality, when building an analysis view. You click on e.g. Revenue, Customer, Month and it returns a view like below.


Targit 2k13 Decision Support

In TARGIT 2k13 you simply type “revenue per customer by month” into a search field on the frontpage and voila! Same view as above in matter of seconds which is perfect for users that needs answers NOW. It was also noted, that the result was consistent across various common misspellings and it also worked with searches suggested by the audience. This feature caught everybody’s attention.

“Fit to page” Report function

Turning an analysis view into a solid printable report can be very time consuming with the present version of TARGIT, because of the rigid layout constraints imposed by the tool. No more fiddling with column widths and other formatting to get it to fit…No more!

TARGIT 2k13 offers a new button “Fit to page” that automatically resizes the analysis to fit a page. Small, but extremely powerful function for less experienced users. What are you going to do with all that extra time?

 

Ribbon (new layout)

Never underestimate the power of a pretty design. TARGIT has put in a lot of effort into improving the layout and navigation, with new colors and functionality. E.g. a top ribbon has been added, which users can recognize from other common softwares like the Microsoft Office package. What we really like to see, is how they have kept it possible for busy users to setup shortcuts and modify layout to fit their day-to-day needs and extended this with easier Ad Hoc navigation. Finally, worth mentioning is that TARGIT 2k13 has integrated all the new design with the earlier versions – which means that you can still do it “the old fashioned way” and existing users should be able to upgrade with minimum need for additional training.

 

Final remarks

The features mentioned here won’t be listed in the top if you asked TARGIT’s marketing team. Why? This release includes massive new features like Big Data Analytics, Social Analytics, Xbone, Intelligent Sentinels and much more – that looked great in a Demo, but we would like to take a closer look at before we start endorsing it. However, we can already now say that TARGIT 2k13 is making a great tool greater and TARGIT users and newcomers should definitely consider this into their Business Intelligence Architecture. But again…estimated release is first in June.

 

We cannot wait!

 

 

How to Install Pubs Database in SQL Server 2012 in 1 query

Upon request I published how to install Pubs database for SQL Server 2012. Several have had trouble attaching it following the guide for How to install Northwind for SQL Server 2012. One can download Northwind and Pubs here: http://www.microsoft.com/en-us/download/details.aspx?id=23654 where the same script is included.

How: Open a new query in SQL Server Management Studios, copy paste the script below and execute…that should be it!

Happy training 🙂

[toggle_box]
[toggle_item title=”Install Pubs Script” active=”false”]

/* */
/* InstPubs.SQL – Creates the Pubs database */
/* */
/*
** Copyright Microsoft, Inc. 1994 – 2000
** All Rights Reserved.
*/

SET NOCOUNT ON
GO

set nocount on
set dateformat mdy

USE master

declare @dttm varchar(55)
select @dttm=convert(varchar,getdate(),113)
raiserror(‘Beginning InstPubs.SQL at %s ….’,1,1,@dttm) with nowait

GO

if exists (select * from sysdatabases where name=’pubs’)
begin
raiserror(‘Dropping existing pubs database ….’,0,1)
DROP database pubs
end
GO

CHECKPOINT
go

raiserror(‘Creating pubs database….’,0,1)
go
/*
Use default size with autogrow
*/

CREATE DATABASE pubs
GO

CHECKPOINT

GO

USE pubs

GO

if db_name() <> ‘pubs’
raiserror(‘Error in InstPubs.SQL, ”USE pubs” failed! Killing the SPID now.’
,22,127) with log

GO

execute sp_dboption ‘pubs’ ,’trunc. log on chkpt.’ ,’true’
GO

execute sp_addtype id ,’varchar(11)’ ,’NOT NULL’
execute sp_addtype tid ,’varchar(6)’ ,’NOT NULL’
execute sp_addtype empid ,’char(9)’ ,’NOT NULL’

raiserror(‘Now at the create table section ….’,0,1)

GO

CREATE TABLE authors
(
au_id id

CHECK (au_id like ‘[0-9][0-9][0-9]-[0-9][0-9]-[0-9][0-9][0-9][0-9]’)

CONSTRAINT UPKCL_auidind PRIMARY KEY CLUSTERED,

au_lname varchar(40) NOT NULL,
au_fname varchar(20) NOT NULL,

phone char(12) NOT NULL

DEFAULT (‘UNKNOWN’),

address varchar(40) NULL,
city varchar(20) NULL,
state char(2) NULL,

zip char(5) NULL

CHECK (zip like ‘[0-9][0-9][0-9][0-9][0-9]’),

contract bit NOT NULL
)

GO

CREATE TABLE publishers
(
pub_id char(4) NOT NULL

CONSTRAINT UPKCL_pubind PRIMARY KEY CLUSTERED

CHECK (pub_id in (‘1389’, ‘0736’, ‘0877’, ‘1622’, ‘1756’)
OR pub_id like ’99[0-9][0-9]’),

pub_name varchar(40) NULL,
city varchar(20) NULL,
state char(2) NULL,

country varchar(30) NULL

DEFAULT(‘USA’)
)

GO

CREATE TABLE titles
(
title_id tid

CONSTRAINT UPKCL_titleidind PRIMARY KEY CLUSTERED,

title varchar(80) NOT NULL,

type char(12) NOT NULL

DEFAULT (‘UNDECIDED’),

pub_id char(4) NULL

REFERENCES publishers(pub_id),

price money NULL,
advance money NULL,
royalty int NULL,
ytd_sales int NULL,
notes varchar(200) NULL,

pubdate datetime NOT NULL

DEFAULT (getdate())
)

GO

CREATE TABLE titleauthor
(
au_id id

REFERENCES authors(au_id),

title_id tid

REFERENCES titles(title_id),

au_ord tinyint NULL,
royaltyper int NULL,
CONSTRAINT UPKCL_taind PRIMARY KEY CLUSTERED(au_id, title_id)
)

GO

CREATE TABLE stores
(
stor_id char(4) NOT NULL

CONSTRAINT UPK_storeid PRIMARY KEY CLUSTERED,

stor_name varchar(40) NULL,
stor_address varchar(40) NULL,
city varchar(20) NULL,
state char(2) NULL,
zip char(5) NULL
)

GO

CREATE TABLE sales
(
stor_id char(4) NOT NULL

REFERENCES stores(stor_id),

ord_num varchar(20) NOT NULL,
ord_date datetime NOT NULL,
qty smallint NOT NULL,
payterms varchar(12) NOT NULL,

title_id tid

REFERENCES titles(title_id),
CONSTRAINT UPKCL_sales PRIMARY KEY CLUSTERED (stor_id, ord_num, title_id)
)

GO

CREATE TABLE roysched
(
title_id tid

REFERENCES titles(title_id),

lorange int NULL,
hirange int NULL,
royalty int NULL
)

GO

CREATE TABLE discounts
(
discounttype varchar(40) NOT NULL,

stor_id char(4) NULL

REFERENCES stores(stor_id),

lowqty smallint NULL,
highqty smallint NULL,
discount dec(4,2) NOT NULL
)

GO

CREATE TABLE jobs
(
job_id smallint IDENTITY(1,1)

PRIMARY KEY CLUSTERED,

job_desc varchar(50) NOT NULL

DEFAULT ‘New Position – title not formalized yet’,

min_lvl tinyint NOT NULL

CHECK (min_lvl >= 10),

max_lvl tinyint NOT NULL

CHECK (max_lvl <= 250)
)

GO

CREATE TABLE pub_info
(
pub_id char(4) NOT NULL

REFERENCES publishers(pub_id)

CONSTRAINT UPKCL_pubinfo PRIMARY KEY CLUSTERED,

logo image NULL,
pr_info text NULL
)

GO

CREATE TABLE employee
(
emp_id empid

CONSTRAINT PK_emp_id PRIMARY KEY NONCLUSTERED

CONSTRAINT CK_emp_id CHECK (emp_id LIKE
‘[A-Z][A-Z][A-Z][1-9][0-9][0-9][0-9][0-9][FM]’ or
emp_id LIKE ‘[A-Z]-[A-Z][1-9][0-9][0-9][0-9][0-9][FM]’),

fname varchar(20) NOT NULL,
minit char(1) NULL,
lname varchar(30) NOT NULL,

job_id smallint NOT NULL

DEFAULT 1

REFERENCES jobs(job_id),

job_lvl tinyint

DEFAULT 10,

pub_id char(4) NOT NULL

DEFAULT (‘9952’)

REFERENCES publishers(pub_id),

hire_date datetime NOT NULL

DEFAULT (getdate())
)

GO

raiserror(‘Now at the create trigger section …’,0,1)

GO

CREATE TRIGGER employee_insupd
ON employee
FOR insert, UPDATE
AS
–Get the range of level for this job type from the jobs table.
declare @min_lvl tinyint,
@max_lvl tinyint,
@emp_lvl tinyint,
@job_id smallint
select @min_lvl = min_lvl,
@max_lvl = max_lvl,
@emp_lvl = i.job_lvl,
@job_id = i.job_id
from employee e, jobs j, inserted i
where e.emp_id = i.emp_id AND i.job_id = j.job_id
IF (@job_id = 1) and (@emp_lvl <> 10)
begin
raiserror (‘Job id 1 expects the default level of 10.’,16,1)
ROLLBACK TRANSACTION
end
ELSE
IF NOT (@emp_lvl BETWEEN @min_lvl AND @max_lvl)
begin
raiserror (‘The level for job_id:%d should be between %d and %d.’,
16, 1, @job_id, @min_lvl, @max_lvl)
ROLLBACK TRANSACTION
end

GO

raiserror(‘Now at the inserts to authors ….’,0,1)

GO

insert authors
values(‘409-56-7008’, ‘Bennet’, ‘Abraham’, ‘415 658-9932’,
‘6223 Bateman St.’, ‘Berkeley’, ‘CA’, ‘94705’, 1)
insert authors
values(‘213-46-8915’, ‘Green’, ‘Marjorie’, ‘415 986-7020’,
‘309 63rd St. #411’, ‘Oakland’, ‘CA’, ‘94618’, 1)
insert authors
values(‘238-95-7766’, ‘Carson’, ‘Cheryl’, ‘415 548-7723’,
‘589 Darwin Ln.’, ‘Berkeley’, ‘CA’, ‘94705’, 1)
insert authors
values(‘998-72-3567’, ‘Ringer’, ‘Albert’, ‘801 826-0752′,
’67 Seventh Av.’, ‘Salt Lake City’, ‘UT’, ‘84152’, 1)
insert authors
values(‘899-46-2035’, ‘Ringer’, ‘Anne’, ‘801 826-0752′,
’67 Seventh Av.’, ‘Salt Lake City’, ‘UT’, ‘84152’, 1)
insert authors
values(‘722-51-5454’, ‘DeFrance’, ‘Michel’, ‘219 547-9982’,
‘3 Balding Pl.’, ‘Gary’, ‘IN’, ‘46403’, 1)
insert authors
values(‘807-91-6654’, ‘Panteley’, ‘Sylvia’, ‘301 946-8853’,
‘1956 Arlington Pl.’, ‘Rockville’, ‘MD’, ‘20853’, 1)
insert authors
values(‘893-72-1158’, ‘McBadden’, ‘Heather’,
‘707 448-4982’, ‘301 Putnam’, ‘Vacaville’, ‘CA’, ‘95688’, 0)
insert authors
values(‘724-08-9931’, ‘Stringer’, ‘Dirk’, ‘415 843-2991’,
‘5420 Telegraph Av.’, ‘Oakland’, ‘CA’, ‘94609’, 0)
insert authors
values(‘274-80-9391’, ‘Straight’, ‘Dean’, ‘415 834-2919’,
‘5420 College Av.’, ‘Oakland’, ‘CA’, ‘94609’, 1)
insert authors
values(‘756-30-7391’, ‘Karsen’, ‘Livia’, ‘415 534-9219’,
‘5720 McAuley St.’, ‘Oakland’, ‘CA’, ‘94609’, 1)
insert authors
values(‘724-80-9391’, ‘MacFeather’, ‘Stearns’, ‘415 354-7128′,
’44 Upland Hts.’, ‘Oakland’, ‘CA’, ‘94612’, 1)
insert authors
values(‘427-17-2319’, ‘Dull’, ‘Ann’, ‘415 836-7128’,
‘3410 Blonde St.’, ‘Palo Alto’, ‘CA’, ‘94301’, 1)
insert authors
values(‘672-71-3249’, ‘Yokomoto’, ‘Akiko’, ‘415 935-4228’,
‘3 Silver Ct.’, ‘Walnut Creek’, ‘CA’, ‘94595’, 1)
insert authors
values(‘267-41-2394’, ‘O”Leary’, ‘Michael’, ‘408 286-2428′,
’22 Cleveland Av. #14’, ‘San Jose’, ‘CA’, ‘95128’, 1)
insert authors
values(‘472-27-2349’, ‘Gringlesby’, ‘Burt’, ‘707 938-6445’,
‘PO Box 792’, ‘Covelo’, ‘CA’, ‘95428’, 3)
insert authors
values(‘527-72-3246’, ‘Greene’, ‘Morningstar’, ‘615 297-2723′,
’22 Graybar House Rd.’, ‘Nashville’, ‘TN’, ‘37215’, 0)
insert authors
values(‘172-32-1176’, ‘White’, ‘Johnson’, ‘408 496-7223’,
‘10932 Bigge Rd.’, ‘Menlo Park’, ‘CA’, ‘94025’, 1)
insert authors
values(‘712-45-1867’, ‘del Castillo’, ‘Innes’, ‘615 996-8275’,
‘2286 Cram Pl. #86’, ‘Ann Arbor’, ‘MI’, ‘48105’, 1)
insert authors
values(‘846-92-7186’, ‘Hunter’, ‘Sheryl’, ‘415 836-7128’,
‘3410 Blonde St.’, ‘Palo Alto’, ‘CA’, ‘94301’, 1)
insert authors
values(‘486-29-1786’, ‘Locksley’, ‘Charlene’, ‘415 585-4620′,
’18 Broadway Av.’, ‘San Francisco’, ‘CA’, ‘94130’, 1)
insert authors
values(‘648-92-1872’, ‘Blotchet-Halls’, ‘Reginald’, ‘503 745-6402′,
’55 Hillsdale Bl.’, ‘Corvallis’, ‘OR’, ‘97330’, 1)
insert authors
values(‘341-22-1782’, ‘Smith’, ‘Meander’, ‘913 843-0462′,
’10 Mississippi Dr.’, ‘Lawrence’, ‘KS’, ‘66044’, 0)

GO

raiserror(‘Now at the inserts to publishers ….’,0,1)

GO

insert publishers values(‘0736’, ‘New Moon Books’, ‘Boston’, ‘MA’, ‘USA’)
insert publishers values(‘0877’, ‘Binnet & Hardley’, ‘Washington’, ‘DC’, ‘USA’)
insert publishers values(‘1389’, ‘Algodata Infosystems’, ‘Berkeley’, ‘CA’, ‘USA’)
insert publishers values(‘9952’, ‘Scootney Books’, ‘New York’, ‘NY’, ‘USA’)
insert publishers values(‘1622’, ‘Five Lakes Publishing’, ‘Chicago’, ‘IL’, ‘USA’)
insert publishers values(‘1756’, ‘Ramona Publishers’, ‘Dallas’, ‘TX’, ‘USA’)
insert publishers values(‘9901’, ‘GGG&G’, ‘Mnchen’, NULL, ‘Germany’)
insert publishers values(‘9999’, ‘Lucerne Publishing’, ‘Paris’, NULL, ‘France’)

GO

raiserror(‘Now at the inserts to pub_info ….’,0,1)

GO

insert pub_info values(‘0736’, 0x474946383961D3001F00B30F00000000800000008000808000000080800080008080808080C0C0C0FF000000FF00FFFF000000FFFF00FF00FFFFFFFFFF21F9040100000F002C00000000D3001F004004FFF0C949ABBD38EBCDBBFF60288E245001686792236ABAB03BC5B055B3F843D3B99DE2AB532A36FB15253B19E5A6231A934CA18CB75C1191D69BF62AAD467F5CF036D8243791369F516ADEF9304AF8F30A3563D7E54CFC04BF24377B5D697E6451333D8821757F898D8E8F1F76657877907259755E5493962081798D9F8A846D9B4A929385A7A5458CA0777362ACAF585E6C6A84AD429555BAA9A471A89D8E8BA2C3C7C82DC9C8AECBCECF1EC2D09143A66E80D3D9BC2C41D76AD28FB2CD509ADAA9AAC62594A3DF81C65FE0BDB5B0CDF4E276DEF6DD78EF6B86FA6C82C5A2648A54AB6AAAE4C1027864DE392E3AF4582BF582DFC07D9244ADA2480BD4C6767BFF32AE0BF3EF603B3907490A4427CE21A7330A6D0584B810664D7F383FA25932488FB96D0F37BDF9491448D1A348937A52CAB4A9D3784EF5E58B4A5545D54BC568FABC9A68DD526ED0A6B8AA17331BD91E5AD9D1D390CED23D88F54A3ACB0A955ADDAD9A50B50D87296E3EB9C76A7CDAABC86B2460040DF34D3995515AB9FF125F1AFA0DAB20A0972382CCB9F9E5AEBC368B21EEDB66EDA15F1347BE2DFDEBB44A7B7C6889240D9473EB73322F4E8D8DBBE14D960B6519BCE5724BB95789350E97EA4BF3718CDD64068D751A261D8B1539D6DCDE3C37F68E1FB58E5DCED8A44477537049852EFD253CEE38C973B7E9D97A488C2979FB936FBAFF2CF5CB79E35830400C31860F4A9BE925D4439F81B6A073BEF1575F593C01A25B26127255D45D4A45B65B851A36C56154678568A20E1100003B,
‘This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.

This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.’)

insert pub_info values(‘0877’, 0x4749463839618B002F00B30F00000000800000008000808000000080800080008080808080C0C0C0FF000000FF00FFFF000000FFFF00FF00FFFFFFFFFF21F9040100000F002C000000008B002F004004FFF0C949ABBD38EBCDBBFFA0048464089CE384A62BD596309CC6F4F58A287EBA79ED73B3D26A482C1A8FC8A47249FCCD76BC1F3058D94135579C9345053D835768560CFE6A555D343A1B6D3FC6DC2A377E66DBA5F8DBEBF6EEE1FF2A805B463A47828269871F7A3D7C7C8A3E899093947F666A756567996E6C519E167692646E7D9C98A42295ABAC24A092AD364C737EB15EB61B8E8DB58FB81DB0BE8C6470A0BE58C618BAC365C5C836CEA1BCBBC4C0D0AAD6D14C85CDD86FDDDFAB5F43A580DCB519A25B9BAE989BC3EEA9A7EBD9BF54619A7DF8BBA87475EDA770D6C58B968C59A27402FB99E2378FC7187010D5558948B15CC58B4E20CE9A762E62B558CAB86839FC088D24AB90854662BCD60D653E832BBD7924F49226469327FDEC91C6AD2538972E6FFEE429720D4E63472901251A33A9D28DB47A5A731A7325D56D50B36ADDAA2463D5AF1EAE82F5F84FAA946656AA21AC31D0C4BF85CBA87912D6D194D4B535C5DDDBA93221CB226D022E9437D89C594305FD321C0CB7DFA5C58223036E088F3139B9032563DD0BE66D2ACD8B2BCB9283CEDEE3C6A53EE39BA7579A62C1294917DC473035E0B9E3183F9A3BB6F7ABDE608B018800003B,
‘This is sample text data for Binnet & Hardley, publisher 0877 in the pubs database. Binnet & Hardley is located in Washington, D.C.

This is sample text data for Binnet & Hardley, publisher 0877 in the pubs database. Binnet & Hardley is located in Washington, D.C.

This is sample text data for Binnet & Hardley, publisher 0877 in the pubs database. Binnet & Hardley is located in Washington, D.C.

This is sample text data for Binnet & Hardley, publisher 0877 in the pubs database. Binnet & Hardley is located in Washington, D.C.

This is sample text data for Binnet & Hardley, publisher 0877 in the pubs database. Binnet & Hardley is located in Washington, D.C.’)

insert pub_info values(‘1389’, 0x474946383961C2001D00B30F00000000800000008000808000000080800080008080808080C0C0C0FF000000FF00FFFF000000FFFF00FF00FFFFFFFFFF21F9040100000F002C00000000C2001D004004FFF0C949ABBD38EBCDBBFF60288E1C609E2840AE2C969E6D2CCFB339D90F2CE1F8AEE6BC9FEF26EC01413AA3F2D76BAA96C7A154EA7CC29C449AC7A8ED7A2FDC2FED25149B29E4D479FD55A7CBD931DC35CFA4916171BEFDAABC51546541684C8285847151537F898A588D89806045947491757B6C9A9B9C9D9E9FA0A1A2A3A4A5A6A7A8A95A6A3E64169923B0901A775B7566B25D7F8C888A5150BE7B8F93847D8DC3C07983BEBDC1878BCFAF6F44BBD0AD71C9CBD653BFD5CEC7D1C3DFDB8197D8959CB9AAB8B7EBEEEFF0BA92F1B6B5F4A0F6F776D3FA9EBCFD748C01DCB4AB5DBF7C03CF1454070F61423D491C326BA18E211081250C7AB12867619825F37F2ECE1168AC242B6A274556D121D28FA46C11E78564C5B295308F21BBF5CAD6CCE52C7018813932C4ED5C517346B7C1C2683368349D49A19D0439D31538A452A916135A0B19A59AAB9E6A835A0EABD00E5CD11D1D478C1C59714053AA4C4955AB4B9956879AB497F62E1CBA2373DA25B752239F8787119390AB5806C74E1100003B,
‘This is sample text data for Algodata Infosystems, publisher 1389 in the pubs database. Algodata Infosystems is located in Berkeley, California.

This is sample text data for Algodata Infosystems, publisher 1389 in the pubs database. Algodata Infosystems is located in Berkeley, California.

This is sample text data for Algodata Infosystems, publisher 1389 in the pubs database. Algodata Infosystems is located in Berkeley, California.

This is sample text data for Algodata Infosystems, publisher 1389 in the pubs database. Algodata Infosystems is located in Berkeley, California.

This is sample text data for Algodata Infosystems, publisher 1389 in the pubs database. Algodata Infosystems is located in Berkeley, California.

This is sample text data for Algodata Infosystems, publisher 1389 in the pubs database. Algodata Infosystems is located in Berkeley, California.

This is sample text data for Algodata Infosystems, publisher 1389 in the pubs database. Algodata Infosystems is located in Berkeley, California.

This is sample text data for Algodata Infosystems, publisher 1389 in the pubs database. Algodata Infosystems is located in Berkeley, California.

This is sample text data for Algodata Infosystems, publisher 1389 in the pubs database. Algodata Infosystems is located in Berkeley, California.

This is sample text data for Algodata Infosystems, publisher 1389 in the pubs database. Algodata Infosystems is located in Berkeley, California.’)

insert pub_info values(‘1622’, 0x474946383961F5003400B30F00000000800000008000808000000080800080008080808080C0C0C0FF000000FF00FFFF000000FFFF00FF00FFFFFFFFFF21F9040100000F002C00000000F50034004004FFF0C949ABBD38EBCDBBFF60288E64D90166AA016CEBBEB02ACF746D67E82DC2ACEEFFC0A02997B31027C521EF25698D8E42230E049D3E8AD8537385BC4179DB6B574C26637BE58BF38A1EB393DF2CE55CA52731F77918BE9FAFCD6180817F697F5F6E6C7A836D62876A817A79898A7E31524D708E7299159C9456929F9044777C6575A563A68E827D9D4C8D334BB3B051B6B7B83A8490B91EB4B3BDC1C251A1C24BC3C8C9C8C5C4BFCCCAD0D135ACC36B2E3BBCB655AD1CDB8F6921DEB8D48AA9ADA46046D7E0DC829B9D98E9988878D9AAE5AEF875BC6DEFF7E7A35C9943F18CCA3175C0A4295C48625F3B8610234A0C17D159C289189515CC7531A3C7891BFF9B59FA4812634820F24AAA94882EA50D8BBB3E8813598B8A3D7C0D6F12CB8710E5BA7536D9ED3C458F8B509CF17CE94CEA658F254D944889528306E83C245089629DDA4F8BD65885049ACBB7ADAB2A5364AFDAF344902752409A6085FA39105EBB3C2DAB2E52FA8611B7ACFA060956CB1370598176DB3E74FB956CCCA77207BB6B8CAAAADEA3FFBE01A48CD871D65569C37E25A458C5C9572E57AADE59F7F40A98B456CB36560F730967B3737B74ADBBB7EFDABF830BE70B11F6C8E1C82F31345E33B9F3A5C698FB7D4E9D779083D4B313D7985ABB77E0C9B07F1F0F3EFA71F2E8ED56EB98BEBD7559306FC72C6995EA7499F3B5DDA403FF17538AB6FD20C9FF7D463D531681971888E0104E45069D7C742D58DB7B29B45454811B381420635135B5D838D6E487612F876D98D984B73D2820877DFD871523F5E161D97DD7FCB4C82E31BEC8176856D9D8487D95E1E5D711401AE2448EF11074E47E9D69359382E8A8871391880C28E5861636399950FEFCA55E315D8279255C2C6AA89899B68588961C5B82C366693359F1CA89ACACB959971D76F6E6607B6E410E9D57B1A9196A52BDD56636CC08BA519C5E1EDA8743688906DA9D53F2E367999656A96292E2781397A6264E62A04E25FE49A59354696958409B11F527639DEAC84E7795553A9AACA85C68E8977D2A7919A5A7F83329A46F0D79698BF60D98688CCC118A6C3F8F38E6D89C8C12F635E49145F6132D69DCCE684725FC0546C3B40875D79E70A5867A8274E69E8BAEAC1FEEC02E92EE3AA7ADA015365BEFBE83F2EB6F351100003B,
‘This is sample text data for Five Lakes Publishing, publisher 1622 in the pubs database. Five Lakes Publishing is located in Chicago, Illinois.

This is sample text data for Five Lakes Publishing, publisher 1622 in the pubs database. Five Lakes Publishing is located in Chicago, Illinois.

This is sample text data for Five Lakes Publishing, publisher 1622 in the pubs database. Five Lakes Publishing is located in Chicago, Illinois.

This is sample text data for Five Lakes Publishing, publisher 1622 in the pubs database. Five Lakes Publishing is located in Chicago, Illinois.

This is sample text data for Five Lakes Publishing, publisher 1622 in the pubs database. Five Lakes Publishing is located in Chicago, Illinois.

This is sample text data for Five Lakes Publishing, publisher 1622 in the pubs database. Five Lakes Publishing is located in Chicago, Illinois.

This is sample text data for Five Lakes Publishing, publisher 1622 in the pubs database. Five Lakes Publishing is located in Chicago, Illinois.

This is sample text data for Five Lakes Publishing, publisher 1622 in the pubs database. Five Lakes Publishing is located in Chicago, Illinois.

This is sample text data for Five Lakes Publishing, publisher 1622 in the pubs database. Five Lakes Publishing is located in Chicago, Illinois.

This is sample text data for Five Lakes Publishing, publisher 1622 in the pubs database. Five Lakes Publishing is located in Chicago, Illinois.

This is sample text data for Five Lakes Publishing, publisher 1622 in the pubs database. Five Lakes Publishing is located in Chicago, Illinois.

This is sample text data for Five Lakes Publishing, publisher 1622 in the pubs database. Five Lakes Publishing is located in Chicago, Illinois.

This is sample text data for Five Lakes Publishing, publisher 1622 in the pubs database. Five Lakes Publishing is located in Chicago, Illinois.

This is sample text data for Five Lakes Publishing, publisher 1622 in the pubs database. Five Lakes Publishing is located in Chicago, Illinois.

This is sample text data for Five Lakes Publishing, publisher 1622 in the pubs database. Five Lakes Publishing is located in Chicago, Illinois.

This is sample text data for Five Lakes Publishing, publisher 1622 in the pubs database. Five Lakes Publishing is located in Chicago, Illinois.

This is sample text data for Five Lakes Publishing, publisher 1622 in the pubs database. Five Lakes Publishing is located in Chicago, Illinois.

This is sample text data for Five Lakes Publishing, publisher 1622 in the pubs database. Five Lakes Publishing is located in Chicago, Illinois.

This is sample text data for Five Lakes Publishing, publisher 1622 in the pubs database. Five Lakes Publishing is located in Chicago, Illinois.

This is sample text data for Five Lakes Publishing, publisher 1622 in the pubs database. Five Lakes Publishing is located in Chicago, Illinois.

This is sample text data for Five Lakes Publishing, publisher 1622 in the pubs database. Five Lakes Publishing is located in Chicago, Illinois.

This is sample text data for Five Lakes Publishing, publisher 1622 in the pubs database. Five Lakes Publishing is located in Chicago, Illinois.

This is sample text data for Five Lakes Publishing, publisher 1622 in the pubs database. Five Lakes Publishing is located in Chicago, Illinois.

This is sample text data for Five Lakes Publishing, publisher 1622 in the pubs database. Five Lakes Publishing is located in Chicago, Illinois.

This is sample text data for Five Lakes Publishing, publisher 1622 in the pubs database. Five Lakes Publishing is located in Chicago, Illinois.

This is sample text data for Five Lakes Publishing, publisher 1622 in the pubs database. Five Lakes Publishing is located in Chicago, Illinois.

This is sample text data for Five Lakes Publishing, publisher 1622 in the pubs database. Five Lakes Publishing is located in Chicago, Illinois.

This is sample text data for Five Lakes Publishing, publisher 1622 in the pubs database. Five Lakes Publishing is located in Chicago, Illinois.

This is sample text data for Five Lakes Publishing, publisher 1622 in the pubs database. Five Lakes Publishing is located in Chicago, Illinois.

This is sample text data for Five Lakes Publishing, publisher 1622 in the pubs database. Five Lakes Publishing is located in Chicago, Illinois.

This is sample text data for Five Lakes Publishing, publisher 1622 in the pubs database. Five Lakes Publishing is located in Chicago, Illinois.

This is sample text data for Five Lakes Publishing, publisher 1622 in the pubs database. Five Lakes Publishing is located in Chicago, Illinois.

This is sample text data for Five Lakes Publishing, publisher 1622 in the pubs database. Five Lakes Publishing is located in Chicago, Illinois.

This is sample text data for Five Lakes Publishing, publisher 1622 in the pubs database. Five Lakes Publishing is located in Chicago, Illinois.

This is sample text data for Five Lakes Publishing, publisher 1622 in the pubs database. Five Lakes Publishing is located in Chicago, Illinois.

This is sample text data for Five Lakes Publishing, publisher 1622 in the pubs database. Five Lakes Publishing is located in Chicago, Illinois.

This is sample text data for Five Lakes Publishing, publisher 1622 in the pubs database. Five Lakes Publishing is located in Chicago, Illinois.

This is sample text data for Five Lakes Publishing, publisher 1622 in the pubs database. Five Lakes Publishing is located in Chicago, Illinois.

This is sample text data for Five Lakes Publishing, publisher 1622 in the pubs database. Five Lakes Publishing is located in Chicago, Illinois.

This is sample text data for Five Lakes Publishing, publisher 1622 in the pubs database. Five Lakes Publishing is located in Chicago, Illinois.

This is sample text data for Five Lakes Publishing, publisher 1622 in the pubs database. Five Lakes Publishing is located in Chicago, Illinois.

This is sample text data for Five Lakes Publishing, publisher 1622 in the pubs database. Five Lakes Publishing is located in Chicago, Illinois.

This is sample text data for Five Lakes Publishing, publisher 1622 in the pubs database. Five Lakes Publishing is located in Chicago, Illinois.

This is sample text data for Five Lakes Publishing, publisher 1622 in the pubs database. Five Lakes Publishing is located in Chicago, Illinois.

This is sample text data for Five Lakes Publishing, publisher 1622 in the pubs database. Five Lakes Publishing is located in Chicago, Illinois.

This is sample text data for Five Lakes Publishing, publisher 1622 in the pubs database. Five Lakes Publishing is located in Chicago, Illinois.

This is sample text data for Five Lakes Publishing, publisher 1622 in the pubs database. Five Lakes Publishing is located in Chicago, Illinois.

This is sample text data for Five Lakes Publishing, publisher 1622 in the pubs database. Five Lakes Publishing is located in Chicago, Illinois.

This is sample text data for Five Lakes Publishing, publisher 1622 in the pubs database. Five Lakes Publishing is located in Chicago, Illinois.

This is sample text data for Five Lakes Publishing, publisher 1622 in the pubs database. Five Lakes Publishing is located in Chicago, Illinois.

This is sample text data for Five Lakes Publishing, publisher 1622 in the pubs database. Five Lakes Publishing is located in Chicago, Illinois.

This is sample text data for Five Lakes Publishing, publisher 1622 in the pubs database. Five Lakes Publishing is located in Chicago, Illinois.

This is sample text data for Five Lakes Publishing, publisher 1622 in the pubs database. Five Lakes Publishing is located in Chicago, Illinois.

This is sample text data for Five Lakes Publishing, publisher 1622 in the pubs database. Five Lakes Publishing is located in Chicago, Illinois.

This is sample text data for Five Lakes Publishing, publisher 1622 in the pubs database. Five Lakes Publishing is located in Chicago, Illinois.

This is sample text data for Five Lakes Publishing, publisher 1622 in the pubs database. Five Lakes Publishing is located in Chicago, Illinois.

This is sample text data for Five Lakes Publishing, publisher 1622 in the pubs database. Five Lakes Publishing is located in Chicago, Illinois.

This is sample text data for Five Lakes Publishing, publisher 1622 in the pubs database. Five Lakes Publishing is located in Chicago, Illinois.

This is sample text data for Five Lakes Publishing, publisher 1622 in the pubs database. Five Lakes Publishing is located in Chicago, Illinois.

This is sample text data for Five Lakes Publishing, publisher 1622 in the pubs database. Five Lakes Publishing is located in Chicago, Illinois.

This is sample text data for Five Lakes Publishing, publisher 1622 in the pubs database. Five Lakes Publishing is located in Chicago, Illinois.

This is sample text data for Five Lakes Publishing, publisher 1622 in the pubs database. Five Lakes Publishing is located in Chicago, Illinois.

This is sample text data for Five Lakes Publishing, publisher 1622 in the pubs database. Five Lakes Publishing is located in Chicago, Illinois.

This is sample text data for Five Lakes Publishing, publisher 1622 in the pubs database. Five Lakes Publishing is located in Chicago, Illinois.

This is sample text data for Five Lakes Publishing, publisher 1622 in the pubs database. Five Lakes Publishing is located in Chicago, Illinois.

This is sample text data for Five Lakes Publishing, publisher 1622 in the pubs database. Five Lakes Publishing is located in Chicago, Illinois.

This is sample text data for Five Lakes Publishing, publisher 1622 in the pubs database. Five Lakes Publishing is located in Chicago, Illinois.

This is sample text data for Five Lakes Publishing, publisher 1622 in the pubs database. Five Lakes Publishing is located in Chicago, Illinois.

This is sample text data for Five Lakes Publishing, publisher 1622 in the pubs database. Five Lakes Publishing is located in Chicago, Illinois.

This is sample text data for Five Lakes Publishing, publisher 1622 in the pubs database. Five Lakes Publishing is located in Chicago, Illinois.

This is sample text data for Five Lakes Publishing, publisher 1622 in the pubs database. Five Lakes Publishing is located in Chicago, Illinois.

This is sample text data for Five Lakes Publishing, publisher 1622 in the pubs database. Five Lakes Publishing is located in Chicago, Illinois.

This is sample text data for Five Lakes Publishing, publisher 1622 in the pubs database. Five Lakes Publishing is located in Chicago, Illinois.

This is sample text data for Five Lakes Publishing, publisher 1622 in the pubs database. Five Lakes Publishing is located in Chicago, Illinois.

This is sample text data for Five Lakes Publishing, publisher 1622 in the pubs database. Five Lakes Publishing is located in Chicago, Illinois.

This is sample text data for Five Lakes Publishing, publisher 1622 in the pubs database. Five Lakes Publishing is located in Chicago, Illinois.

This is sample text data for Five Lakes Publishing, publisher 1622 in the pubs database. Five Lakes Publishing is located in Chicago, Illinois.

This is sample text data for Five Lakes Publishing, publisher 1622 in the pubs database. Five Lakes Publishing is located in Chicago, Illinois.

This is sample text data for Five Lakes Publishing, publisher 1622 in the pubs database. Five Lakes Publishing is located in Chicago, Illinois.

This is sample text data for Five Lakes Publishing, publisher 1622 in the pubs database. Five Lakes Publishing is located in Chicago, Illinois.

This is sample text data for Five Lakes Publishing, publisher 1622 in the pubs database. Five Lakes Publishing is located in Chicago, Illinois.

This is sample text data for Five Lakes Publishing, publisher 1622 in the pubs database. Five Lakes Publishing is located in Chicago, Illinois.

This is sample text data for Five Lakes Publishing, publisher 1622 in the pubs database. Five Lakes Publishing is located in Chicago, Illinois.

This is sample text data for Five Lakes Publishing, publisher 1622 in the pubs database. Five Lakes Publishing is located in Chicago, Illinois.

This is sample text data for Five Lakes Publishing, publisher 1622 in the pubs database. Five Lakes Publishing is located in Chicago, Illinois.

This is sample text data for Five Lakes Publishing, publisher 1622 in the pubs database. Five Lakes Publishing is located in Chicago, Illinois.

This is sample text data for Five Lakes Publishing, publisher 1622 in the pubs database. Five Lakes Publishing is located in Chicago, Illinois.

This is sample text data for Five Lakes Publishing, publisher 1622 in the pubs database. Five Lakes Publishing is located in Chicago, Illinois.

This is sample text data for Five Lakes Publishing, publisher 1622 in the pubs database. Five Lakes Publishing is located in Chicago, Illinois.

This is sample text data for Five Lakes Publishing, publisher 1622 in the pubs database. Five Lakes Publishing is located in Chicago, Illinois.

This is sample text data for Five Lakes Publishing, publisher 1622 in the pubs database. Five Lakes Publishing is located in Chicago, Illinois.

This is sample text data for Five Lakes Publishing, publisher 1622 in the pubs database. Five Lakes Publishing is located in Chicago, Illinois.

This is sample text data for Five Lakes Publishing, publisher 1622 in the pubs database. Five Lakes Publishing is located in Chicago, Illinois.

This is sample text data for Five Lakes Publishing, publisher 1622 in the pubs database. Five Lakes Publishing is located in Chicago, Illinois.

This is sample text data for Five Lakes Publishing, publisher 1622 in the pubs database. Five Lakes Publishing is located in Chicago, Illinois.

This is sample text data for Five Lakes Publishing, publisher 1622 in the pubs database. Five Lakes Publishing is located in Chicago, Illinois.

This is sample text data for Five Lakes Publishing, publisher 1622 in the pubs database. Five Lakes Publishing is located in Chicago, Illinois.

This is sample text data for Five Lakes Publishing, publisher 1622 in the pubs database. Five Lakes Publishing is located in Chicago, Illinois.

This is sample text data for Five Lakes Publishing, publisher 1622 in the pubs database. Five Lakes Publishing is located in Chicago, Illinois.

This is sample text data for Five Lakes Publishing, publisher 1622 in the pubs database. Five Lakes Publishing is located in Chicago, Illinois.

This is sample text data for Five Lakes Publishing, publisher 1622 in the pubs database. Five Lakes Publishing is located in Chicago, Illinois.

This is sample text data for Five Lakes Publishing, publisher 1622 in the pubs database. Five Lakes Publishing is located in Chicago, Illinois.

This is sample text data for Five Lakes Publishing, publisher 1622 in the pubs database. Five Lakes Publishing is located in Chicago, Illinois.

This is sample text data for Five Lakes Publishing, publisher 1622 in the pubs database. Five Lakes Publishing is located in Chicago, Illinois.

This is sample text data for Five Lakes Publishing, publisher 1622 in the pubs database. Five Lakes Publishing is located in Chicago, Illinois.

This is sample text data for Five Lakes Publishing, publisher 1622 in the pubs database. Five Lakes Publishing is located in Chicago, Illinois.

This is sample text data for Five Lakes Publishing, publisher 1622 in the pubs database. Five Lakes Publishing is located in Chicago, Illinois.

This is sample text data for Five Lakes Publishing, publisher 1622 in the pubs database. Five Lakes Publishing is located in Chicago, Illinois.

This is sample text data for Five Lakes Publishing, publisher 1622 in the pubs database. Five Lakes Publishing is located in Chicago, Illinois.

This is sample text data for Five Lakes Publishing, publisher 1622 in the pubs database. Five Lakes Publishing is located in Chicago, Illinois.

This is sample text data for Five Lakes Publishing, publisher 1622 in the pubs database. Five Lakes Publishing is located in Chicago, Illinois.

This is sample text data for Five Lakes Publishing, publisher 1622 in the pubs database. Five Lakes Publishing is located in Chicago, Illinois.

This is sample text data for Five Lakes Publishing, publisher 1622 in the pubs database. Five Lakes Publishing is located in Chicago, Illinois.

This is sample text data for Five Lakes Publishing, publisher 1622 in the pubs database. Five Lakes Publishing is located in Chicago, Illinois.

This is sample text data for Five Lakes Publishing, publisher 1622 in the pubs database. Five Lakes Publishing is located in Chicago, Illinois.

This is sample text data for Five Lakes Publishing, publisher 1622 in the pubs database. Five Lakes Publishing is located in Chicago, Illinois.

This is sample text data for Five Lakes Publishing, publisher 1622 in the pubs database. Five Lakes Publishing is located in Chicago, Illinois.

This is sample text data for Five Lakes Publishing, publisher 1622 in the pubs database. Five Lakes Publishing is located in Chicago, Illinois.

This is sample text data for Five Lakes Publishing, publisher 1622 in the pubs database. Five Lakes Publishing is located in Chicago, Illinois.

This is sample text data for Five Lakes Publishing, publisher 1622 in the pubs database. Five Lakes Publishing is located in Chicago, Illinois.

This is sample text data for Five Lakes Publishing, publisher 1622 in the pubs database. Five Lakes Publishing is located in Chicago, Illinois.

This is sample text data for Five Lakes Publishing, publisher 1622 in the pubs database. Five Lakes Publishing is located in Chicago, Illinois.

This is sample text data for Five Lakes Publishing, publisher 1622 in the pubs database. Five Lakes Publishing is located in Chicago, Illinois.

This is sample text data for Five Lakes Publishing, publisher 1622 in the pubs database. Five Lakes Publishing is located in Chicago, Illinois.

This is sample text data for Five Lakes Publishing, publisher 1622 in the pubs database. Five Lakes Publishing is located in Chicago, Illinois.

This is sample text data for Five Lakes Publishing, publisher 1622 in the pubs database. Five Lakes Publishing is located in Chicago, Illinois.’)

insert pub_info values(‘1756’, 0x474946383961E3002500B30F00000000800000008000808000000080800080008080808080C0C0C0FF000000FF00FFFF000000FFFF00FF00FFFFFFFFFF21F9040100000F002C00000000E30025004004FFF0C949ABBD38EBCDBBFF60288E240858E705A4D2EA4E6E0CC7324DD1EB9CDBBAFCE1AC878DE7ABBD84476452C963369F2F288E933A595B404DB27834E67A5FEC37ACEC517D4EB24E5C8D069966361A5E8ED3C3DCA5AA54B9B2AE2D423082817F848286898386858754887B8A8D939094947E918B7D8780959E9D817C18986FA2A6A75A7B22A59B378E1DACAEB18F1940B6A8B8A853727AB5BD4E76676A37BFB9AF2A564D6BC0776E635BCE6DCFD2C3C873716879D4746C6053DA76E0DAB3A133D6D5B290929F9CEAEDEB6FA0C435EF9E97F59896EC28EEFA9DFF69A21C1BB4CA1E3E63084DB42B970FD6407D05C9E59298B0A2C58B18337AA0E88DA3468DC3FFD0692187A7982F5F2271B152162DE54795CEB0F0DAF8EBDA2A932F1FF203B38C484B6ED07674194ACD639679424B4EDB36279B4D3852FE1095266743955138C5209ADA6D5CB26DCDFC644DD351EACF804BCD32421A562DB6965F25AADD11B056BD7BA436C903E82A1D4A3D024769BAE777B0BB7887F51A0E022E9589BCFCE0DD6527597223C4917502ACBCF8D5E6C49F0B6FA60751A7C2748A3EE7DD6B70B5628F9A5873C6DB5936E57EB843C726043B95EBDE394F3584EC7096ED8DA60D86001EBCB9F3E72F99439F0E7DEC7297BA84D9924EFDB11A65566B8EFB510C7CC258DBB7779F7834A9756E6C97D114F95E5429F13CE5F7F9AAF51C996928604710FF544AFDC79717C10CD85157C6EDD75F7EB49C81D45C5EA9674E5BBBA065941BFB45F3D62D5E99E11488516568A15D1292255F635E8045E0520F3E15A0798DB5C5A08105EE52E3884C05255778E6F5C4A287CCB4D84D1D41CE08CD913C56656482EAEDE8E38D71B974553C199EC324573C3669237C585588E52D1ACE049F85521648659556CD83445D27C9F4D68501CE580E31748ED4948C0E3E88959B257C87E39D0A8EC5D812559234996A9EE5B6E864FE31BA5262971DE40FA5B75D9A487A9A79975C6AB5DD06EA6CCA9DB94FA6A1568AD8A4C33DBA6A5995EE5450AC0AA24A9C6DBAE9F6883CB48976D0ABA8D90AA9A88D6246C2ABA3FE8A1B43CA229B9C58AFC11E071AB1D1BE366DB5C9AE85DCA48595466B83AC95C61DA60D1146EEB3BB817ADA40A08CFBDBB2EB9972EB6EDB66D26D71768D5B2B1FEFC65B11AFA5FA96C93AF50AA6AFBEFE263C1DC0FCA2AB8AC210472C310A1100003B,
‘This is sample text data for Ramona Publishers, publisher 1756 in the pubs database. Ramona Publishers is located in Dallas, Texas.’)

insert pub_info values(‘9901’, 0x4749463839615D002200B30F00000000800000008000808000000080800080008080808080C0C0C0FF000000FF00FFFF000000FFFF00FF00FFFFFFFFFF21F9040100000F002C000000005D0022004004FFF0C949ABBD38EBCDFB03DF078C249895A386AA68BB9E6E0ACE623ABD1BC9E9985DFFB89E8E366BED782C5332563ABA4245A6744AAD5AAF4D2276CBED5EA1D026C528B230CD38B2C92721D78CC4772526748F9F611EB28DE7AFE25E818283604A1E8788898A7385838E8F55856F6C2C1D86392F6B9730708D6C5477673758A3865E92627E94754E173697A6A975809368949BB2AE7B9A6865AA734F80A2A17DA576AA5BB667C290CDCE4379CFD2CE9ED3D6A7CCD7DAA4D9C79341C8B9DF5FC052A8DEBA9BB696767B9C7FD5B8BBF23EABB9706BCAE5F05AB7E6C4C7488DDAF7251BC062530EFE93638C5B3580ECD4951312C217C425E73E89D38709D79D810D393BD20A528CE0AA704AA2D4D3082E583C89BD2C2D720753E1C8922697D44CF6AE53BF6D4041750B4AD467C54548932A1D7374A9D3A789004400003B,
‘This is sample text data for GGG&G, publisher 9901 in the pubs database. GGG&G is located in München, Germany.’)

insert pub_info values(‘9952’, 0x47494638396107012800B30F00000000800000008000808000000080800080008080808080C0C0C0FF000000FF00FFFF000000FFFF00FF00FFFFFFFFFF21F9040100000F002C00000000070128004004FFF0C949ABBD38EBCDBBFF60288E6469660005AC2C7BB56D05A7D24C4F339E3F765FC716980C3824F28418E4D1A552DA8ACCA5517A7B526F275912690D2A9BD11D14AB8B8257E7E9776BDEE452C2279C47A5CBEDEF2B3C3FBF9FC85981821D7D76868588878A898C8B838F1C8D928E733890829399949B979D9E9FA074A1A3A4A5A6A7458F583E69803F53AF4C62AD5E6DB13B6B3DAEAC6EBA64B365B26BB7ABBEB5C07FB428BCC4C8C1CCC7BBB065637C7A9B7BBE8CDADBDA8B7C31D9E1D88E2FA89E9AE9E49AE7EDA48DA2EEF2F3F4F597AEF6F9FAFBFC805D6CD28C0164C64D18BE3AAD88D87AA5C1DBC07FD59CE54293F0E0882AC39ED9CA2886E3308FB3FF262EBC726D591823204F2E0C09A4A3B32CFEACBC24198D86C48FD3E208D43832E3C0671A2D89737167281AA333219AC048D061499A3C83BEC8090BD84E5A99DE808B730DE9516B727CE85AE7C122BF73EAD29255CB76ADDBB6EC549C8504F7AD5DB37343A98D97576EDDBF7CFB0AEE8457EF5D4E83132BAEB1B8B1E3C749204B9EACB830E5CB984DE1F339A4E1CC88C93CB7D989D72234D1D3A672FEF85055C483C80A06742ADB664F3563119E417D5A8F52DFB1512AEC5D82E9C8662A477FB19A72B6F2E714413F8D0654AA75A8C4C648FDBC346ACDCD5487AFC439BE8BC8E8AA7F6BD77D2B7DF4E6C5882E57DFBDE2F56AEE6D87DFB8BFE06BE7E8F1C6CBCE4D2DC15751803C5956567EFA1D47A041E5F1176183CC1D571D21C2850396565CF5B1D5571D8AC21D08E099A15E85269E87207B1736B31E6FE620324E582116F5215178C86763518A9068DF7FE8C9C6207DCD0104A47B6B717388901EFA27238E3482454E43BB61E8D388F7FD44DD32473E79D43A527633232561E6F86536660256891699D175989A6F1A020A9C75C9D5E68274C619D79D91B5C5189F7906CA67297129D88F9E881A3AA83E8AB623E85E8B0EDAE89C892216E9A584B80318A69C7E3269A7A046FA69A8A4B6094004003B,
‘This is sample text data for Scootney Books, publisher 9952 in the pubs database. Scootney Books is located in New York City, New York.’)

insert pub_info values(‘9999’, 0x474946383961A9002400B30F00000000800000008000808000000080800080008080808080C0C0C0FF000000FF00FFFF000000FFFF00FF00FFFFFFFFFF21F9040100000F002C00000000A90024004004FFF0C949ABBD38EBCDBBFF60F8011A609E67653EA8D48A702CCFF44566689ED67CEFFF23D58E7513B686444A6EA26B126FC8E74AC82421A7ABE5F4594D61B7BBF0D6F562719A68A07ACDC6389925749AFC6EDBEFBCA24D3E96E2FF803D7A1672468131736E494A8B5C848D8633834B916E598B657E4A83905F7D9B7B56986064A09BA2A68D63603A2E717C9487B2B3209CA7AD52594751B4BD80B65D75B799BEC5BFAF7CC6CACB6638852ACC409F901BD33EB6BCCDC1D1CEA9967B23C082C3709662A69FA4A591E7AE84D87A5FA0AB502F43AC5D74EB9367B0624593FA5CB101ED144173E5F4315AE8485B4287FCBE39E446B1624173FEAC59DC2809594623D9C3388A54E4ACD59C642353E2F098E919319530DD61C405C7CBCB9831C5E5A2192C244E983A3FFE1CDA21282CA248ABB18C25336952A389D689E489B0D24483243B66CD8775A315801AA5A60A6B2DAC074E3741D6BBA8902BA687E9A6D1A3B6D6D15C7460C77AA3E3E556D79EBAF4AAAAB2CFCF578671DFDE657598305D51F7BE5E5A25361ED3388EED0A84B2B7535D6072C1D62DB5588BE5CCA5B1BDA377B99E3CBE9EDA31944A951ADF7DB15263A1429B37BB7E429D8EC4D754B87164078F2B87012002003B,
‘This is sample text data for Lucerne Publishing, publisher 9999 in the pubs database. Lucerne publishing is located in Paris, France.

This is sample text data for Lucerne Publishing, publisher 9999 in the pubs database. Lucerne publishing is located in Paris, France.

This is sample text data for Lucerne Publishing, publisher 9999 in the pubs database. Lucerne publishing is located in Paris, France.

This is sample text data for Lucerne Publishing, publisher 9999 in the pubs database. Lucerne publishing is located in Paris, France.’)
GO
raiserror(‘Now at the inserts to titles ….’,0,1)

GO

insert titles values (‘PC8888’, ‘Secrets of Silicon Valley’, ‘popular_comp’, ‘1389’,
$20.00, $8000.00, 10, 4095,
‘Muckraking reporting on the world”s largest computer hardware and software manufacturers.’,
’06/12/94′)

insert titles values (‘BU1032’, ‘The Busy Executive”s Database Guide’, ‘business’,
‘1389’, $19.99, $5000.00, 10, 4095,
‘An overview of available database systems with emphasis on common business applications. Illustrated.’,
’06/12/91′)

insert titles values (‘PS7777’, ‘Emotional Security: A New Algorithm’, ‘psychology’,
‘0736’, $7.99, $4000.00, 10, 3336,
‘Protecting yourself and your loved ones from undue emotional stress in the modern world. Use of computer and nutritional aids emphasized.’,
’06/12/91′)

insert titles values (‘PS3333’, ‘Prolonged Data Deprivation: Four Case Studies’,
‘psychology’, ‘0736’, $19.99, $2000.00, 10, 4072,
‘What happens when the data runs dry? Searching evaluations of information-shortage effects.’,
’06/12/91′)

insert titles values (‘BU1111’, ‘Cooking with Computers: Surreptitious Balance Sheets’,
‘business’, ‘1389’, $11.95, $5000.00, 10, 3876,
‘Helpful hints on how to use your electronic resources to the best advantage.’,
’06/09/91′)

insert titles values (‘MC2222’, ‘Silicon Valley Gastronomic Treats’, ‘mod_cook’, ‘0877’,
$19.99, $0.00, 12, 2032,
‘Favorite recipes for quick, easy, and elegant meals.’,
’06/09/91′)

insert titles values (‘TC7777’, ‘Sushi, Anyone?’, ‘trad_cook’, ‘0877’, $14.99, $8000.00,
10, 4095,
‘Detailed instructions on how to make authentic Japanese sushi in your spare time.’,
’06/12/91′)

insert titles values (‘TC4203’, ‘Fifty Years in Buckingham Palace Kitchens’, ‘trad_cook’,
‘0877’, $11.95, $4000.00, 14, 15096,
‘More anecdotes from the Queen”s favorite cook describing life among English royalty. Recipes, techniques, tender vignettes.’,
’06/12/91′)

insert titles values (‘PC1035’, ‘But Is It User Friendly?’, ‘popular_comp’, ‘1389’,
$22.95, $7000.00, 16, 8780,
‘A survey of software for the naive user, focusing on the ”friendliness” of each.’,
’06/30/91′)

insert titles values(‘BU2075’, ‘You Can Combat Computer Stress!’, ‘business’, ‘0736’,
$2.99, $10125.00, 24, 18722,
‘The latest medical and psychological techniques for living with the electronic office. Easy-to-understand explanations.’,
’06/30/91′)

insert titles values(‘PS2091’, ‘Is Anger the Enemy?’, ‘psychology’, ‘0736’, $10.95,
$2275.00, 12, 2045,
‘Carefully researched study of the effects of strong emotions on the body. Metabolic charts included.’,
’06/15/91′)

insert titles values(‘PS2106’, ‘Life Without Fear’, ‘psychology’, ‘0736’, $7.00, $6000.00,
10, 111,
‘New exercise, meditation, and nutritional techniques that can reduce the shock of daily interactions. Popular audience. Sample menus included, exercise video available separately.’,
’10/05/91′)

insert titles values(‘MC3021’, ‘The Gourmet Microwave’, ‘mod_cook’, ‘0877’, $2.99,
$15000.00, 24, 22246,
‘Traditional French gourmet recipes adapted for modern microwave cooking.’,
’06/18/91′)

insert titles values(‘TC3218’, ‘Onions, Leeks, and Garlic: Cooking Secrets of the Mediterranean’,
‘trad_cook’, ‘0877’, $20.95, $7000.00, 10, 375,
‘Profusely illustrated in color, this makes a wonderful gift book for a cuisine-oriented friend.’,
’10/21/91′)

insert titles (title_id, title, pub_id) values(‘MC3026’,
‘The Psychology of Computer Cooking’, ‘0877’)

insert titles values (‘BU7832’, ‘Straight Talk About Computers’, ‘business’, ‘1389’,
$19.99, $5000.00, 10, 4095,
‘Annotated analysis of what computers can do for you: a no-hype guide for the critical user.’,
’06/22/91′)

insert titles values(‘PS1372’, ‘Computer Phobic AND Non-Phobic Individuals: Behavior Variations’,
‘psychology’, ‘0877’, $21.59, $7000.00, 10, 375,
‘A must for the specialist, this book examines the difference between those who hate and fear computers and those who don”t.’,
’10/21/91′)

insert titles (title_id, title, type, pub_id, notes) values(‘PC9999’, ‘Net Etiquette’,
‘popular_comp’, ‘1389’, ‘A must-read for computer conferencing.’)

GO

raiserror(‘Now at the inserts to titleauthor ….’,0,1)

GO

insert titleauthor values(‘409-56-7008’, ‘BU1032’, 1, 60)
insert titleauthor values(‘486-29-1786’, ‘PS7777’, 1, 100)
insert titleauthor values(‘486-29-1786’, ‘PC9999’, 1, 100)
insert titleauthor values(‘712-45-1867’, ‘MC2222’, 1, 100)
insert titleauthor values(‘172-32-1176’, ‘PS3333’, 1, 100)
insert titleauthor values(‘213-46-8915’, ‘BU1032’, 2, 40)
insert titleauthor values(‘238-95-7766’, ‘PC1035’, 1, 100)
insert titleauthor values(‘213-46-8915’, ‘BU2075’, 1, 100)
insert titleauthor values(‘998-72-3567’, ‘PS2091’, 1, 50)
insert titleauthor values(‘899-46-2035’, ‘PS2091’, 2, 50)
insert titleauthor values(‘998-72-3567’, ‘PS2106’, 1, 100)
insert titleauthor values(‘722-51-5454’, ‘MC3021’, 1, 75)
insert titleauthor values(‘899-46-2035’, ‘MC3021’, 2, 25)
insert titleauthor values(‘807-91-6654’, ‘TC3218’, 1, 100)
insert titleauthor values(‘274-80-9391’, ‘BU7832’, 1, 100)
insert titleauthor values(‘427-17-2319’, ‘PC8888’, 1, 50)
insert titleauthor values(‘846-92-7186’, ‘PC8888’, 2, 50)
insert titleauthor values(‘756-30-7391’, ‘PS1372’, 1, 75)
insert titleauthor values(‘724-80-9391’, ‘PS1372’, 2, 25)
insert titleauthor values(‘724-80-9391’, ‘BU1111’, 1, 60)
insert titleauthor values(‘267-41-2394’, ‘BU1111’, 2, 40)
insert titleauthor values(‘672-71-3249’, ‘TC7777’, 1, 40)
insert titleauthor values(‘267-41-2394’, ‘TC7777’, 2, 30)
insert titleauthor values(‘472-27-2349’, ‘TC7777’, 3, 30)
insert titleauthor values(‘648-92-1872’, ‘TC4203’, 1, 100)

GO

raiserror(‘Now at the inserts to stores ….’,0,1)

GO

insert stores values(‘7066′,’Barnum”s’,’567 Pasadena Ave.’,’Tustin’,’CA’,’92789′)
insert stores values(‘7067′,’News & Brews’,’577 First St.’,’Los Gatos’,’CA’,’96745′)
insert stores values(‘7131′,’Doc-U-Mat: Quality Laundry and Books’,
’24-A Avogadro Way’,’Remulade’,’WA’,’98014′)
insert stores values(‘8042′,’Bookbeat’,’679 Carson St.’,’Portland’,’OR’,’89076′)
insert stores values(‘6380′,’Eric the Read Books’,’788 Catamaugus Ave.’,
‘Seattle’,’WA’,’98056′)
insert stores values(‘7896′,’Fricative Bookshop’,’89 Madison St.’,’Fremont’,’CA’,’90019′)

GO

raiserror(‘Now at the inserts to sales ….’,0,1)

GO

insert sales values(‘7066’, ‘QA7442.3′, ’09/13/94’, 75, ‘ON invoice’,’PS2091′)
insert sales values(‘7067’, ‘D4482′, ’09/14/94’, 10, ‘Net 60′,’PS2091’)
insert sales values(‘7131’, ‘N914008′, ’09/14/94’, 20, ‘Net 30′,’PS2091’)
insert sales values(‘7131’, ‘N914014′, ’09/14/94’, 25, ‘Net 30′,’MC3021’)
insert sales values(‘8042’, ‘423LL922′, ’09/14/94’, 15, ‘ON invoice’,’MC3021′)
insert sales values(‘8042’, ‘423LL930′, ’09/14/94’, 10, ‘ON invoice’,’BU1032′)
insert sales values(‘6380’, ‘722a’, ’09/13/94′, 3, ‘Net 60′,’PS2091’)
insert sales values(‘6380’, ‘6871’, ’09/14/94′, 5, ‘Net 60′,’BU1032’)
insert sales values(‘8042′,’P723′, ’03/11/93’, 25, ‘Net 30’, ‘BU1111’)
insert sales values(‘7896′,’X999′, ’02/21/93’, 35, ‘ON invoice’, ‘BU2075’)
insert sales values(‘7896′,’QQ2299′, ’10/28/93’, 15, ‘Net 60’, ‘BU7832’)
insert sales values(‘7896′,’TQ456′, ’12/12/93’, 10, ‘Net 60’, ‘MC2222’)
insert sales values(‘8042′,’QA879.1’, ‘5/22/93’, 30, ‘Net 30’, ‘PC1035’)
insert sales values(‘7066′,’A2976’, ‘5/24/93’, 50, ‘Net 30’, ‘PC8888’)
insert sales values(‘7131′,’P3087a’, ‘5/29/93’, 20, ‘Net 60’, ‘PS1372’)
insert sales values(‘7131′,’P3087a’, ‘5/29/93’, 25, ‘Net 60’, ‘PS2106’)
insert sales values(‘7131′,’P3087a’, ‘5/29/93’, 15, ‘Net 60’, ‘PS3333’)
insert sales values(‘7131′,’P3087a’, ‘5/29/93’, 25, ‘Net 60’, ‘PS7777’)
insert sales values(‘7067′,’P2121’, ‘6/15/92’, 40, ‘Net 30’, ‘TC3218’)
insert sales values(‘7067′,’P2121’, ‘6/15/92’, 20, ‘Net 30’, ‘TC4203’)
insert sales values(‘7067′,’P2121’, ‘6/15/92’, 20, ‘Net 30’, ‘TC7777’)

GO

raiserror(‘Now at the inserts to roysched ….’,0,1)

GO

insert roysched values(‘BU1032’, 0, 5000, 10)
insert roysched values(‘BU1032’, 5001, 50000, 12)
insert roysched values(‘PC1035’, 0, 2000, 10)
insert roysched values(‘PC1035’, 2001, 3000, 12)
insert roysched values(‘PC1035’, 3001, 4000, 14)
insert roysched values(‘PC1035’, 4001, 10000, 16)
insert roysched values(‘PC1035’, 10001, 50000, 18)
insert roysched values(‘BU2075’, 0, 1000, 10)
insert roysched values(‘BU2075’, 1001, 3000, 12)
insert roysched values(‘BU2075’, 3001, 5000, 14)

GO

insert roysched values(‘BU2075’, 5001, 7000, 16)
insert roysched values(‘BU2075’, 7001, 10000, 18)
insert roysched values(‘BU2075’, 10001, 12000, 20)
insert roysched values(‘BU2075’, 12001, 14000, 22)
insert roysched values(‘BU2075’, 14001, 50000, 24)
insert roysched values(‘PS2091’, 0, 1000, 10)
insert roysched values(‘PS2091’, 1001, 5000, 12)
insert roysched values(‘PS2091’, 5001, 10000, 14)
insert roysched values(‘PS2091’, 10001, 50000, 16)
insert roysched values(‘PS2106’, 0, 2000, 10)

GO

insert roysched values(‘PS2106’, 2001, 5000, 12)
insert roysched values(‘PS2106’, 5001, 10000, 14)
insert roysched values(‘PS2106’, 10001, 50000, 16)
insert roysched values(‘MC3021’, 0, 1000, 10)
insert roysched values(‘MC3021’, 1001, 2000, 12)
insert roysched values(‘MC3021’, 2001, 4000, 14)
insert roysched values(‘MC3021’, 4001, 6000, 16)
insert roysched values(‘MC3021’, 6001, 8000, 18)
insert roysched values(‘MC3021’, 8001, 10000, 20)
insert roysched values(‘MC3021’, 10001, 12000, 22)

GO

insert roysched values(‘MC3021’, 12001, 50000, 24)
insert roysched values(‘TC3218’, 0, 2000, 10)
insert roysched values(‘TC3218’, 2001, 4000, 12)
insert roysched values(‘TC3218’, 4001, 6000, 14)
insert roysched values(‘TC3218’, 6001, 8000, 16)
insert roysched values(‘TC3218’, 8001, 10000, 18)
insert roysched values(‘TC3218’, 10001, 12000, 20)
insert roysched values(‘TC3218’, 12001, 14000, 22)
insert roysched values(‘TC3218’, 14001, 50000, 24)
insert roysched values(‘PC8888’, 0, 5000, 10)
insert roysched values(‘PC8888’, 5001, 10000, 12)

GO

insert roysched values(‘PC8888’, 10001, 15000, 14)
insert roysched values(‘PC8888’, 15001, 50000, 16)
insert roysched values(‘PS7777’, 0, 5000, 10)
insert roysched values(‘PS7777’, 5001, 50000, 12)
insert roysched values(‘PS3333’, 0, 5000, 10)
insert roysched values(‘PS3333’, 5001, 10000, 12)
insert roysched values(‘PS3333’, 10001, 15000, 14)
insert roysched values(‘PS3333’, 15001, 50000, 16)
insert roysched values(‘BU1111’, 0, 4000, 10)
insert roysched values(‘BU1111’, 4001, 8000, 12)
insert roysched values(‘BU1111’, 8001, 10000, 14)

GO

insert roysched values(‘BU1111’, 12001, 16000, 16)
insert roysched values(‘BU1111’, 16001, 20000, 18)
insert roysched values(‘BU1111’, 20001, 24000, 20)
insert roysched values(‘BU1111’, 24001, 28000, 22)
insert roysched values(‘BU1111’, 28001, 50000, 24)
insert roysched values(‘MC2222’, 0, 2000, 10)
insert roysched values(‘MC2222’, 2001, 4000, 12)
insert roysched values(‘MC2222’, 4001, 8000, 14)
insert roysched values(‘MC2222’, 8001, 12000, 16)

GO

insert roysched values(‘MC2222’, 12001, 20000, 18)
insert roysched values(‘MC2222’, 20001, 50000, 20)
insert roysched values(‘TC7777’, 0, 5000, 10)
insert roysched values(‘TC7777’, 5001, 15000, 12)
insert roysched values(‘TC7777’, 15001, 50000, 14)
insert roysched values(‘TC4203’, 0, 2000, 10)
insert roysched values(‘TC4203’, 2001, 8000, 12)
insert roysched values(‘TC4203’, 8001, 16000, 14)
insert roysched values(‘TC4203’, 16001, 24000, 16)
insert roysched values(‘TC4203’, 24001, 32000, 18)

GO

insert roysched values(‘TC4203’, 32001, 40000, 20)
insert roysched values(‘TC4203’, 40001, 50000, 22)
insert roysched values(‘BU7832’, 0, 5000, 10)
insert roysched values(‘BU7832’, 5001, 10000, 12)
insert roysched values(‘BU7832’, 10001, 15000, 14)
insert roysched values(‘BU7832’, 15001, 20000, 16)
insert roysched values(‘BU7832’, 20001, 25000, 18)
insert roysched values(‘BU7832’, 25001, 30000, 20)
insert roysched values(‘BU7832’, 30001, 35000, 22)
insert roysched values(‘BU7832’, 35001, 50000, 24)

GO

insert roysched values(‘PS1372’, 0, 10000, 10)
insert roysched values(‘PS1372’, 10001, 20000, 12)
insert roysched values(‘PS1372’, 20001, 30000, 14)
insert roysched values(‘PS1372’, 30001, 40000, 16)
insert roysched values(‘PS1372’, 40001, 50000, 18)

GO

raiserror(‘Now at the inserts to discounts ….’,0,1)

GO

insert discounts values(‘Initial Customer’, NULL, NULL, NULL, 10.5)
insert discounts values(‘Volume Discount’, NULL, 100, 1000, 6.7)
insert discounts values(‘Customer Discount’, ‘8042’, NULL, NULL, 5.0)

GO

raiserror(‘Now at the inserts to jobs ….’,0,1)

GO

insert jobs values (‘New Hire – Job not specified’, 10, 10)
insert jobs values (‘Chief Executive Officer’, 200, 250)
insert jobs values (‘Business Operations Manager’, 175, 225)
insert jobs values (‘Chief Financial Officier’, 175, 250)
insert jobs values (‘Publisher’, 150, 250)
insert jobs values (‘Managing Editor’, 140, 225)
insert jobs values (‘Marketing Manager’, 120, 200)
insert jobs values (‘Public Relations Manager’, 100, 175)
insert jobs values (‘Acquisitions Manager’, 75, 175)
insert jobs values (‘Productions Manager’, 75, 165)
insert jobs values (‘Operations Manager’, 75, 150)
insert jobs values (‘Editor’, 25, 100)
insert jobs values (‘Sales Representative’, 25, 100)
insert jobs values (‘Designer’, 25, 100)

GO

raiserror(‘Now at the inserts to employee ….’,0,1)

GO

insert employee values (‘PTC11962M’, ‘Philip’, ‘T’, ‘Cramer’, 2, 215, ‘9952’, ’11/11/89′)
insert employee values (‘AMD15433F’, ‘Ann’, ‘M’, ‘Devon’, 3, 200, ‘9952’, ’07/16/91′)
insert employee values (‘F-C16315M’, ‘Francisco’, ”, ‘Chang’, 4, 227, ‘9952’, ’11/03/90′)
insert employee values (‘LAL21447M’, ‘Laurence’, ‘A’, ‘Lebihan’, 5, 175, ‘0736’, ’06/03/90′)
insert employee values (‘PXH22250M’, ‘Paul’, ‘X’, ‘Henriot’, 5, 159, ‘0877’, ’08/19/93′)
insert employee values (‘SKO22412M’, ‘Sven’, ‘K’, ‘Ottlieb’, 5, 150, ‘1389’, ’04/05/91′)
insert employee values (‘RBM23061F’, ‘Rita’, ‘B’, ‘Muller’, 5, 198, ‘1622’, ’10/09/93′)
insert employee values (‘MJP25939M’, ‘Maria’, ‘J’, ‘Pontes’, 5, 246, ‘1756’, ’03/01/89′)
insert employee values (‘JYL26161F’, ‘Janine’, ‘Y’, ‘Labrune’, 5, 172, ‘9901’, ’05/26/91′)
insert employee values (‘CFH28514M’, ‘Carlos’, ‘F’, ‘Hernadez’, 5, 211, ‘9999’, ’04/21/89′)
insert employee values (‘VPA30890F’, ‘Victoria’, ‘P’, ‘Ashworth’, 6, 140, ‘0877’, ’09/13/90′)
insert employee values (‘L-B31947F’, ‘Lesley’, ”, ‘Brown’, 7, 120, ‘0877’, ’02/13/91′)
insert employee values (‘ARD36773F’, ‘Anabela’, ‘R’, ‘Domingues’, 8, 100, ‘0877’, ’01/27/93′)
insert employee values (‘M-R38834F’, ‘Martine’, ”, ‘Rance’, 9, 75, ‘0877’, ’02/05/92′)
insert employee values (‘PHF38899M’, ‘Peter’, ‘H’, ‘Franken’, 10, 75, ‘0877’, ’05/17/92′)
insert employee values (‘DBT39435M’, ‘Daniel’, ‘B’, ‘Tonini’, 11, 75, ‘0877’, ’01/01/90′)
insert employee values (‘H-B39728F’, ‘Helen’, ”, ‘Bennett’, 12, 35, ‘0877’, ’09/21/89′)
insert employee values (‘PMA42628M’, ‘Paolo’, ‘M’, ‘Accorti’, 13, 35, ‘0877’, ’08/27/92′)
insert employee values (‘ENL44273F’, ‘Elizabeth’, ‘N’, ‘Lincoln’, 14, 35, ‘0877’, ’07/24/90′)

GO

insert employee values (‘MGK44605M’, ‘Matti’, ‘G’, ‘Karttunen’, 6, 220, ‘0736’, ’05/01/94′)
insert employee values (‘PDI47470M’, ‘Palle’, ‘D’, ‘Ibsen’, 7, 195, ‘0736’, ’05/09/93′)
insert employee values (‘MMS49649F’, ‘Mary’, ‘M’, ‘Saveley’, 8, 175, ‘0736’, ’06/29/93′)
insert employee values (‘GHT50241M’, ‘Gary’, ‘H’, ‘Thomas’, 9, 170, ‘0736’, ’08/09/88′)
insert employee values (‘MFS52347M’, ‘Martin’, ‘F’, ‘Sommer’, 10, 165, ‘0736’, ’04/13/90′)
insert employee values (‘R-M53550M’, ‘Roland’, ”, ‘Mendel’, 11, 150, ‘0736’, ’09/05/91′)
insert employee values (‘HAS54740M’, ‘Howard’, ‘A’, ‘Snyder’, 12, 100, ‘0736’, ’11/19/88′)
insert employee values (‘TPO55093M’, ‘Timothy’, ‘P’, ‘O”Rourke’, 13, 100, ‘0736’, ’06/19/88′)
insert employee values (‘KFJ64308F’, ‘Karin’, ‘F’, ‘Josephs’, 14, 100, ‘0736’, ’10/17/92′)
insert employee values (‘DWR65030M’, ‘Diego’, ‘W’, ‘Roel’, 6, 192, ‘1389’, ’12/16/91′)
insert employee values (‘M-L67958F’, ‘Maria’, ”, ‘Larsson’, 7, 135, ‘1389’, ’03/27/92′)
insert employee values (‘PSP68661F’, ‘Paula’, ‘S’, ‘Parente’, 8, 125, ‘1389’, ’01/19/94′)
insert employee values (‘MAS70474F’, ‘Margaret’, ‘A’, ‘Smith’, 9, 78, ‘1389’, ’09/29/88′)
insert employee values (‘A-C71970F’, ‘Aria’, ”, ‘Cruz’, 10, 87, ‘1389’, ’10/26/91′)
insert employee values (‘MAP77183M’, ‘Miguel’, ‘A’, ‘Paolino’, 11, 112, ‘1389’, ’12/07/92′)
insert employee values (‘Y-L77953M’, ‘Yoshi’, ”, ‘Latimer’, 12, 32, ‘1389’, ’06/11/89′)
insert employee values (‘CGS88322F’, ‘Carine’, ‘G’, ‘Schmitt’, 13, 64, ‘1389’, ’07/07/92′)
insert employee values (‘PSA89086M’, ‘Pedro’, ‘S’, ‘Afonso’, 14, 89, ‘1389’, ’12/24/90′)
insert employee values (‘A-R89858F’, ‘Annette’, ”, ‘Roulet’, 6, 152, ‘9999’, ’02/21/90′)
insert employee values (‘HAN90777M’, ‘Helvetius’, ‘A’, ‘Nagy’, 7, 120, ‘9999’, ’03/19/93′)
insert employee values (‘M-P91209M’, ‘Manuel’, ”, ‘Pereira’, 8, 101, ‘9999’, ’01/09/89′)
insert employee values (‘KJJ92907F’, ‘Karla’, ‘J’, ‘Jablonski’, 9, 170, ‘9999’, ’03/11/94′)
insert employee values (‘POK93028M’, ‘Pirkko’, ‘O’, ‘Koskitalo’, 10, 80, ‘9999’, ’11/29/93′)
insert employee values (‘PCM98509F’, ‘Patricia’, ‘C’, ‘McKenna’, 11, 150, ‘9999’, ’08/01/89′)
GO

raiserror(‘Now at the create index section ….’,0,1) with nowait

GO

CREATE CLUSTERED INDEX employee_ind ON employee(lname, fname, minit)

GO

CREATE NONCLUSTERED INDEX aunmind ON authors (au_lname, au_fname)
GO
CREATE NONCLUSTERED INDEX titleidind ON sales (title_id)
GO
CREATE NONCLUSTERED INDEX titleind ON titles (title)
GO
CREATE NONCLUSTERED INDEX auidind ON titleauthor (au_id)
GO
CREATE NONCLUSTERED INDEX titleidind ON titleauthor (title_id)
GO
CREATE NONCLUSTERED INDEX titleidind ON roysched (title_id)
GO

raiserror(‘Now at the create view section ….’,0,1)

GO

CREATE VIEW titleview
AS
select title, au_ord, au_lname, price, ytd_sales, pub_id
from authors, titles, titleauthor
where authors.au_id = titleauthor.au_id
AND titles.title_id = titleauthor.title_id

GO

raiserror(‘Now at the create procedure section ….’,0,1)

GO

CREATE PROCEDURE byroyalty @percentage int
AS
select au_id from titleauthor
where titleauthor.royaltyper = @percentage

GO

CREATE PROCEDURE reptq1 AS
select
case when grouping(pub_id) = 1 then ‘ALL’ else pub_id end as pub_id,
avg(price) as avg_price
from titles
where price is NOT NULL
group by pub_id with rollup
order by pub_id

GO

CREATE PROCEDURE reptq2 AS
select
case when grouping(type) = 1 then ‘ALL’ else type end as type,
case when grouping(pub_id) = 1 then ‘ALL’ else pub_id end as pub_id,
avg(ytd_sales) as avg_ytd_sales
from titles
where pub_id is NOT NULL
group by pub_id, type with rollup

GO

CREATE PROCEDURE reptq3 @lolimit money, @hilimit money,
@type char(12)
AS
select
case when grouping(pub_id) = 1 then ‘ALL’ else pub_id end as pub_id,
case when grouping(type) = 1 then ‘ALL’ else type end as type,
count(title_id) as cnt
from titles
where price >@lolimit AND price <@hilimit AND type = @type OR type LIKE ‘%cook%’
group by pub_id, type with rollup

GO

UPDATE STATISTICS publishers
UPDATE STATISTICS employee
UPDATE STATISTICS jobs
UPDATE STATISTICS pub_info
UPDATE STATISTICS titles
UPDATE STATISTICS authors
UPDATE STATISTICS titleauthor
UPDATE STATISTICS sales
UPDATE STATISTICS roysched
UPDATE STATISTICS stores
UPDATE STATISTICS discounts

GO

CHECKPOINT

GO

USE master

GO

CHECKPOINT

GO

declare @dttm varchar(55)
select @dttm=convert(varchar,getdate(),113)
raiserror(‘Ending InstPubs.SQL at %s ….’,1,1,@dttm) with nowait

GO
— –

[/toggle_item]

[/toggle_box]

Install Northwind database in Microsoft SQL Server 2012 in 3 easy steps

This guide will show how to install northwind database in only  3 easy steps.

Having trouble attaching northwind  database to your  SQL Server 2012? Well you are not alone! Northwind is the name of the sample database for SQL Server 2000, that later got replaced with the AdventureWorks sample database in SQL Server 2005. However, it is still used in e.g. Microsoft SQL Server 2008 Database Development Training Kit so may still be relevant for users trying to learn SQL essentials.

The problem is that the original database file is not compatible with the newest version of SQL Server and causes difficulty for new users. We don’t believe the first lesson of SQL training should be jumping through hoops to get the sample data working, so here is the “fixed” database file and a guide to install it.

Good luck!

You can download the database here (zipped) and I would recommend you extract it to your SQL Server DATA folder as e.g.: “C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA”.



Step 1:

Open SQL Server Management Studio and connect to your instance. Right-click the “Databases” folder and click “Attach”.

Northwind Install step 1

Step 2:

Click “Add…”  in the “Databases to attach:” box and find NORTHWIND.MDF in your folder. Make sure to click on the file and check that the “Database Data File Location:” is accurate.  Click OK.

Northwind Install step 2-1

 

Northwind Install step 2-2

 

Step 3:

Notice that it includes a “NORTHWIND_log.ldf” which actually doesn’t exist. So we want to click on that and remove it. Don’t worry! A new log file will automatically get created in the right location once you have attached the datbase.  Also, verify that “NORTHWIND.MDF” has the right “Current File Path”. Click OK and check the “Databases” folder in SQL Server Management Studio for the “northwind” database.

Northwind Install step 3-1

Northwind Install step 3-2

That’s it! You should now have full access to the Northwind Sample Database in a SQL Server 2012 environment.

SQL Server 2012 SP1 is out!

To all Business Impact Clients:

Microsoft released on the 19th November, the first Service Pack (SP1) for SQL Server 2012. One can find the list of fixes in their support article: http://support.microsoft.com/kb/2674319 and read more about the individual bugs and issues.

In general, we are finding that SQL2012 is a highly stable, very fast improved edition of SQL Server and would recommend that anyone on anything older than SQL2008R2 consider an upgrade. Updates on the Business Intelligence Edition including Power Pivot are nice, but the overall speed, the improvements in clustering (AlwaysOn), the better version of BIDS (now called SQL Data Tools) and the columnar indexing have been highlights of a worthy product.

Windows Update should offer the SQL Server 2012 SP1 as a “suggested” update but is of course also available directly from Microsoft’s website: http://support.microsoft.com/kb/2755533