For those that don't want to download the file (formatting courtesy of SSC paste interpreter):
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE PROCEDURE...

Certainly think that 2019 is probably the year I start looking at my career. It's quite a big step for me, as where I'm working now is where I truly...

I'm sorry, but I really have no idea what you are trying to say here. What do you mean by "Special characters"? What special characters? Considering that you stated the...

Looking forward to it Steve, hopefully things will go as smoothly as they can.

Thanks Evgeny. I didn't actually know there was a NEWSEQUENTIALID() function. I tend to use IDENTITY, however, there are times when a GUID would be "better";...

When you say "it doesn't work", what do you mean? Do you get an error, unexpected results, Excel crashes..? Ideally, if you can, provide your datas DDL and DML statements...

Yes, it's possible. Have you have a look at the visibility options in SSRS? If you haven't, you'll probably quickly see how to do it; there's an option in there...

By TSQL do you mean a database? Are you looking for a project or the acutal database (which are 2 very different things). You have the AdventureWorks and WideWorldImporters databases,...

People are unlikely to download your rar file. Rather than uploading a (potentially harmful) file, include the script in the in text of your post. Could you also include yours...

This post reads very much like a homework question. I assume you have tried to answer these yourself? Almost all of these questions are impossible to answer with the vague...

Please don't post the same question in 3 different forums. Direct answers to this post here: https://www.sqlservercentral.com/Forums/2014435/Can-you-help-me-on-this