RubyRed (6/25/2008)

---

I am trying to get the opentime between the employee exceptions during the day. For instance if employee 19261086 started work at 10:00:00 and toke a break at...

You can have a list of "REGISTERED" servers with the saved connection credentials and then is a matter of double-clicking each one of them. Is that what you are after...

Roy Ernest (6/25/2008)

---

Hi All,

I have a pre-pre deployment server with restricted use to developers. My aim is to let them release their stuff to this server. I have given them...

How about :

DECLARE @t table (form_code int, state varchar(20), time_stamp datetime)

INSERT INTO @t (form_code, state, time_stamp)

SELECT 3245, 'Submitted To X','2008-06-06 12:13:25.450' UNION ALL

SELECT 3245, 'Submitted To X','2008-06-06...

Kwisatz78 (6/25/2008)

---

Hi all

I am currently have a requirement to run some code against each table in a database and was thinking of using sp_msforeachtable. However I also have a...

Are these "update" statememts affecting a lot of rows ?

You should look at how many locks are being generated, probably on the distribution database.

Hehehe ... Jeff beat me to the punch 😀

You will need to probably use SELECT INTO and use the SWITCH statement to move data into the partitioned one. I am not sure though that this can be done...

dbirchok (6/24/2008)

---

Yes we are using transaction replication.

I miss understood what you meant by stored procedure replication. I though you meant using stored procedures in table replication. The straight-up...

nigel.c.west (6/24/2008)

---

Not sure what the hell is going on in this thread.

The answer is .....

You cannot do a DISTINCT when you are already doing a TOP 5, the two are...

dbirchok (6/24/2008)

---

I did a lot of research about this and your answers make no sense. Let me go “step-by-step” for you.

1.Your reason for doing one row at a time would...

You may want to "see" more here

By the way I work with financial data and we use "floats" 😉

I have seen these things in "generated" queries and they require pretty much a serious re-write or simply just let it happen at "off" hours. If this is the case...

This:

...

from pilot.dbo.CUSTOMERS

inner join pilot.dbo.COMPDATA on ( pilot.dbo.COMPDATA.COMP = - ( @P43 ) )

inner join pilot.dbo.CUSTTOPICS on ( pilot.dbo.CUSTTOPICS.TOPIC = - ( @P44 ) )

inner...

It all depends on "RISK" I have worked for companies with top-line support from Microsoft and They ofcourse would work with the bleeding edge releases. For those others that had...