Thanks for the table structure and sample data.

SETUP

DECLARE @PropDet TABLE

(

PropId INT PRIMARY KEY,

UserId UNIQUEIDENTIFIER,

PropName NVARCHAR(50),

Resort NVARCHAR(50),

Col5 NVARCHAR(50),

Col6 NVARCHAR(50),

Col7 NVARCHAR(50),

Col8 NVARCHAR(50),

Col9 NVARCHAR(50),

Col10 NVARCHAR(50),

Col11 NVARCHAR(50),

Col12 NVARCHAR(50)

)

INSERT INTO @PropDet

...

Can you show what your desired output would be if they had 2+ clockin/outs for the same day? You have columns designed for a 1 to 1 relationship of...

This is a bit beyond me, but my thinking is that you should be able to do this via fully qualified names and a linked oracle server.

Here is an article...

Yeah, I had a feeling that was going to happen. We always has the same annoyance with our time clock stuff. Worse, ours were constantly missing login/logout data....

Do you mean you want to start over the count each year with 1?

Also, as for the @ID, it serves no real purpose except to "anchor" that query. People...

Ok, so I've given up on the old method, and come up with this. Not set based :crying:. Hopefully I didn't completely bugger up my cursor syntax, I...

Just to make sure you understand, I wasn't trying to chastise you for your errors, and I appreciate you giving it a shot. The only reason I...

I never said *I* wasn't lazy =). But I do try to avoid it when everyone is telling me it could cause major issues...

Fair enough. It was a pretty bold statement that may not be 100% accurate. It was in response to this:

Yes, that's all right, but if you make a...

ggraber (10/27/2008)

---

bhovious (10/27/2008)

---

Hey Seth,

Could you give me one example of the iterative situation you describe. I didn't see that in all of the examples I looked at. ...

Basically, this:

IDRowKeyLocaleCode

11ENA

22ENA

32DUA

41ENA

52DUA

You see that Rows 3 and 5 are duplicates. However, because Row 4 is a duplicate of Row 1, the matching starts over at row 4. There...

bhovious (10/27/2008)

---

1. The rows where the Code column "breaks" to a new code, which doesn't include the first row in the table.

2. Any duplicates (same Key,...

Considering the OP hasn't logged on in over a year, I have a...

Thanks for the DDL and sample data, especially in Table Variable format, it makes things so much easier. How about something like this?

[font="Courier New"]

SELECT EmpNum

                ,SUM(CASE WHEN DATEPART (dw,ClockInDate)=...

Check out the SET FMTONLY ON command. It won't return the column types and such, but it will get you all the column names.

http://msdn.microsoft.com/en-us/library/ms173839.aspx

You could also insert the output...