Forum Replies Created

Viewing 15 posts - 1,051 through 1,065 (of 1,193 total)

  • RE: Group sums?

    Can you post the full query?

    Thanks

  • RE: Acronym factoid

    srinivas30k (3/26/2012)


    is that applicable to win7 os ??

    Yes, except for:

    Signs and Symptoms of Psychotic Illness (rating scale)

    &

    Salle de Soins Post-Interventionnels (French: Post-Interventional Room Care; recovery room)

    They both apply to Vista.

  • RE: Acronym factoid

    Surprised I got that right the way my Monday's going so far!

    Cheers

  • RE: Help with WHERE

    I didn't at first either. Then wondered why the field name's format was so different to the rest of the fields!

  • RE: SQL server 2008 R2 express

    I can't remember. You could try downloading & installing it, and seeing if BIDS is in the install checklist?

    That and SSMS can be installed at the same time as the...

  • RE: Help with WHERE

    Looks like you are filtering based on the aggregated COUNT(SERV.Reference) field in the select?

    In that case, you need to add a HAVING clause:

    SELECT SALES.UID

    ,SALES.Reference

    --,SALES.SOStatusID

    --,SALES.SalesOrderCategoryID

    ,COUNT(SERV.Reference) AS 'Number Of Service Orders Attached'

    FROM...

  • RE: A Personality Test

    I'd be a Mazda RX-8 - unconventional. And a bit leaky. 😀

    Currently drive a Ford Focus, but will be buying the Mazda as soon as I can!

  • RE: Script all tables contraints, indexes, keys and triggers

    Hi,

    In Management Studio, right-Click on the database in object explorer, choose Tasks -> Generate Scripts...

    You can then select which objects you want to script, whether or not to script the...

  • RE: Effective filtering of SQL Profiler tracing

    Hi Steven,

    It's because the ShowPlan event doesn't have CPU time value, so it can't be filtered by that, and returns all rows for that event.

    You can exclude them by ticking...

  • RE: VIEWS 3

    sknox (3/20/2012)


    Koen Verbeeck (3/20/2012)


    According to CREATE VIEW (Transact-SQL):

    When a view is created, information about the view is stored in the following catalog views: sys.views, sys.columns, and sys.sql_expression_dependencies.

    Information that is stored...

  • RE: On PK column, is unique index defined automatically ?

    The Primary Key uniquely identifies each row in a table, so it kinda has to be unique 🙂

  • RE: Linked server

    Koen Verbeeck (3/14/2012)


    I'm going to frame this one.

    I think you should! 😀

  • RE: 2012 Books Online (or lack thereof)

    Like the way they're going with the BOL here (using Help Viewer 1.1), and seem to be trying to unify the help across products.

    You can download them to have locally...

  • RE: Install of SQL2012 RC0 giving trouble

    I had the same problem with the DRC - I think it was because the user I added wasn't an AD user, just a local login.

    Solution was to leave it...

  • RE: Need to prove that SSRS needs to be on separate server from database server

    There's something quite funny about watching RS tank the all-singing, all-dancing new server.

    Less so when you get the rap for putting it there! 😀

Viewing 15 posts - 1,051 through 1,065 (of 1,193 total)