kshah82 (5/8/2012)

---

Thanks I tried this but I want to see records from both tables together.

1. changes to both tables - show records from both table as a single...

Did you put this inside a transaction? If so, just "ROLLBACK TRANSACTION"

Something like this?

declare @Delete int, @Update int, @Insert int

delete from bill_detail where bill_detail in (9878506)

and policy = 4236807;

select @Delete = @@ROWCOUNT

update prem set written_prem = 50,

commission_amt = 7.50,

audit_id = USER,

last_modified...

al_kessler (5/8/2012)

---

Through out all this no one has wondered why "Intellisense" can take care of color coding but not capitalization.

What about some settings to implement the "shop standard"...

Another thought is that your connection is being close and therefore you are not on the same application role.

What...

Something like this?

select * from Employee

where End_Date between @StartDate and @EndDate

select * from Assets

where EndDate between @StartDate and @EndDate

Yeah that means it is something in your code and not on the sql side. I suspect you will...

Something along these lines?

select b.*

from AutosA a

left join AutosB b on a.PriKey = b.PriKey AND a.Engine <> b.Engine

where b.Engine <> ''

rabisco (5/8/2012)

---

Sean Lange (5/8/2012)

---

Well it certainly demonstrated the problem. Is this a one time thing or something you need to...

mintsql (5/8/2012)

---

Maybe my intuition was wrong, but my thought process was:

1. If I query two tables for their non blank columnZ, and tableA has 883 more non rows of that...

Well it certainly demonstrated the problem. Is this a one time thing or something you need to run regularly? If...

mintsql (5/8/2012)

---

Hello,

I am trying to figure out the following:

I have two queries:

1. Select * from tableA where colA <> ''

2. Select * from TableB where colA <> ''

For #1 there...

What happens if you run the following code in SSMS?

EXEC sp_setapprole 'APP_USER_APP', 'test123'

Select * from Table1

Hi and welcome to SSC! Please take a look at the first link in my signature for best practices on posting questions. At the very least we need ddl, sample...

Yes, I finally beat "fast fingers" Lynn to a response. 😛