Lol, I was close... I thaught it was all homework questions

THREAD CLOSED!

Trigger also can do this.

dbo. is the owner of the object.

If no restriction has been created on the name field, then you have to use count(distinct ...)).

I would suggest you add one so that...

I C said the blind man.

Select count(*) FROM dbo.TblFruit should do it.

However this assumes that no duplicates are in the table.

Please do not cross-post, we monitor all boards.

Finish the thread here :

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=4&messageid=327570

Please consider this thread closed.

Select tblSales.FruitID,tblSales.Date,tblSales.Volume, tblSales.Price,

TblFruit.FruitDescription from TblFruit INNER JOIN tblSales on TblFruit.FruitID = tblSales.FruitID where tblSales.date >= ‘2001/01/01’ AND tblSales.date < '2002/01/01' and tblSales.FruitID in (‘4’,’5’,’7’);

No clue without the error.

Can you post it?  Maybe it'll ring someone's bell!

What do they want to do with those files?

Why not use full db backups and let the other guys do the import work (presuming a lot of things here

Care to link an article here... I'd like to see that!

Yes those are called tables and table functions .

Please do not cross-post.  we monitor all boards.

Finish this thread here :

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=145&messageid=327541

Please consider this thread terminated!

Don't know.. I'll be long retired by then too .

IIRC the Y2K bug was being talked about way before 2000.  That's why I gave a 2 years notice...  You know 'cause running an alter table command can take that much...

Rerun the install, make sure you chose to install the tools.