wrap the dates in a convert/cast function using a format code

eg

CONVERT(DATE,MAX(DATE),103)

CAST(MAX(DATE),DATE,103)

please do not cross post

all replies here please

Might need a bit of work to get it to how you want it, but the basis is the same

DECLARE @sql NVARCHAR(MAX)

SELECT @sql = REPLACE(

CAST(

(

SELECT 'USE ' + QUOTENAME(name) +';'...

you will need business intelligence development studio installing on your machine to develop the RDL files, this can be installed via the SQL media if not already done so

you will need to create an expression on the remote path something like the following, changing it to suit your needs

(DT_WSTR, 4) YEAR( GETDATE() ) + right("0" +...

yes it is possible as permissions are cumulative.

as you already know the groups to which the user has access too, check that these groups cannot delete data. Also they...

the leaf node is the bottom level of the tree which is the data pages, unless you mean something else?

changes the table to a heap

queries will cause table scans

non clustered indexes will cause a lookup scan

as it has to look through all of the data pages to find the...

please do not cross post

all replies here please

what is the reasoning behing dropping the clustered index?

you will need to build an expression in the ordering of the tablix based on the parameter values

something like

=IIF(Param!Item1.Value=True, Item1, IIF(Param!Item2.Value = True, Item2..............) untill all possible combinations of...

would also have to build in a call to UPDATE() as well to ensure that it only fires on the update of a specific column

CREATE TRIGGER trigger

ON Schema.Table

AFTER UPDATE

AS

IF (UPDATE...

well you learn something new every day, I didnt think this was possible

4DayWeek 😀

nope, you will need to fully reinitialise logshipping from scratch with a new full backup for the changes to take effect, you cant do this (below) as you cannot modify...