Forum Replies Created

Viewing 15 posts - 1,411 through 1,425 (of 2,452 total)

  • RE: Counting the characters in a string before a space

    out of curiostity...having got the character count before spaces.....what are you intending to do with the results?

    ________________________________________________________________
    you can lead a user to data....but you cannot make them think
    and remember....every day is a school day

  • RE: Would like some feedback on contractors as employers

    In a similar vein .....

    what's the current UK market like?

    ________________________________________________________________
    you can lead a user to data....but you cannot make them think
    and remember....every day is a school day

  • RE: sql to create sets

    ForumUser3 (6/11/2014)


    Please find attached script files to create tables and data.

    dbo.Cust_Encounters.Table.sql is the data to start with. dbo.Cust_Encounters_Sets.Table.sql shows what it will look like after creating sets.

    Thank you for you...

    ________________________________________________________________
    you can lead a user to data....but you cannot make them think
    and remember....every day is a school day

  • RE: sql to create sets

    create table and insert data scripts for your example will be highly appreciated.......this will help us help you

    ________________________________________________________________
    you can lead a user to data....but you cannot make them think
    and remember....every day is a school day

  • RE: Selecting from a remote spreadsheet

    http://blog.sqlauthority.com/2010/11/03/sql-server-fix-error-ms-jet-oledb-4-0-cannot-be-used-for-distributed-queries-because-the-provider-is-used-to-run-in-apartment-mode/

    maybe will help you

    ________________________________________________________________
    you can lead a user to data....but you cannot make them think
    and remember....every day is a school day

  • RE: ExecutionPlan

    http://www.sqlsentry.com/products/plan-explorer/sql-server-query-view

    this is a free tool and you can "anonymise|"

    ________________________________________________________________
    you can lead a user to data....but you cannot make them think
    and remember....every day is a school day

  • RE: Help with Query

    bearing in mind Grant's comments about the differences between the two RDBMS....probably best to follow his advice me thinks.....

    ________________________________________________________________
    you can lead a user to data....but you cannot make them think
    and remember....every day is a school day

  • RE: Help with Query

    please clarify what results you are expecting for this example

    account_number acex_id expense_group effective_date expense_group_line_id process_description...

    ________________________________________________________________
    you can lead a user to data....but you cannot make them think
    and remember....every day is a school day

  • RE: Help\Advice on building a query

    centerman99 (6/5/2014)


    Hi I am trying to build a query which will be used in an automated report to calculate failure rates of systems based on cases opened through support. ...

    ________________________________________________________________
    you can lead a user to data....but you cannot make them think
    and remember....every day is a school day

  • RE: Query

    here is one way ...though I would normally use a calendar table and also expect to have a user table (rather than build the cte's below)....maybe give you...

    ________________________________________________________________
    you can lead a user to data....but you cannot make them think
    and remember....every day is a school day

  • RE: Knowledge about Measurement

    akirajt (6/8/2014)


    Purpose:

    The purpose is to learn and increase my knowledge. Today, I'am junior business intelligence developer. I do not have enough with knowledge from a business controller's perspective. Some...

    ________________________________________________________________
    you can lead a user to data....but you cannot make them think
    and remember....every day is a school day

  • RE: Convert sys.master_files size column to GB?

    Welsh Corgi (6/8/2014)


    Lynn Pettis (6/7/2014)


    Welsh Corgi (6/7/2014)


    That is sweet. I have the sizes stored in KB's. What statement could I used to convert from KB to GB?

    Thanks a bunch!

    Divide twice...

    ________________________________________________________________
    you can lead a user to data....but you cannot make them think
    and remember....every day is a school day

  • RE: Faster Querying

    suggest you read this and then post back again.

    http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

    ________________________________________________________________
    you can lead a user to data....but you cannot make them think
    and remember....every day is a school day

  • RE: DELETE + EXCEPT/INTERSECT + NULLS + BITS!

    autoexcrement (6/7/2014)


    Thanks for the reply! The problem is we still need the "other columns". Again, it's my bad for not getting the DDL together for this one first. I will...

    ________________________________________________________________
    you can lead a user to data....but you cannot make them think
    and remember....every day is a school day

  • RE: DELETE + EXCEPT/INTERSECT + NULLS + BITS!

    autoexcrement (6/6/2014)


    The end goal is that Live should have one record for every unique combination of the 8 "tracked" columns.

    .

    maybe an idea?

    INSERT INTO [dbo].[live]

    ...

    ________________________________________________________________
    you can lead a user to data....but you cannot make them think
    and remember....every day is a school day

Viewing 15 posts - 1,411 through 1,425 (of 2,452 total)