Forum Replies Created

Viewing 15 posts - 3,271 through 3,285 (of 5,109 total)

  • RE: Importing a Long named Excel Sheet with Spaces

    anthony.green - Thursday, August 17, 2017 8:11 AM

    Don't you need to add a ending cell number as you cant go up to...

    Thom~

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

  • RE: Time increments

    Oh a 4 day Scenario. Give this a go instead:
    WITH RNs AS(
      SELECT *, ROW_NUMBER() OVER (PARTITION BY FieldSort1, StartDate ORDER BY FieldSort1, FieldSort2, FieldSort3) AS...

    Thom~

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

  • RE: Extract New Members from Gridview

    respuzy - Thursday, August 17, 2017 6:05 AM

    Thanks Chief, i just tried it didnt work, i want to try and explain...

    Thom~

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

  • RE: Extract New Members from Gridview

    This is so much a SQL question, but more C#, so I'm not sure how much of a useful response you'll get here (as a SQL Server forum).

    If,...

    Thom~

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

  • RE: Time increments

    PSB - Wednesday, August 16, 2017 10:45 AM

    Thanks. Works good except for a few . For some cases , where it passes...

    Thom~

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

  • RE: SQL server 2014 SSIS package execution using job Error

    Phil Parkin - Wednesday, August 16, 2017 10:16 AM

    Any time that an SSIS job works in SSDT, but not in SQL Agent,...

    Thom~

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

  • RE: SQL server 2014 SSIS package execution using job Error

    That doesn't really help clarify a lot here. Could you post the VB Script? Please ensure your encapsulate it in IF Markup so that it is easily readable. How are...

    Thom~

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

  • RE: Login failed password did not match for SQL loin

    Arsh - Wednesday, August 16, 2017 9:04 AM

    Are u able to connect using the local SSMS with other users ? If not...

    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?

    Brandie Tarvin - Wednesday, August 16, 2017 8:15 AM

    Sniff. But I like screwing with people's code... And dropping databases and unplugging...

    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?

    Lynn Pettis - Wednesday, August 16, 2017 7:56 AM

    This could be related to certain posts here or to people with whom I...

    Thom~

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

  • RE: Can I restore a single file .mdf to multiple files spread across disks

    aaron.reese - Wednesday, August 16, 2017 4:46 AM

    would love to but our network is screwed down so tight there isn't a drive...

    Thom~

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

  • RE: Can I restore a single file .mdf to multiple files spread across disks

    Why not create your Backup on a different location to your server and restore from there instead? A separate SAN, a Network location, or even an External (USB) Drive would...

    Thom~

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

  • RE: Login failed for user' has occurred in SSMS

    What are the error messages in the SQL Server's logs? When using sqlcmd and SSMS are you using the same credentials? Same User? Both Integrated Security/SQL Login? It might be...

    Thom~

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

  • RE: Group by select

    As pietlinden suggested, you should really rad the topic on how to post T-SQL questions on this forum. It makes things a lot easier for us, as we don't need...

    Thom~

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

  • RE: SQL Update with Subquery

    reggiete - Tuesday, August 15, 2017 9:38 AM

    Hello All,

    I have the below statement and when it runs it just makes the...

    Thom~

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

Viewing 15 posts - 3,271 through 3,285 (of 5,109 total)