Are those columns indexed?  If so - then most likely the reason for the issue is that SQL Server is performing logical consistency checks on the spatial indexes and that...

The code here isn't for SQL Server - it looks like it might be for MySQL.  This forum is for Microsoft SQL Server - you would probably get a better...

You can use OUTER APPLY to get the value:

 Select f.rptMth
      , f.Buiding
      , f.Unit
  ...

Logins and users have an assigned SID - if they are SQL logins/users it is assigned by that instance, if it is a windows login it is assigned by AD...

Because logins have user mappings, I though that a login had to be mapped to a database user for the person to get those database permissions. Apparently not... having...

Are you rebuilding your indexes every night - for example, through a maintenance plan?  If so - then every page in the database is being updated and therefore needs to...

I did a quick search for that error - it is most likely a permissions issue, but without more information it isn't possible to identify.  It could be a password...

problem is each select statement is coming from different tables. first select statement is form student table, second one is form studentbook and 3rd is from studentarchive.

all tables has...

Reformatting the original query - I was able to reduce your individual steps to this:

 Select std.Name
      , std.StdID
   ...

You can use Power BI Report Server - but it has to be purchased and licensed (of course).  It is separate from SSRS - but can also host standard SSRS...

I am not sure what file you are trying to attach - or how that file is generated.  It seems to me you want to generate the file from a...

How are you creating the file?  That is most likely the problem here - as that process (and SQL Server) would then have a lock on the file.

Are you aware...

sp_help_revlogin creates a script that can be run on the other server to create the logins.  Be aware that it scripts out *all* logins and will attempt to create those...

Declare @tempAddress Table (
        Id int
      , Name1 varchar(10)
      ,...

I also agree with Drew and Jeff - but will also add that using -1 is actually more standard (in my opinion) than using an additional dateadd in the function: