Comments by MarcusCole6833 (Top 36 by date)

thank you

thank you

thank you

thank you

this is the first time I used the picture box, I work in a factory and generally do not need it.

pBxExercise.ImageLocation = iFileLoc;

The above code does not cover hte image source, as I did not find a property of image source?

select distinct country , year
from champions
where country != 'England'

would you mind adding my suggestion as the answer?

loop values ok here where we start

we have distinct values in the temp table with an incremental id


so we choose a min and max value as are counters for the loop

in the loop we need a part id and result to get hte summed values

below is a blue proint for that

I laid off the code solution as I thought this was homework, and that is why I might have been a bit opaque with my answers but reading your last reply you are doing something similar to me on a daily basis

select @min - min(id), @max = max(id) from @t
declare @cproj varchar(20)
declare @sum int = 0
while @min <= @max
begin

select @cproj = cprof from @t where id = @min

select @sum = sum(qnty) from comparative where cproj = @cproj

update @t set cCount = @sum where id = @min
set @min = @min + 1

end

it is not the simplest thing to do, is get a set value in one table that is cumulatively held in another table then run logic against this. Do you not have a more Senior Developer helping you?

declare @t table (id int identity(1,1), cprojID varchar(20), countC int , CountE int)
select distinct cproj , 0, 0
from cumulative
inner join order entry on cproj = cproj

from here you can loop in the totals

update t
set countE =

TotalRowCount	or DWRowCount

inner join order entry on t.cproj = oe.cproj

use a loop to then go over each croj id and do a count per id in the cumulative table

from this temp table where countc == count E run the remainder of the insert and deletion logic

is the qnty from cumulative you wish to count as a group, then compare to the order list?

use the table variable to create a record of where you have a condition. Then you use this temp table as a reference for the remainder of steps. The reason I did not add any extra code or conditional logic was I could not work out what was meant to match in each tables.

Going off what was said earlier, if you know your data could you break it down into smaller parts passing between temp table or ctes and code it out on a step by step basis? The reason I say this is the large group by (as stated) and te mass of column values derived by sub query's.

Thank you for that!!

could yo elaborate some more?

a slight learning curve; one of those it works on my machine!!!!!

a great idea ty

All you are doing is collecting data the start time end time and break time, you need to create a function that accepts the end start and break times and then returns the total as a string.
private string total(x, y , z )

{
x - y - z = t;
return cstr(t);
}.

excuse the late reply, I changed my code and found some simpler js to use

works in VB as Well

Thank you for your help!

I have added a little to the above in relation to your question

clerical error in the cut and Paste I will correct! (I sound like Gloria Gaynor)

ty on the input this is how I used the code from the answer

http://www.codeproject.com/Articles/1053368/Using-Lists-to-make-an-Anagram-Application

cheers for your code here is how I used at least part of it

http://www.codeproject.com/Articles/1053368/Using-Lists-to-make-an-Anagram-Application

Ty for the help, my major issue was running it locally and the Ajax calls, but any extra insight is never unwarranted or unnecessary as we are always constantly learning, thank you for your help!

TY for the alternative Fix!

No Probs!

As to Clarify I wanted the Anagram to keep the spacing of the original word; so If I pit the title 'The Great Escape' it would come back as text in this format 'xxx xxxxx xxxxxx'. i apologize for the lack of clarity, and Bill TY for your piece of LINQ!

I realize that now!