I have created a Scalar-valued Function and called this from within my view - basically the join that I perform on the non-index fields I have removed from my...

The first view holds circa 1500 records and returns circa 2200 through a second cte view.

The data is consistently refreshed throughout the working day - eg. every 5 minutes...

Hi,

Thanks for getting back. There is no connection between [Owner],[PersonAttending],[Type] columns.

1. While Owner column can be blank and [PersonAttending],[Type] still have values.
2. Owner (different people than [PersonAttending]) <> [PersonAttending]...

There is a concern with using CONCAT to safety the string.  If that string is varchar(8000) - and the data length is 8000 - this can and will fail with...

So what problems are you having adding the additional steps?  Pretty simple to add a copy/move step to backup (archive) the file - and getting the count of rows in...

Here is a little different take on the solution:

 Select [Code]        = ltrim(substring(v.Item, 1, p01.pos - 2))
   ...

• This reply was modified 4 years, 4 months ago by Jeffrey Williams.

I just checked the solution using TOKEN and my solution is almost a mirror of Jeffrey's:

left(token( @[User::strDate],".",3),4) + "-" + token( @[User::strDate] , ".", 2)...

I see a couple of options:

1. Use SSIS to modify the string to match the format expected in SQL Server.  The ideal format would be a non-ambiguous format such as...

Or - it is the default database set in the connection string.  How are these users connecting to the system - and what application are they using?  Are they attempting...

You don't create a table - and you don't create a table with delimited items in a single column like this.  If you need a dynamic cross-tab/pivot then build a...

What data would be contained in [DATA], and how would this table be used?

I would probably switch that to a view with a fixed pivot/cross-tab of all possible salary components. ...

That is the version of SSRS - which may or may not be the same as the source system where you are getting the data.  The dataset is configured with...

According to this - it was removed and they have not added it back: https://feedback.azure.com/forums/908035-sql-server/suggestions/32896402-bring-back-tfs-and-git-in-ssms?page=2&per_page=20

Of course, their recommendation is to either use SSDT for source control - or you can...

Use the Try/Catch from my sample code - then check to see what the error is when it fails.

It appears you don't have access to the database system - only SSRS.  Not sure the tool recognizes the difference between date and datetime so that isn't really a way...