SQL Server database programming

Hi, i have 2 tables.  table A: ID - primary key ID2 - primary key name address table B: ID - primary key ID2 - primary key name address i want to select from table A where for records that do not exist in table ...

I got interested in a post I saw a few days ago. [link] Before I go any further, let me mentions that this is 2005. ...

I need some query help I have the following table ENTITY ID            ENC #              DATE 1044                    101                  05/02/2007 ...

Hi, When I run the following sql statement, I got error message: Cannot specify outer join operators in a query containing joined tables. View or function 'v_Address' contains outer join operators. SELECT Name_a.FullName, v_Address.Line1, v_Address.CityName , v_Address.ProvinceName, ...

I created a Table-Valued Function to return a record to use within the recursive processing of a CTE. It is giving me a compile error of Msg 102, Level 15, State 1, Procedure upGetSubordinates, Line 91 Incorrect syntax near '.'. ...

I have thie very simple table: ID    processtime    cost    category 1        100                50        0 ---    labor ...

Hi, I'm trying to change database from restricted_mode to multi_user mode. I'm running the following command: ALTER DATABASE MyDatabase SET MULTI_USER WITH ROLLBACK IMMEDIATE If any user is connected to database, the above statement fails and gives the error as shown below: ...