is this what they are thinking of:

https://en.wikipedia.org/wiki/Pair_programming

just thinking out loud.....but do you have a prescribed list of the models you need to search for.....eg "6S 64GB - L900 - N930P - G935 32GB"?

am not sure I fully understand....but using some sample data you posted in an earlier thread, I dont beleive your code gives you the results you are looking for.....but I...

Lynn Pettis (9/19/2016)

---

Really??...

cant download......

The www.sqlservercentral.com page isn’t working

www.sqlservercentral.com sent an invalid response.

ERR_RESPONSE_HEADERS_MULTIPLE_CONTENT_DISPOSITION

ok lets start again......here is some sample data that covers your possible permutation.....based on what I think I undestand so far.

if...

philand3 (9/18/2016)

---

Hello Livi.

Thanks for your efforts.

I would like to know the total hours details like this ( Total hours = first IN - first OUT )

each day i need to...

as per my previous post and the associated link...please see below the best way to provide sample data.

so...for you and others who may wish to try and help you

USE tempdb

GO

CREATE...

philand3 (9/18/2016)

---

Hi Livingston,

Find below my reply.

will there always be only two rows per emp/date? apart from this action_id is very important.(and Many rows which includes name,email id ,timezone,etc)

will there ever...

thanks for sample data......could you please provide expected results for this sample (think I know what you are looking for...but this will clarify)

also....in your sample data you have only...

philand3 (9/18/2016)

---

Dear All i need sql query to know the total hours spend,

My table looks like this .

action id ,creation_date,event_name,emp_number,

1,7/21/2016 10:37:21 AM,IN,9234

2,7/21/2016 11:37:21 AM,OUT,9234

output ,

em_number,creation_Date,total hours spend

9234...

"Is there a way to do this without using a cte or temp table"...please explain why you have these restrictions

is this just the data or do you have the file definitions as well?

probably better if you ask your question on a specific Progress forum like Progresstalk

jansub07 (9/16/2016)

---

Yes i visited that document. But the OpenEdge tool is not accepted by client environment. Another thing they only provide the data dump. Connecting ProgressDB through providers are not...

would have been useful if you had posted the error message.....heyho.

try this instead of...