lallu_jaya (8/22/2012)

---

I have a temp table where Iam inserting data from original table

temp_id, temp_test_id, temp_status

1 2 ...

Holy cow!!! You have 9 points and your post was absolutely perfect!!! It included all the ddl, sample data, desired output, a clear explanation of what you wanted. I wish...

Lynn Pettis (8/22/2012)

---

Evil Kraig F (8/22/2012)

---

Lynn Pettis (8/22/2012)

---

I'm going to go against the flow a bit here. I think it really depends on what the application is intended to...

sqlfriends (8/22/2012)

---

I use the merge statement in a sproc to insert, update and delete records from a staging table to a production table.

In the long sql, here is a part...

Yes that would be better....

There is one...

salliven (8/22/2012)

---

I don't know what database is runing the query...

salliven (8/22/2012)

---

Hello!

How to catch a query from an another database (example from profiler)?

-- Example:

USE [master] -- or another database

GO

-- How to catch this query on the SQL server?

SELECT name, database_id...

Ankur Bajaj (8/22/2012)

---

Guys, thanks for your inputs. I have created the below script which serves my purpose for now.

Cheers!

SELECT 'CREATE VIEW ' + TABLE_SCHEMA + '.vw_' + TABLE_NAME + '...

duplicate thread. Please direct all replies here. http://www.sqlservercentral.com/Forums/Topic1348317-392-1.aspx

rahul_yerramareddy (8/22/2012)

---

Hi,

Please find below detailed explanation.

We have two domaind DOM1 and DOM2. Our Central server is in DOM1.Users have local servers either in dom1 or dom2.

If users from DOM1...

jfriedl (8/21/2012)

---

I have a trigger that is running on one of our production systems. from the time that it was enabled we noticed some data inconsistencies. in particular...

newbieuser (8/21/2012)

---

Hi Sean,

THanks so much for your quick response... I really appreciate it. I tried a few different variations with your example, I think I'm pretty close but not...

newbieuser (8/21/2012)

---

Thanks Sean. I used try-catch as below, it gives the detailed error message... we would need just the procedure to return 'failure' when the procedure fails...

CREATE procedure temp

as

BEGIN

...

Something like this.

create table #table1 (employeeID int)

create table #table2 (employeeID int)

insert #table1

select 1 union all

select 2 union all

select 3 union all

select 4 union all

select 5 union all

select 6

insert #table2

select...