Check out http://ve3d.ign.com/articles/603/603130p1.html?ui=rssFeed

Here is a potential option (barring I didn't typo or misread the original)

SELECT    

 PERSON.PER_FNAME,

 PERSON.PER_SNAME,

 PERSON.PER_DOB,

 NCYEAR.NCY_DESC,

 PERSON.PER_ID,

 ATTEND.PAT_TO_DATE

FROM  

 dbo.tblPERSON PERSON

INNER JOIN

 dbo.tblPUPIL PUPIL

 INNER JOIN

  dbo.tblLU_PUP_NCYEAR NCYEAR

 ON

  PUPIL.tblLU_PUP_NCYEAR =...

I too applogize for the remarks that have left you unhappy. Joe could have been more tactfull in his comments, if it is really him. Post here anytime and hopefully...

Good book.

For those who want to know more about the 1NF statement by Adam Machanic here are a couple of related links

http://www.dbdebunk.com/page/page/1103802.htm

http://www.dbdebunk.com/page/page/622301.htm

http://www.dbdebunk.com/page/page/622318.htm

http://www.dmreview.com/editorial/newsletter_article.cfm?nl=dmdirect&articleId=5893

Sorry Adam must have been posting...

Only because I have a ton of work now (moved with a few of my apps to a group who is mostly mainframers and I am the only distributed developer avaiable) and...

dcpeterson:

I just want to touch on this.

You statements previously about

Train Station rather than Trains Station

Shoe Store rather than Shoes Store

Container Ship rather than Containers Ship

I will say you are...

You know I love this

Customers.FirstNames???? NO

Customer.FirstName

The table is an abstract concept (presented in the form of an object or container). It is the container of the concept of multiple objects...

Without looking at the code I would have to say 1000 connections supporting 50 users is horrible. I would see normally about 50 connections maybe a few more.

A sinle connection...

You can also use the import/export wizard.

I suggest contact you VPN support. Is the VPN server the same as the firewall or is it exposed on the firewall and is a seperate device?

See post in http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=9&messageid=172275&app=true and please do not cross post.

Are you dropping all existing costraints on a table or selective ones. If all then you should be able to write a cursor to use the sys tables (i think sysobjects) to get...

Have you tried just connecting to the SQL 7 instance from your machine with QA to verify you can get connected?

Try this

SELECT

 A.dt,

 A.cd,

 B.bkt,

 Max(case when B.bkt = A.bkt then A.cnt else 0 end) cnt,

 Max(case when B.bkt = A.bkt then A.amt else 0 end) amt

FROM

 @aging A

CROSS JOIN

 @bkt B

WHERE

 A.dt = '20050404'

GROUP BY

 A.dt,

 A.cd,

 B.bkt

ORDER BY

 A.dt,

 A.cd,

 B.bkt