Forum Replies Created

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

  • RE: Finally got my SQL Server database into Azure!

    Doctor Who 2 (8/7/2016)

    Eirikur Eiriksson (7/24/2016)

    Doctor Who 2 (7/24/2016)

    I finally got my SQL Server database uploaded into Azure SQL! I posted a blog post about it. Rather than repeat what...

    October 3, 2016 at 2:16 pm

    #1904555

  • 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...

    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...

    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?...

    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...

    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

    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...

    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...

    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...

    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!

    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.

    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...

    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

    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...

    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...

    September 22, 2016 at 11:39 am

    #1902584

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