Forum Replies Created

Viewing 14 posts - 646 through 659 (of 659 total)

  • RE: Insert

    How can provide data for u, can I attach any files in this forum?

    Anyways Let me explain u clearly..there are no matching records in both the tables. my assumption regarding...

  • RE: Insert

    what I mean is how can I INSERT fresh data with the joins I have, so that both tables syncronize with FK values.

  • RE: Insert

    yeah there is relation between Pk and FK.

    OK what if I delete all the rows and try to insert it again with the this relationship. What will be INSERT command...

  • RE: Insert

    Here what do u mean by 'whatever'

  • RE: Insert

    OK I'll give the structure of my tables and let me know how to update the table2 where I have added a FK column.

    Lets say I have 2 tables in...

  • RE: Insert

    Is it possible to add a column in table2 as FK which is a PK column in table1 and make a relationship. The no of rows in both tables are not...

  • RE: stored procedure

    Thanks guys

    Anyways I was able to get that result.

  • RE: Join tables and INSERT

    The relationship between 1st 3 tables is in this way

    say table1=offices, table2=Depts, table3=sections.

    Here offices has many Depts, Depts has many sections.

  • RE: Permissions

    I have added role to db_ddladmin, now its working fine.

    Thanks a lot Greg

  • RE: Permissions

    I added the role to db_ddladmin, now its working.

    Thanks a lot Greg.

  • RE: Permissions

    Sure..Thanks for ur participation.

  • RE: Permissions

    I have a fixed server role and added that user account to this role. and this role was set to have all the permissions to create a SP, But the User...

  • RE: Permissions

    If u dont mind, can u pls let me know how can I check that?

  • RE: Permissions

    He does not own the SP, I myself created SP and granted him all permissions tfor SP

Viewing 14 posts - 646 through 659 (of 659 total)