SQL Server database programming

Is it possible to create a stored procedure that exists in one database, but runs in the context of the database from which I call it? For example, I want my proc (A.dbo.MyProc) to create table Foo in my new ...

Hello: I've been pulling my hair out in trying to convert the following two Oracle stmts. to its T-SQL equivalent: SET @sSelect = 'Select sum(decode(tc_trx_code_type,''X'',decode(instr(tc_description,''GST''),0,decode(instr(tc_description,''G.S.T.''),0,round(ft_guest_account_debit,3),0),0),0)) ''PST/PHT'',' ...

I hope I can explain this  . . . I have several fields that can be null and I need to concatenate them together to create a single value.  Not my data, so please understand it follows no logical rules. Here are the fields: ...

I have a table with 3000 Client_id's. I have another table with 56 different order types.  The order types primary key is two fields (search_id, item_id) I need to insert into another table each client_id, along with each ...

Hi, pls. see this code: DECLARE @SQL nvarchar(4000) SELECT @SQL = 'SELECT * FROM CUSTOMER WHERE CustomerName = N''Trần Tấn Hận''' PRINT @SQL The result is this always: SELECT * FROM CUSTOMER WHERE CustomerName = N'Tr?n T?n H?n' ...

I have a table with entries tied to a membership database.  The problem is that I want to select a limit of sixteen entries per member, per day, where some members have 16+ entries per day. I have this so far ( which I've simplified for this post) ...

Can I have CASE for something like this: ........ ........ where  id in case @TestVal when 1 then (select min(id) as id from ......) else (select max(id) as id from ....) end Thanks for help. ...

I have a table with 80,000 rows. A column of that is username, I am going to change the table structure since we got a user table already. I have added a column named userID. I would like to update the userID from user table by the username, ...