Bill,

I'm not sure what you are exactly asking. Are you mentioning that if you just run the Selects you have listed in SSMS you get the same results? ...

Happy Birthday upcoming Steve.

I can agree with most of you who have said that they have what they need. I have several things on my I'd like to have...

Can you please explain what you are trying to do, then someone may be able to help you. Right now all I know is that you were trying to...

If you start a server side trace to a file you can use ::fn_trace_gettable([path], [# of files]) to return the data in tabular format and insert them into a table....

Based on the error message, you have not declared the variable/parameter @y correctly. Are you directly calling this stored procedure? According to BOL:

These system stored procedures will show...

Thanks for the positive comments Carla, glad it was helpful.

If you really want to turn it off you could actually make the change in the advanced properties of...

Arthur.Lorenzini (9/12/2008)

---

What about doing multiples JOINS to the same table:

Such as

LEFT OUTER JOIN dbo.employee s1 WITH (NOLOCK) ON (s1.employee_id = t.salesman_employee_id)

LEFT OUTER JOIN dbo.employee s2 WITH (NOLOCK) ON...

MrBaseball34 (9/12/2008)

---

Thanks, Jack, but the DOS comes from the ptChemoOrders table not from the

ptChemoMedicalBilling table that the trigger is on. The ptChemoMedicalBilling record is based on the OrderID in...

Which changes the errors or ALL data changes?

If you want to see all data changes the best way, IMO, is to use triggers on the table. I suppose in...

Reginald J Ray Jr (9/12/2008)

---

I'm confused. I get the same results from 'select * from duh' for both settings of ANSI_PADDING.

set ANSI_PADDING off

go

create table duh (

col1 varchar(50)

)

insert into...

Here are 2 options:

[font="Courier New"]CREATE TRIGGER [tr_ptChemoMedicareBilling_StoreCharges_del]

   ON  [dbo].[ptChemoMedicareBilling]

   AFTER DELETE

AS

BEGIN

   SET NOCOUNT ON

   DELETE P

   FROM

       ptEncounterDetailsCharges P JOIN

       deleted D ON

           P.MRN = D.MRN AND

           P.DOS...

Jack Corbett (9/12/2008)

---

It is related to the resolution. Apparently the table is not resizing based on resolution. Not being an HTML guy I'll...

It is related to the resolution. Apparently the table is not resizing based on resolution. Not being an HTML guy I'll have to...

I subscribed to this thread hoping someone would post a solution since I don't know of one within RS. I'll give you a couple of ideas, the first one should...

I'm curious, are running the SP then the Ad-Hoc? Does the SP run faster the second time? What happens if you run DBCC DROPCLEANBUFFERS before running each query?