Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  SQL Server Development (2000)  sql statement

Author  Topic  sgw1963 Starting Member 6 Posts Posted - 2001-01-24 : 16:00:57 I am trying to write a sql statement where I want to see how many times a customer was called upon since Oct 1 2000. I have fields in the database that show when they were called the last 12 times. Example Customer name called1 called2 called3 called4 John smith 01/21/01 12/20/00 11/21/00 10/24/00 How do I write this so that it will show this data? Thanks in advance Scott