Viewing 15 posts - 361 through 375 (of 2,452 total)
is this what they are thinking of:
https://en.wikipedia.org/wiki/Pair_programming
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
September 21, 2016 at 9:52 am
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"?
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
September 21, 2016 at 9:18 am
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...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
September 19, 2016 at 10:47 am
Lynn Pettis (9/19/2016)
astrid 69000 (9/18/2016)
this is the result i needi have attached an excel cause i dont know how to make a sample of a table to show it.
Really??...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
September 19, 2016 at 9:03 am
vilyana (9/18/2016)
Hi, I've attached the DDL, sample data, the View ad a code snippet.
cant download......
The www.sqlservercentral.com page isn’t working
www.sqlservercentral.com sent an invalid response.
ERR_RESPONSE_HEADERS_MULTIPLE_CONTENT_DISPOSITION
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
September 19, 2016 at 2:17 am
philand3 (9/18/2016)
Hi,Yes this is sample.
Please ignore duplicate entries.
ok lets start again......here is some sample data that covers your possible permutation.....based on what I think I undestand so far.
if...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
September 18, 2016 at 9:52 am
philand3 (9/18/2016)
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...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
September 18, 2016 at 7:26 am
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...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
September 18, 2016 at 7:05 am
philand3 (9/18/2016)
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...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
September 18, 2016 at 6:18 am
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...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
September 18, 2016 at 5:54 am
philand3 (9/18/2016)
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...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
September 18, 2016 at 4:46 am
"Is there a way to do this without using a cte or temp table"...please explain why you have these restrictions
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
September 16, 2016 at 7:57 am
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
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
September 16, 2016 at 1:47 am
jansub07 (9/16/2016)
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
September 16, 2016 at 1:17 am
vs.satheesh (9/14/2016)
Thank You for replay.My client using SQL server 2005 . This Query not working sqlserver 2005.
would have been useful if you had posted the error message.....heyho.
try this instead of...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
September 15, 2016 at 4:13 am
Viewing 15 posts - 361 through 375 (of 2,452 total)