Forum Replies Created

Viewing 15 posts - 211 through 225 (of 7,428 total)

  • RE: connection

    How are you trying to make the connection? And have you tried using VBScript to confirm you are able to connect to 2k5 Express?

  • RE: Fixing Orphaned Users

    This is what I personally use

    select 'exec sp_change_users_login ''AUTO_FIX'',''' + [name] + '''', * from sysusers where status != 0 and uid > 2

    it builds a string for each account,...

  • RE: connection

    You should be able to as long as you have the client drivers installed.

  • RE: Basic SQL

    As ramesh stated you can to charcter types, if you need to go to numeric you have to CAST twice. Also, when dealing with trying to cast to numeric types...

  • RE: Constraints that doesn't allow ID from another table.

    AVB (12/4/2007)


    Thanks everyone for the replies.

    I did create a PK/FK relationship between the two child tables and the Parent table. This PK/FK ID can only exist in only one...

  • RE: Constraints that doesn't allow ID from another table.

    AVB (12/3/2007)


    I have 3 tables. 1 table is the parent table that will create unique IDs. The other two tables will store these IDs in them with associated data....

  • RE: SQL Express Vs other editions

    Spoke too soon, here

  • RE: SQL Express Vs other editions

    Matt Miller (12/3/2007)


    The only real difference I know of (that might fit within the "desktop-friendly" category) is that it's the only version not to require 512MB for SQL. It's...

  • RE: Data type differences. . .nvarchar vs varchar, etc.

    Basically will you need to handle any extended character lanuages such as chinese or have special characters that don't esit in the default set?

  • RE: Alternative to while loop maybe?

    Sergiy (12/3/2007)


    Can anybody give me one simple reason for those RTRIM functions you guys put everywhere?

    I did it becuase the original poster did just to be sure I didn't cause...

  • RE: Index design on a table where the primary key is not clustered

    The question about adding the column from the clustered index to others is this. All non-clustered indexes include the clustered value itself up to a length of I think 64...

  • RE: Alternative to while loop maybe?

    Be carefull it is very easy to overcomplicate a task when you are still trying to understand it.

    Here are my assumptions

    1) Table Relationships

    Gov_regions_mining_score_TEMP to Region_lookup via Gov_regions_mining_score_TEMP.Region_key =...

  • RE: Alternative to while loop maybe?

    If you want one resultset with both values against each other then I assume SM is unique in Indicators_for_regions_Both so you could do this to have together as one set.

    SELECT

    A.Disease_S,

    B.Disease_SC

    FROM

    (

    --...

  • RE: Alternative to while loop maybe?

    With that last statement it seems to me like you want this.

    -- This will give you all SMs where Disease S has occurred regardless of SC occurring.

    SELECT

    I.SM as Disease_S

    FROM...

  • RE: Alternative to while loop maybe?

    Or as I suspect after thinking a hair more you want All SM's from regions that have experieced both Disease Types then this may actually be your item.

    SELECT

    I.SM

    FROM

    dbo.Indicators_for_regions_Both I

    INNER JOIN

    (

    SELECT...

Viewing 15 posts - 211 through 225 (of 7,428 total)