For over 30 years, the convention on SQL forums has been to post DDL (so we know what the keys are the datatypes of columns, any important constraints, etc.) and...

Please do a little research. There is an ISO 8601 standard for week numbers within a year. It's very popular in Scandinavian countries, and you can find lots of calendars...

Everything you posted is horrible and needs to be redone. IDENTITY is a table property and cannot be used as a key. You have more NULLs in this one table...

Let us try to clean up your code and help you build good habits since you are new to this. First of all, a table must have a key and...

The first thing we need to do is get some valid DDL. Your singular table name indicate you have only one Rate. I’m pretty sure that’s not true. The vehicle...

Your approach to SQL is wrong. This is a declarative language but you are writing code as if you were still doing Fortran with file systems. Instead of scratch tapes,...

I think I'll go to the other extreme. I am waiting for eye surgery right now, so there will be a little delay, but I will develop an article for...

You've made the usual beginner's mistake of confusing a table with a 1950s file system. We have had the daytime2(n) datatype for several years now, so there's no need to...

>> I am trying to add week number by month so Feb would have weeks 1 -4, March 1-5 etc. <

Build a calendar table.

First, look up the ISO 8601 standards...

>> I have a select statement below which gives the expected results of duplicate data. <<

I hate to tell you this, but in RDBMS "expected results of duplicate data" is...

CREATE TABLE Timesheet

(user_id..,

etc, UNIQUE (user_ifd,login_timest),

login_timestamp DATTIME2(7) NOT NULL,

logout_timestamp DATTIME2(7),

CHECK(login_timestamp <=logout_timestamp),

);

The unit of work is a period of time which you are logged in. The duration is defined by a starting...

This old article might be useful to you:

https://www.red-gate.com/simple-talk/databases/sql-server/t-sql-programming-sql-server/state-transition-constraints/

And this is why we want posters to always put the DDL for their tables where we can see them. After 30+ years of doing SQL and RDBMS, I would...

I am assuming that the foobars have a key made of the foo_description in the foo_id.

SELECT foobar_id

FROM Foobars

WHERE foobar_description IN ( 'Apex', 'Bill', 'Sierra' )

GROUP BY foobar_id

HAVING COUNT (*) =...

Please quit being rude to people that are trying to help you. Where is the DDL? If you remember the first week of any class or chapter of any book...