reading the documentation does help.

Link posted before on this thread

https://docs.microsoft.com/en-us/sql/ssdt/download-sql-server-data-tools-ssdt?view=sql-server-ver15

Not only this contains instructions for 2019 but it also has, quite visible, a link to previous versions.

if you output onto a file or to text it should give you the desired result

if you are querying on SSMS to the grid it will remove those.

do you have or can you create a calendar table that contains the weekday for each date?

that would make giving you an easier example rather than having to build it...

you need to provide a lot more detail - as you aren't doing any explicit conversion I assume that either A1.Entry is a date/datetime or test3.bref is - and the...

• This reply was modified 5 years ago by frederico_fonseca.

nope - even if you don't upgrade yourself, the engine will do that on the fly - and will fail for same reason.

you need to figure out a way to...

that has another few views within it - need those also

when you are querying this view are you applying any filtering or just doing a select * from view without...

The main difference between PowerBI & SSRS are the datasets.  An SSRS report runs the dataset each time the report is invoked.  PowerBI caches the data from the first...

that is a straight basic sql with a top 1, a where clause and a order by. - either assign to a variable and check the contents of the variable...

and if that view uses other views post the definition of those also.. recursively

It would decrease use of tempdb and increase usage of what ever db you put those tables on.

might be worth seeing if those temp tables can be redone so size...

can you post table and indexes ddl for that table.

if you need to add a trace flag you do it through configuration manager so it is there whenever the instance starts.

net start does not support parameters - it will...

you need 'tempdb..#xxx' when checking for object existence.

e.g. if object_id('tempdb..#xxx') is not null drop table #xxx;

other than the case above you do not need to reference tempdb.. and you can...

following will help.

1 - get ride of those nolock

if you really have to use them and your business signs off on the possibility of having bad data being supplied to...

• This reply was modified 5 years ago by frederico_fonseca.

one question that may help this.

why so many updates? and how are they being done - SQL please, not just explaining.

and potentially why aren't some being done as part of...