Forum Replies Created

Viewing 15 posts - 4,876 through 4,890 (of 6,395 total)

  • RE: Booked 70-450

    GilaMonster (5/28/2012)


    anthony.green (5/28/2012)


    To be honest I dont think I'm ready for both, so today is going to be cram cram cram with Transcenders, re-reading the 70-432 book and also Tom...

  • RE: General Qestions

    2 walls should be ok, they just need skimming so should dry within 2 days, the other two walls will be a different story as they are down to the...

  • RE: General Qestions

    Not really Adam, just spent this weekend removing plaster from the walls in whats going to be the babies room, so the weekend will bring the better halfs farther round...

  • RE: With Quey (Row Wise Data Into Column Wise)

    just change the join then to join t1 on workid and t2 on workid and use a case statement to get the actualgatedate.

  • RE: General Qestions

    SQLDBA360 (5/28/2012)


    ooops need to check my Belgium public holidays better :-p

    Your right it is a public holiday, Whitmonday

  • RE: General Qestions

    I cant get to jealous of that, its a 2 day bank holiday for us next week, woohoo 4 day weekend.

  • RE: With Quey (Row Wise Data Into Column Wise)

    New problem needs a new thread.

    Please take a look through the link in my signature on how to post code/date for the best help, so that we can help you...

  • RE: General Qestions

    So I wonder if Koen is still alive or if he got taken to hospital with burst ear drums over the weekend

  • RE: Booked 70-450

    Right well tomorrow is going to be a scary day.

    Not only do I have my 70-450 exam in the morning, in the afternoon I also find out what sex our...

  • RE: iPad? Good for monitoring SQL servers?

    Grant, on the Droid OS, does it render SSRS reports properly?

    I know Safari has its limitations, so I use the MobiSSRS (free version) app instead of Safari which works ok...

  • RE: How to Send SSRS Reports(subscriptions) from SQL AGENT JOB STEP

    as you already have the subscription setup, I would remove the schedule from the T-SQL job which is used to run the subscription, then as step 2 of your load...

  • RE: With Quey (Row Wise Data Into Column Wise)

    With Project_view(WorkId,Name,StatusCurrent,ActiveProcess,ActiveGateDate,ActualStartDate,ActualEndDate)

    As

    (

    Select distinct vw.work_id as WorkId, vw.name as Name,vw.status_current as StatusCurrent,

    vp.process_name as ActiveProcess,vw.actual_start_date as ActiveGateDate,vw.actual_start_date,

    vw.actual_end_date

    from view_work vw INNER JOIN View_Process vp ON vw.process_id = vp.process_id

    join View_Work wv on wv.active_gate =...

  • RE: Cost to upgrade to SQL Servr 2008 R2 x64

    You can go on http://www.microsoft.com/store to get MS's current list price.

    UK price for 2008 R2 Enterprise is

    1 CPU is £23,850,

    Server + 25 CALS is £10,780

    CAL's arn't listed but from...

  • RE: With Quey (Row Wise Data Into Column Wise)

    wrap the second select in another CTE then query that CTE using datediff functions on the second date columns DATEDIFF(DAY, DefineStart, DefineEnd) AS DefineDuration

  • RE: Transaction Log Setup

    yes its just the backups. SQL wont let you delete an LDF if its in use and attached to a database so you will know if your trying to...

Viewing 15 posts - 4,876 through 4,890 (of 6,395 total)