Click here to Skip to main content
15,122,406 members

Comments by MarcusCole6833 (Top 36 by date)

MarcusCole6833 7-Apr-21 14:23pm View
   
 var query = from d in _context.Documents
                join u in _context.Users on d.UserID equals u.Id
                join p in _context.Positions on u.Id equals p.UserID
                where d.UserID.ToString() == userId 
                select new { d, u,p };


are you asking the SQL equivalent of the LINQ

I would look here for a start here

https://docs.microsoft.com/en-us/sql/relational-databases/performance/joins?view=sql-server-ver15
MarcusCole6833 12-Jan-21 9:34am View
   
np
MarcusCole6833 10-Sep-20 15:38pm View
   
thank you
MarcusCole6833 3-Sep-20 14:14pm View
   
i will work with your changes tonight, thank you Ladies and Gents!
MarcusCole6833 3-Sep-20 14:13pm View
   
thank you
MarcusCole6833 3-Sep-20 14:13pm View
   
thank you
MarcusCole6833 3-Sep-20 14:12pm View
   
thank you
MarcusCole6833 3-Sep-20 14:12pm View
   
thank you
MarcusCole6833 3-Sep-20 14:12pm View
   
thank you
MarcusCole6833 3-Sep-20 12:00pm View
   
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?
MarcusCole6833 18-Jun-20 16:37pm View
   
select distinct country , year
from champions
where country != 'England'
MarcusCole6833 24-Mar-20 12:16pm View
   
would you mind adding my suggestion as the answer?
MarcusCole6833 23-Mar-20 17:50pm View
   
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
MarcusCole6833 23-Mar-20 16:55pm View
   
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?
MarcusCole6833 23-Mar-20 16:11pm View
   
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
MarcusCole6833 23-Mar-20 14:57pm View
   
is the qnty from cumulative you wish to count as a group, then compare to the order list?
MarcusCole6833 23-Mar-20 14:56pm View
   
Deleted
is the qnty from cumulative you wish to count as a group, then compare to the order list?
MarcusCole6833 23-Mar-20 11:07am View
   
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.
MarcusCole6833 5-Mar-20 11:36am View
   
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.
MarcusCole6833 4-Mar-20 15:04pm View
   
Thank you for that!!
MarcusCole6833 12-Feb-20 14:03pm View
   
could yo elaborate some more?
MarcusCole6833 11-Feb-20 14:02pm View
   
a slight learning curve; one of those it works on my machine!!!!!
MarcusCole6833 3-Jun-17 10:52am View
   
a great idea ty
MarcusCole6833 31-Mar-16 23:08pm View
   
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);
}.

MarcusCole6833 21-Mar-16 15:14pm View
   
excuse the late reply, I changed my code and found some simpler js to use
MarcusCole6833 22-Jan-16 12:21pm View
   
works in VB as Well
MarcusCole6833 23-Dec-15 14:10pm View
   
Thank you for your help!
MarcusCole6833 23-Dec-15 9:49am View
   
I have added a little to the above in relation to your question
MarcusCole6833 22-Dec-15 12:58pm View
   
clerical error in the cut and Paste I will correct! (I sound like Gloria Gaynor)
MarcusCole6833 10-Nov-15 12:51pm View
   
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
MarcusCole6833 10-Nov-15 12:50pm View
   
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
MarcusCole6833 29-Oct-15 12:37pm View
   
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!
MarcusCole6833 27-Oct-15 16:48pm View
   
TY for the alternative Fix!
MarcusCole6833 27-Oct-15 15:24pm View
   
No Probs!
MarcusCole6833 27-Oct-15 13:40pm View
   
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!
MarcusCole6833 1-Sep-15 13:01pm View
   
I realize that now!