24tjf (12/18/2009)

---

Thanks for the help.

If I am selecting from the temp table, i.e. MemberID: xxx has had 4 visits (all at the same store) [Not in the example]

Then the query...

Please don't double post

Post any responses to http://www.sqlservercentral.com/Forums/Topic836660-1292-1.aspx

Based on the available information, I did the following:

Create Table #StoreVisit (StoreID int, MemberID int, DateVisited datetime)

go

Insert into #StoreVisit(StoreID,MemberID,DateVisited)

Select 888,100100,'2009-01-25'

Union All

Select 888,100100,'2009-02-15'

Union All

Select 999, 200200,'2009-07-01'

Union All

Select 777, 200200, '2009-09-25'

Union All

Select...

Yes it will work.

To find the Servers:

OSQL command line utility

or

SQLRecon

Once you know the servers, you will need to run scripts against each of them to determine databases and database owners.

looks like you got it working...

Yes, please - Divulge the upgrade details.

NP.

GSquared (12/18/2009)

---

Black, metalic cases, with cooling fans. Lots of little lights, but not so many as the bridge of The...

You're welcome

The Use Database statement may correct this issue.

Something may be caching in the system for a different database.

When he tries to create the table, does he do it through the GUI or TSQL? Have you watched...

Besides, I can't even get on twitter while at work (and i'm not gonna do the teeny bopper thing and use my cellphone for it) - websense.

You do or don't like it?

Personally, I...

This might be more along the lines of what you are requesting:

http://www.mssqltips.com/tip.asp?tip=1112