Thank you all for responding and taking time to help.

Many thanks,

Phil.

__PRESENT

I did try:

SUBSTRING(Name, CHARINDEX('(', Name) +1, CHARINDEX(')', Name) - CHARINDEX('(', Name) -1)

This returned:

Msg 537, Level 16, State 3, Line 1

Invalid length parameter passed to the LEFT or SUBSTRING function.

Thanks,

Phil.

<object id="__symantecMPKIClientMessenger"...

Hi. I am unclear how to update my query to use CROSS APPLY. My query below now returns the value with the ()

(abc.mydomain.com)

SELECT
UserGroup.[Name]As GroupName,
UserGroup.[Description]As GroupDescription,
SUBSTRING(Name,CHARINDEX('(',Name) +0,CHARINDEX(')',Name) -...

Thank you very much. That is perfect. I thank you both for responding.

Phil.

Hi. After upgrade users were removed from groups. I would like to list only the groups names + users that are no longer listed in the Production database but are...

Hi Johan Bijnens. Based on my response to Phil EXCEPT does not return the results I am looking for.

<object id="__symantecMPKIClientMessenger" style="display: none;" data-supports-flavor-configuration="true" data-extension-version="1.2.0.158"></object>__PRESENT

Hi. Thanks for the responses. By compare I mean there are results returned in RestoredDatabase that are not in ProductionDatabase. I want the query to output values from RestoredDatabase that...

Thanks, I am a little rusty!

Phil.

I amended to smallint.

Phil.

Hi. Thanks for the response.

"On a side note, you declare @Size as bigint."

I am showing my lack of understanding 🙂

What would you suggest?

HAVING SUM([FileSize]) /1048576.0 > @Size - This returns...

Doh. it should have been:

HAVING SUM([FileSize]) /1048576.0 > @Size

So I think I am all set.

Feel free to offer a better approach.

Phil.

Thank you all for your expert input. As always greatly appreciated.

Phil.

Thanks very much for your responses. I will amend what i have.

Point duly noted regards using functions in WHERE clause.

Many Thanks,

Phil.

Hi Jeff. I changed my approach and formatted within the SSRS report rather than the code.

SQL query now SUM([FileSize]) AS SumOfFileSize

Many Thanks,

Phil.

--This did the trick
ROUND(SUM(CAST([FileSize] AS BIGINT)/1048576.0),2)) AS [FileSizeMB],  
ROUND(SUM(CAST([FileSize] AS BIGINT)/1073741824.0),2) AS [FileSizeGB]

Thanks,

Phil.