UPDATE poz

SET tip='k'

FROM pos INNER JOIN juridic ON poz.con = juridic.con

WHERE juridic.dosar='p'

Pass your colleges in as a delimited string and use the following function

CREATE FUNCTION dbo.fnSplitDelimited ( @sInputString1 VARCHAR(8000) , @sSplitChar CHAR(1))

RETURNS @tbl_List TABLE (Id1 Int PRIMARY KEY )

AS

BEGIN

DECLARE@lInputStringLength1Int ,

@lPosition1Int ,

@lSplitChar1Int...

The approach is also useful in modular applications. For example you may have 3 modules that can run as discreet applications but can also run as a single master...

COUNT(*) or count(1) returns a count of all records including NULLS.

COUNT(expression) returns a count of all non-null records.

The first two don't seem to have any performance difference or differences in...

No, this isn't true. Dinar's solution is to bounce the records through a table variable with its own identify variable and this would be sequential.

I have applications that use several separate databases, in fact using multiple databases per application is fairly standard in the world of content management systems.

I would be very careful about...

I would do it using a college table

* CollegeId,

* CollegeDescription

I would either have a separate table to maintain the Parent/Child college relationship

* ParentCollegeId

* CollegeId

or I would put the ParentCollegeId in...

The thing that is hardest for a non-US citizens to appreciate is that the US is, near as damn it, a continent rather than a country.

If the US built a...

So if I understand you correctly you have two locations, for the sake of argument we'll call them demo and live.

At demo you have

* A web server

* A SQL server

At...

What are the specs of the various machines?

What else is running on the machines? If the host is running WebTrends you may see a huge performance hit. WebTrends...

DECLARE @sProcName SysName

SET @sProcName=''

WHILE @sProcName IS NOT NULL

BEGIN

SELECT @sProcName =MIN(Name)

FROM SysObjects

WHERE Type='P' AND...

I've installed it on my development servers but don't have anything to report as yet.

The @@error bug seems to be fixed and some queries seem to run faster.

What I am...

Well, as VARCHAR/NVARCHAR shouldn't pad the string that implies that either your variable is paddding or the setString function is padding it.

What happens if you run

SELECT databasepropertyex(DB_NAME(),'IsAnsiPaddingEnabled')

Why bother?

I am sure that you can copy MODEL to another instance, but I'm not sure about MSDB. I suspect that you can move MSDB but don't quote me...

Ye Gods, don't you just hate vendors who buy a stable full of products, chuck them in a bucket, stir with a big stick and then say "look at our...