Sql server HAS TO import the data for the join. There's no way around that (unless you do as you said and send the new data to the other...

As I said, store the full date. Use smalldatetime if you only precision to the minute. Use datetime for precision to 3 ms. The hours worked column...

The only question is : How easy was it after all ? I would've loved to be there to see the face...

Hehe, I guess it all comes down to operator precedence (from first to last) :

+ (Positif), - (Négatif), ~ (NOT au niveau du bit)

* (Multiplication), / (Division), % (Modulo)

+...

Not exactly what he means.

I think he's refering to having a temp table (or dedicated table for this) where you can insert the ids that need to be processed. ...

We can't see that : src="C:\Documents and Settings\L8CKHO1\My Documents\My Pictures\exampleresults policy.jpg"

it must be http://www.blabla.com/policy.jpg

Thanx for the info... Had a little fun by starting a trace with pretty much everything except the security and locks audit .

Is it that hard to get developpers to stop doing that??? I didn't have problems to adapt to that change.

Maybe I'm wrong but : 2005-05-17 16:35:48.000 May 17 2005 4:35PM

Takes 2 minutes to fix (yeah right ).

Hehe, we should create a rant about this one and put it in the FAQ .

When you rename any object that has code associated to it, the only change made is its name in sysobjects. The script has to be updated as well manually.

make sure you declare your [var]char variable with its size : varchar(SizeGoesHere). The default is 1 and I suspect that this is your problem.

It may be parameter sniffing at work. However I think that the simplest workaround would be to do something like this :

IF EXISTS (Select * from dbo.ProducTMaster WHERE...

Are you sure that the service is still started?

Which Authentication mode are you using?

What user are you trying to connect under?