Forum Replies Created

Viewing 15 posts - 2,401 through 2,415 (of 5,109 total)

  • RE: COUNT CASE WHEN

    What do you mean by "get the results into". What is your expected result set?

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: Date showing instead of blank result

    cmw 66135 - Wednesday, December 13, 2017 5:05 AM

    How do I find the datatype. I am only assuming it is a date...

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: Date query in SSRS

    faulknerwilliam2 - Wednesday, December 13, 2017 5:07 AM

    thanks for the very quick reply. Is there a way to include seconds in expression...

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: Date query in SSRS

    First day of previous month:
    =DateAdd("M", DateDiff("M", "01/01/2000", Today())-1, "01/01/2000")
    Last day of previous month:
    =DateAdd("d", -1,DateAdd("M", DateDiff("M", "01/01/2000", Today()), "01/01/2000"))

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: Date showing instead of blank result

    cmw 66135 - Wednesday, December 13, 2017 4:53 AM

    At the moment just the field it is pulling from, I have tried a...

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: Date showing instead of blank result

    If the value is NULL, then SSRS will display a NULL.

    What is the expression in the textbox?

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: Data Driven Subscription Error & Failures URGENT Help needed.

    You say "This error means nothing". What is "this" error? 🙂

    Also, don't forget, we can't run your SQL, we don't have access  to you server or data, so...

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: Are the posted questions getting worse?

    They've release a Python based Command Line Tool now. Not sure we really needed another ones of those. I understood the need for MSOS (at least while no equivalent to...

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: 140 gb log file and 6bg data file how can I shrink log files?

    iimohiuddin - Tuesday, December 12, 2017 12:11 PM

    will it automatically shrink or do I have to run a command to shrink it?

    You'll...

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: How to get TOP ID in query?

    Add an ORDER BY clause. Data inside SQL Server isn't stored in any specific order, it's all a "heap". When you use a TOP 1, without...

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: Conditional CONDITION - CASE in WHERE

    etl2016 - Tuesday, December 12, 2017 11:10 AM

    The above is not working.   Any tuning or alternate way of doing it you could...

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: 140 gb log file and 6bg data file how can I shrink log files?

    iimohiuddin - Tuesday, December 12, 2017 10:18 AM

    The recovery model is Full

    OK, if the recovery model is Full then you need to...

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: 140 gb log file and 6bg data file how can I shrink log files?

    iimohiuddin - Tuesday, December 12, 2017 9:48 AM

    Thanks

    For..? Could you please post what recovery model you're using? We can't help you unless...

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: 140 gb log file and 6bg data file how can I shrink log files?

    jasona.work - Tuesday, December 12, 2017 9:10 AM

    More importantly, is what Thom asked, which is what is your recovery model set to...

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: 140 gb log file and 6bg data file how can I shrink log files?

    iimohiuddin - Tuesday, December 12, 2017 8:43 AM

    We do a full backup every night for this database, no we do not backup...

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

Viewing 15 posts - 2,401 through 2,415 (of 5,109 total)