It's a pivoted view i'm querying against.

OOps try this one as the data source. Sorry I was messing with the query earlier.

What i'm needing on the data is to find the records that their first time at the Golf Event found in the GOLF<year> column, then if they came back the...

I have included the file now.

Awesome. Thank you very much. I was able to tweak the code to fit my needs but that's exactly what I was looking for. Kudo's

Awesome, thanks.:-D Much appreciated

Where do I get that at? The tool kit?

What I need to be able to determine is how many people where on the floor at a given time frame. As far as On the floor and Off...

Sorry about that, the badge type will come from a different table in a seperate database, I just need to make since of the rfid data, and what...

What I'm looking for is a matrix type of effect that will how like this

***Assumption

-----------------|-------------|------------|------------|

Time____________BadgeType1__BadgeType2__BadgeType3

8:00...

Got it figured out it was not a data problem I had to do some other things with the grouping (well more like a different formula that was running total...

Drew, first thank you for the comments, Although it was not appreciated being chastised the way you did it. I wanted to provide all of the information I...

I have added the appropriate code here in a txt file

Trying to accomplish

1. Getting the current date (that part is easy) and post that in the current date...

not using any alias's

Here is the exact query

select top 10 * from s22.gcsaa.dbo.tblMemberTrack (This works just fine on s23 querying linked server db on s22

This one give the error...

Nope that's not the problem. I have tried the

select top 10 from s22.database.dbo.table and got results but then I tried to join a database on the second server...