Forum Replies Created

Viewing 15 posts - 3,466 through 3,480 (of 5,109 total)

  • RE: Get total user session with client IP address

    Using the newer views, that John suggested:
    USE master;
    GO

    SELECT GETDATE() AS date_time,
           d.[name] AS DBName,
           COUNT(c.connection_id) AS Connections,
     ...

    Thom~

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

    July 20, 2017 at 8:23 am

    #1951857

  • RE: SSDT Execute SQL task is not resolving parameters

    Phil Parkin - Thursday, July 20, 2017 6:16 AM

    If Thom's solution does not work directly in an ExecuteSQL task, with ? parameters,...

    Thom~

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

    July 20, 2017 at 6:20 am

    #1951812

  • RE: SSDT Execute SQL task is not resolving parameters

    What you're trying to do there is use a variable to declare a schema and table name. The SQL you're attempting to run would basically translate into something like:
    DECLARE...

    Thom~

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

    July 20, 2017 at 1:53 am

    #1951790

  • RE: Are the posted questions getting worse?

    Steve Jones - SSC Editor - Wednesday, July 19, 2017 9:57 AM

    Thom A - Wednesday, July 19,...

    Thom~

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

    July 20, 2017 at 1:37 am

    #1951789

  • RE: Cannot deploy to SSISDB

    Phil Parkin - Wednesday, July 19, 2017 9:13 AM

    Thom A - Wednesday, July 19, 2017 9:00 AM

    Thom~

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

    July 19, 2017 at 12:10 pm

    #1951720

  • RE: Next Quarter Dates

    meichmann - Wednesday, July 19, 2017 11:58 AM

    I did and got it, thanks

    Glad to hear it!

    Thom~

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

    July 19, 2017 at 12:08 pm

    #1951719

  • RE: Cannot deploy to SSISDB

    Phil Parkin - Wednesday, July 19, 2017 8:52 AM

    Tough one. That error message could be more helpful.

    Are any of the packages in...

    Thom~

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

    July 19, 2017 at 9:00 am

    #1951663

  • RE: Next Quarter Dates

    meichmann - Wednesday, July 19, 2017 8:27 AM

    Nope, it works fine:) :

    [/quote]

    Yep, you're right, my bad date math....

    Thom~

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

    July 19, 2017 at 8:35 am

    #1951653

  • RE: Next Quarter Dates

    meichmann - Wednesday, July 19, 2017 8:19 AM

    I got it....

    Dateadd(DateInterval.Day, -1, DateAdd(DateInterval.Quarter, DateDiff(DateInterval.Quarter, CDate("01/01/2000"), Today()) +2, Cdate("01/01/2000")))

    Thanks for your help!!! 🙂

    Should...

    Thom~

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

    July 19, 2017 at 8:23 am

    #1951647

  • RE: update column based on max date for each employee

    ChrisM@Work - Wednesday, July 19, 2017 7:51 AM

    ;

    Thom~

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

    July 19, 2017 at 8:02 am

    #1951639

  • RE: Cannot deploy to SSISDB

    Phil Parkin - Wednesday, July 19, 2017 7:55 AM

    Does the target server version of the SSIS project match the target server?

    Yes. The...

    Thom~

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

    July 19, 2017 at 7:59 am

    #1951637

  • RE: Cannot deploy to SSISDB

    Phil Parkin - Wednesday, July 19, 2017 7:49 AM

    I assume you've checked disk space on the live server, plus any limits on...

    Thom~

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

    July 19, 2017 at 7:56 am

    #1951635

  • RE: Next Quarter Dates

    meichmann - Wednesday, July 19, 2017 7:27 AM

    Thom A - Wednesday, July 19, 2017 7:21 AM

    Thom~

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

    July 19, 2017 at 7:52 am

    #1951632

  • RE: Are the posted questions getting worse?

    Thom A - Wednesday, July 19, 2017 7:02 AM

    Anyone having problems creating topics? I'm trying to post one and it just sits...

    Thom~

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

    July 19, 2017 at 7:41 am

    #1951626

  • RE: Cannot deploy to SSISDB

    For some reason i can't make topics on my PC anymore, nor can i put the below in the actual topic's post. So the above is just a holding psot,...

    Thom~

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

    July 19, 2017 at 7:35 am

    #1951623

Viewing 15 posts - 3,466 through 3,480 (of 5,109 total)