Forum Replies Created

Viewing 15 posts - 1,981 through 1,995 (of 7,191 total)

  • RE: parsing records with empty spaces

    Jeff Moden - Thursday, January 19, 2017 9:06 AM

    John Mitchell-245523 - Thursday, January 19, 2017 9:01 AM

    January 19, 2017 at 9:10 am

    #1923752

  • RE: parsing records with empty spaces

    Goodness, yes, you can't process that with BULK INSERT.  The ideal solution is to get your Unix command changed so that it outputs a file with rows and columns....

    January 19, 2017 at 9:01 am

    #1923747

  • RE: User Permission to view Only View not base tables

    That can't be the full results.  In your query, you are referencing one or more tables in the dbo schema, and yet the dbo schema does not...

    January 19, 2017 at 5:51 am

    #1923673

  • RE: Retrieve Dates from Different Rows

    wenger.noah - Thursday, January 19, 2017 5:35 AM

    Hi,

    I need to retrieve dates (and other fields) from different rows.  How do I accomplish...

    January 19, 2017 at 5:48 am

    #1923671

  • RE: Restore question related to DIFF and FULL

    kevaburg - Thursday, January 19, 2017 4:32 AM

    John Mitchell-245523 - Thursday, January 19, 2017 3:23 AM

    January 19, 2017 at 5:10 am

    #1923661

  • RE: Restore question related to DIFF and FULL

    kevaburg - Thursday, January 19, 2017 3:04 AM

    My answer was based on this statement from the OP....

    I restored a FULL...

    January 19, 2017 at 3:23 am

    #1923638

  • RE: Help with Openquery

    Johan_1975 - Thursday, January 19, 2017 2:56 AM

    Sue_H - Tuesday, January 17, 2017 12:14 PM

    January 19, 2017 at 3:18 am

    #1923637

  • RE: parsing records with empty spaces

    ebooklub - Wednesday, January 18, 2017 10:13 AM

    I have text  data in following format
    ServerName      Server.db             PowerUser   Role
    SERVER1         SERVER1.Test    user1           1
                                                          ...

    January 19, 2017 at 3:12 am

    #1923636

  • RE: COUNTING TIME DIFFERENCE IN YEAR, MONTH, DAYS

    Deny Christian - Thursday, January 19, 2017 1:45 AM

    Dear all, 

    I made the Stored procedure to search Years, Months, days by looping
    @EXP_DATE -->...

    January 19, 2017 at 2:12 am

    #1923622

  • RE: Five Useful SQL Server Management Practices

    matthew.sharkey - Wednesday, January 18, 2017 9:23 AM

    Can you elaborate on some of the risks of backing up to the same server?

    If...

    January 18, 2017 at 9:30 am

    #1923474

  • RE: Need help on cte query

    VSSGeorge - Wednesday, January 18, 2017 8:35 AM

    GilaMonster - Wednesday, January 18, 2017 8:29 AM

    January 18, 2017 at 8:42 am

    #1923452

  • RE: Error converting varchar to date

    You can't do calculations on the fly like that.  Try this:

    DECLARE
        @StartDate date
    ,   @EndDate date;
    SELECT
       @StartDate = DATEADD(day,-15,GETDATE())
    ,...

    January 18, 2017 at 8:22 am

    #1923441

  • RE: Need help to find character in String

    Qira - Wednesday, January 18, 2017 7:54 AM

    Hye,


    SELECT CHARINDEX('A2,C1,C2,C3,D1', '01,02,03,04,05,A1,A2,C1,C2,C3,D1,D2,
    J1,J2,J3,K1,M1,M2,M3,N1,N2,N3,P1,P2,P3,R1,S1,S2,T1,T2,T3,W1,W2,W3') AS [Location]

    Location
    19

    SELECT CHARINDEX('A2,R1,T3,D1', '01,02,03,04,05,A1,A2,C1,C2,C3,D1,D2,
    J1,J2,J3,K1,M1,M2,M3,N1,N2,N3,P1,P2,P3,R1,S1,S2,T1,T2,T3,W1,W2,W3') AS [Location]

    Location
    0

    Why A2,R1,T3,D1 return 0? A2,R1,T3,D1 is...

    January 18, 2017 at 7:59 am

    #1923434

  • RE: Convert hex encoded to text

    PSB - Wednesday, January 18, 2017 5:42 AM

    Hi,

    How do I convert from hex encoded position of thetask...

    January 18, 2017 at 5:48 am

    #1923393

  • RE: sync two database in one database

    elhamazizi5456 - Wednesday, January 18, 2017 5:09 AM

    I don't know how can I insert  new user from  test2 to test3.
    because I...

    January 18, 2017 at 5:20 am

    #1923388

Viewing 15 posts - 1,981 through 1,995 (of 7,191 total)