Hi thanks for your help, that seems to be working I did receive duplicate profiles again but I managed to resolve that by using DISTINCT on my select statement.

Question...

Hey,

I can't provide any code, as I haven't got that far yet.

I have built my UserSettings table where by I will be comparing the values between this table and the...

Arrr I see!! that would explain a lot 🙂

Also as you can see im rounding it would Ceiling be the best approach to round? or would it be wise using...

what I'm basically doing is populating the geo column based on the latitude and longitude which belongs to each row, that way I'd have the lat, long and geo data....

Hey patrickmcginnis59 10839

Thanks for your suggestion, I can do it the way you suggested but I have 11913 rows in my table so writing out insert statements for each one...

I need the where statement to specify the profile picture because the user can upload ten pictures if I remove the where statement I get x amount of records per...

Hi Sean,

Thanks for your response, we have changed the way we insert/update the activities now, instead from the UI when the user deletes one we call a ajax method which...

Can someone help me with this please

Ok I think im nearly there, this is my code

MERGE [User].[User_Activities] AS ua

USING (SELECT Id FROM [Fitness].[Activities]) AS f

ON ua.Id = f.Id

WHEN MATCHED THEN UPDATE SET...

Ok, would you be able to show me a small example I've googled this but my knowledge on Sql and it's syntax is very limited

You're speaking to someone that has minimal SQL exposure, I no the basics but when it comes to designing/learning a good database design I would require further explanation in to...

It will be a variety of different queries ranging from select, update, delete, inner joins to relevant tables to get descriptions, displaying any adverts to user that are recommended depending...

The link you provided keeps coming up as bad request?

Regarding option three though how would performance be when we have more then 50k records in the DB do you...

Hi guys sorry for keeping you waiting. I created a fiddle for this but forgot to update the post, please feel free to test using it.

sqlfiddle.com/#!2/dce89d

I haven't tested your queries...

List the lane for the missing period regardless of any activity.

Thanks