This is a basic design mistake that many folks make.  OTLT (One True Lookup Table)  is typically a very poor construct and far too often causes one big set of...

Keep in mind: Not just any kind of Azure BLOB storage! It needs to be V2 ! ( or newer )

And you have to remove these files yourself !...

I've recently started intermittently getting this error message after changing the password on the account the runs the SQL service. That particular account is also a sysadmin in SQL...

If this is a "timing issue", then snapshot isolation is not going to solve the issue.  And, in a synchronous commit availability mode, the data is committed to the secondary...

Actually, it works in the...

Yes... it's a bit more complicate than using BETWEEN especially when you have to use a conversion but... it's a habit to get into that will "save your life" someday. ...

Your original post asked for records that fall between...

• This reply was modified 3 years, 6 months ago by Michael L John.

Yeah.  There was a very large "DUUUUUUUUUUUUUUUUUHHHHHHHHHHHHH" this morning.

After I replied to the Johan, I figured out what my stupidity was.  There are only...

I ran through a series of grant perms and none of them...

Can you post what you tried? It's far easier us, and more beneficial to you, if we can see that and use it to teach you.

Hi all! Sorry for the dumb questuon, but I did not find any answer on ms or stackoverflow. I know that for installing ths sql server, I need admin...

What have you tried?  This is actually a very simple query.

Have you looked at the various tools available in SQL related to dates and times?

https://docs.microsoft.com/en-us/sql/t-sql/functions/date-and-time-data-types-and-functions-transact-sql?view=sql-server-ver15

It appears that all of the values are either float or int types.

Unless you are dealing with astronomical sized numbers, I would recommend removing the float types. They are called...

CursorID.IndexSite is incorrect syntax

Your select statement 22 columns, and you are fetching into a single variable.

It also appears that you are attempting to create a series of views named "v"...

I'm curious. I've had to keep old servers alive for various "historical" reasons, but they never were active unless someone needed a report out of them.  They sat in a...