Forum Replies Created

Viewing 15 posts - 1,471 through 1,485 (of 15,381 total)

  • RE: Run a query to update lat/long

    pmb88 (6/7/2016)


    Here is my table:

    DECLARE @Locations table(

    [LocID] [int] IDENTITY(1,1) NOT NULL,

    [Location_Name] [varchar](64) NULL,

    [Address] [varchar](60) NULL,

    [City] [varchar](40) NULL,

    [State] [char](2) NULL,

    [Zip] [varchar](10) NULL

    [Latitude] [decimal](9, 6) NULL,

    [Longitude] [decimal](9, 6) NULL

    )

    How can I use...

  • RE: Run a query to update lat/long

    pmb88 (6/7/2016)


    For the site I want to use a google map which will plot all the available locations on the map. The issue is that this is not a new...

  • RE: Interview Questions

    ChrisM@Work (6/7/2016)


    Sean Lange (6/7/2016)


    ChrisM@Work (6/7/2016)


    Sean Lange (6/7/2016)


    Luis Cazares (6/7/2016)


    Try this:

    SELECT sys.fn_get_folder(path, 1)

    LOL that is hilarious Luis. And it seems to have fooled Lowell and Chris too. That is too funny.

    Haven't...

  • RE: Interview Questions

    ChrisM@Work (6/7/2016)


    Sean Lange (6/7/2016)


    Luis Cazares (6/7/2016)


    Try this:

    SELECT sys.fn_get_folder(path, 1)

    LOL that is hilarious Luis. And it seems to have fooled Lowell and Chris too. That is too funny.

    Haven't you got one...

  • RE: Interview Questions

    Jeff Moden (6/7/2016)


    Eric M Russell (6/7/2016)


    They're asking the wrong type of questions for a job interview.

    I think it's a great question. It shows whether or not you actually know...

  • RE: Interview Questions

    Luis Cazares (6/7/2016)


    Try this:

    SELECT sys.fn_get_folder(path, 1)

    LOL that is hilarious Luis. And it seems to have fooled Lowell and Chris too. That is too funny.

  • RE: Beginning a CTE

    tom.w.brannon (6/7/2016)


    The answer should be No. Open a new window and paste in the following and it works just fine:

    with myCTE(n)

    as

    (select 1

    )

    select * from myCTE

    No semicolons anywhere in the...

  • RE: Are the posted questions getting worse?

    WayneS (6/6/2016)


    Ed Wagner (6/6/2016)


    WayneS (6/6/2016)


    PRO TIP:

    If you're depending on an email notification to warn you when a backup fails, lack of receiving the email doesn't mean that the backup succeeded.

    That...

  • RE: Beginning a CTE

    John Mitchell-245523 (6/6/2016)


    Sean Lange (6/6/2016)


    And let's consider the table valued function that uses a cte. If you slap a semicolon at the beginning doesn't that now make what could have...

  • RE: Beginning a CTE

    And let's consider the table valued function that uses a cte. If you slap a semicolon at the beginning doesn't that now make what could have been an inline table...

  • RE: Are the posted questions getting worse?

    Ed Wagner (6/3/2016)


    Sean Lange (6/3/2016)


    The end of this week is almost here. This is a major milestone week at our company. We have been working for over 2 years on...

  • RE: Are the posted questions getting worse?

    The end of this week is almost here. This is a major milestone week at our company. We have been working for over 2 years on implementing a new ERP...

  • RE: Beginning a CTE

    I call foul on this one. The only correct answer is "No Never". As Lynn has ranted before "the semi-colon is NOT a statement beginninator, it is a statement terminator"....

  • RE: Are the posted questions getting worse?

    jasona.work (6/2/2016)


    I read this and suddenly felt millions of DBAs cry out in horror...

    (Yes, it's the Daily WTF, scarily it might even be (mostly) true)

    ROFL. That is awesome. I wouldn't...

  • RE: Certificate

    Great question. I couldn't find the answer that I "knew" was correct so I had to read the question a couple more times until I realized you stated you created...

Viewing 15 posts - 1,471 through 1,485 (of 15,381 total)