Home Forums SQL Server 2008 T-SQL (SS2K8) How to combine two tables when one table is in different database and this table will determine the value to be shown on the first table. RE: How to combine two tables when one table is in different database and this table will determine the value to be shown on the first table.

  • Hello Geomorian. That was really cool. I am thinking it has be another technique, like for example, using a variable ([font="Courier New"]BIT[/font] type) to set to either 1 or 0, then "convert" it to "YES" or "NO". (I guess I am just making my life too hard, silly me.). But for the record, is this possible? If yes, can someone give a little example?

    Well anyway, this is straight to the point, and it is awesome! 😎

    Thank you Geomorian and Sean Lange. 🙂

    Warm regards,

    Mark Squall

    ________________________________
    "Listen to advice and accept instruction, and in the end you will be wise." -Proverbs 19:20