Forum Replies Created

Viewing 15 posts - 181 through 195 (of 626 total)

  • RE: Is it possible to query azure db from portal?

    You used to be able to do that via your web browser following this URL format: "https://[servername].database.windows.net".

    However, I haven't been able to do that in a long time since I...

    SELECT quote FROM brain WHERE original = 1
    0 rows returned

    October 3, 2016 at 1:20 pm

    #1904532

  • RE: Are the posted questions getting worse?

    Luis Cazares (10/3/2016)

    jasona.work (10/3/2016)

    Ugh...

    Those of you in the US might have heard about the "creepy clowns" that seem to be popping up all over the place, especially the one down...

    SELECT quote FROM brain WHERE original = 1
    0 rows returned

    October 3, 2016 at 11:20 am

    #1904488

  • RE: How to get the previous weeks data based on week ending

    NineIron (10/3/2016)

    The results of this query show weeks ending for 5/14, 5/21, 5/28. None of these are Fridays. Also, there seem to be multiples. Any thoughts?

    Have you tried John's solution?...

    SELECT quote FROM brain WHERE original = 1
    0 rows returned

    October 3, 2016 at 11:17 am

    #1904484

  • RE: How to get the previous weeks data based on week ending

    Are you trying to get an overall weekly count or count per day in a week? If you just need a weekly count (assuming discharge date based on...

    SELECT quote FROM brain WHERE original = 1
    0 rows returned

    October 3, 2016 at 7:56 am

    #1904404

  • RE: Today's Random Word!

    Grumpy DBA (9/29/2016)

    djj (9/29/2016)

    Manic Star (9/29/2016)

    Ray K (9/28/2016)

    Manic Star (9/28/2016)

    Ponyta (the pokemon)

    Picachu

    Bless You.

    Thank You (my thought was bless you but I did not post :cool:)

    Grazie

    Gracias

    SELECT quote FROM brain WHERE original = 1
    0 rows returned

    September 29, 2016 at 9:19 am

    #1903977

  • RE: Multiple row data need to be convert as Coloumn

    pavanpala.vja (9/29/2016)

    HI Y.B,

    Please find the desired output which we looking for.

    In your example you are disassociating your dates with the error codes. This leads me to believe that you...

    SELECT quote FROM brain WHERE original = 1
    0 rows returned

    September 29, 2016 at 8:49 am

    #1903971

  • RE: make over columns using comma seperated and select in query

    mcfarlandparkway (9/28/2016)

    Okay.

    Here is the thing.

    The data looks like from emp1,emp2 and emp3 as

    DOM1000108806-00110

    Here DOM is constant - this will not change

    before hifen the data belongs to emp1

    next 3 digits hifen...

    SELECT quote FROM brain WHERE original = 1
    0 rows returned

    September 28, 2016 at 1:06 pm

    #1903763

  • RE: Multiple row data need to be convert as Coloumn

    To help others who are trying to help you here is how you should post it in the future. Note I changed your DDL to declare a table variable...

    SELECT quote FROM brain WHERE original = 1
    0 rows returned

    September 28, 2016 at 9:52 am

    #1903703

  • RE: Are the posted questions getting worse?

    Phil Parkin (9/22/2016)

    Anyone in the mood for a quick code tidy-up?

    ...and I thought code generated by Entity Framework was bad!

    SELECT quote FROM brain WHERE original = 1
    0 rows returned

    September 22, 2016 at 1:49 pm

    #1902635

  • RE: Email alerts when server reboots

    richard.bowles (9/22/2016)

    Look for a procedure that runs at startup:

    SELECT ROUTINE_NAME

    FROM MASTER.INFORMATION_SCHEMA.ROUTINES

    WHERE OBJECTPROPERTY(OBJECT_ID(ROUTINE_NAME),'ExecIsStartup') = 1

    Yeah, good thing to check...a proc could have been set to start using the 'sp_procoption' procedure.

    SELECT quote FROM brain WHERE original = 1
    0 rows returned

    September 22, 2016 at 12:10 pm

    #1902597

  • RE: Email alerts when server reboots

    lcarrethers (9/22/2016)

    I guess i'm a bit confused. I don't have any jobs, I have lots of jobs that have this but they are all replication

    It could be a 3rd...

    SELECT quote FROM brain WHERE original = 1
    0 rows returned

    September 22, 2016 at 12:02 pm

    #1902594

  • RE: Today's Random Word!

    djj (9/22/2016)

    Revenant (9/22/2016)

    Kaye Cahs (9/22/2016)

    eccentricDBA (9/22/2016)

    Ray K (9/21/2016)

    Ed Wagner (9/21/2016)

    Grumpy DBA (9/21/2016)

    Ed Wagner (9/20/2016)

    Grumpy DBA (9/20/2016)

    Ed Wagner (9/20/2016)

    Butter

    Face

    Palm

    Rosey

    Garden

    Madison (Square)

    Zingers (Dolly Madison Bakery)

    Snoballs ®

    Calories

    Counting

    Down

    SELECT quote FROM brain WHERE original = 1
    0 rows returned

    September 22, 2016 at 11:45 am

    #1902587

  • RE: Email alerts when server reboots

    lcarrethers (9/22/2016)

    I have checked all the jobs in the agent and I don't see one sending emails for server reboot.

    It's part of the schedule...

    Just make sure the service itself is...

    SELECT quote FROM brain WHERE original = 1
    0 rows returned

    September 22, 2016 at 11:43 am

    #1902585

  • RE: How do I initialise a sql variable to 0 in stored-procedure ?

    Luis Cazares (9/22/2016)

    drew.allen (9/22/2016)

    Sue_H (9/22/2016)

    Luis Cazares (9/22/2016)

    Interview question?

    My thoughts as well. The follow up to that specific question could be interesting if someone doesn't know what would be different between...

    SELECT quote FROM brain WHERE original = 1
    0 rows returned

    September 22, 2016 at 11:39 am

    #1902584

  • RE: How do I initialise a sql variable to 0 in stored-procedure ?

    Smendle (9/22/2016)

    How to initialise a sql variable to 0 in stored-procedure which would work both in SQLServer 2005 & 2008 ?

    The part I bolded above provides a default value...

    SELECT quote FROM brain WHERE original = 1
    0 rows returned

    September 22, 2016 at 11:27 am

    #1902579

Viewing 15 posts - 181 through 195 (of 626 total)