Forum Replies Created

Viewing 15 posts - 1 through 15 (of 541 total)

  • Reply To: Return string between parentheses

    Thank you all for responding and taking time to help.

    Many thanks,

    Phil.

    __PRESENT

    -------------------------------------------------------------------------------------
    A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."

    Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '

    Tommy Cooper

    August 1, 2024 at 5:56 am

    #4441585

  • Reply To: Return string between parentheses

    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"...

    -------------------------------------------------------------------------------------
    A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."

    Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '

    Tommy Cooper

    July 31, 2024 at 3:13 pm

    #4441457

  • Reply To: Return string between parentheses

    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) -...

    -------------------------------------------------------------------------------------
    A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."

    Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '

    Tommy Cooper

    July 31, 2024 at 3:10 pm

    #4441455

  • Reply To: Compare query results between two databases

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

    Phil.

    -------------------------------------------------------------------------------------
    A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."

    Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '

    Tommy Cooper

    July 30, 2024 at 10:26 am

    #4440956

  • Reply To: Compare query results between two databases

    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...

    -------------------------------------------------------------------------------------
    A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."

    Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '

    Tommy Cooper

    July 30, 2024 at 9:59 am

    #4440951

  • Reply To: Compare query results between two databases

    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

    -------------------------------------------------------------------------------------
    A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."

    Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '

    Tommy Cooper

    July 30, 2024 at 8:41 am

    #4440938

  • Reply To: Compare query results between two databases

    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...

    -------------------------------------------------------------------------------------
    A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."

    Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '

    Tommy Cooper

    July 30, 2024 at 8:37 am

    #4440937

  • Reply To: SSRS Query - Allow user to specify size

    Thanks, I am a little rusty!

    Phil.

    -------------------------------------------------------------------------------------
    A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."

    Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '

    Tommy Cooper

    February 1, 2022 at 6:48 pm

    #3979688

  • Reply To: SSRS Query - Allow user to specify size

    I amended to smallint.

    Phil.

    -------------------------------------------------------------------------------------
    A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."

    Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '

    Tommy Cooper

    February 1, 2022 at 11:38 am

    #3979533

  • Reply To: SSRS Query - Allow user to specify size

    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...

    -------------------------------------------------------------------------------------
    A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."

    Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '

    Tommy Cooper

    February 1, 2022 at 11:32 am

    #3979527

  • Reply To: SSRS Query - Allow user to specify size

    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.

    -------------------------------------------------------------------------------------
    A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."

    Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '

    Tommy Cooper

    February 1, 2022 at 10:10 am

    #3979505

  • Reply To: Data not returned in Date Range WHERE

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

    Phil.

    -------------------------------------------------------------------------------------
    A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."

    Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '

    Tommy Cooper

    January 28, 2022 at 9:48 am

    #3978251

  • Reply To: Data not returned in Date Range WHERE

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

    Point duly noted regards using functions in WHERE clause.

    Many Thanks,

    Phil.

    -------------------------------------------------------------------------------------
    A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."

    Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '

    Tommy Cooper

    January 27, 2022 at 8:24 pm

    #3978051

  • Reply To: Report Format - Not rounding to 2 Decimal Places

    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.

    -------------------------------------------------------------------------------------
    A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."

    Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '

    Tommy Cooper

    January 27, 2022 at 4:43 pm

    #3977980

  • Reply To: SUM(CAST(.... 

    --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.

    -------------------------------------------------------------------------------------
    A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."

    Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '

    Tommy Cooper

    January 25, 2022 at 3:18 pm

    #3977016

Viewing 15 posts - 1 through 15 (of 541 total)