You need to create a linked server using sp_addlinkedserver procedure

EXEC sp_addlinkedserver

@server='TestServer',

@srvproduct='',

@provider='SQLNCLI',

@datasrc='YourServer\InstanceName'

Then, create linker...

You have not initialized any value for variable @m....

DECLARE @tmp REAL

DECLARE @tmp2 REAL

DECLARE @NewValue REAL

DECLARE @m REAL

SELECT @tmp = measureData FROM dbo.New_AMatrix WHERE x = @i AND y = @j-2

SELECT...

Do NOT delete any objects from production database unless you are fully aware of the impacts of that object.

I suggest you to first approach the person who has...

Thats why its easy to work when you have the latest technology.:)

May be its time to update your box too.....:D:D

May be not, its too late in the day:D

I guess the object audit_tr_200710231434316620 is a trigger which might be using the this object DS_InternalData_BI2k.db_audit.audit_200710231434316620.

Its not the CASE statement but because of the NULL. There are lot of differences between NULL and IS NULL.

Here are some of nice articles about the differences...

http://www.sqlservercentral.com/articles/Basic+Querying/understandingthedifferencebetweenisnull/871/

http://www.sqlservercentral.com/articles/Advanced+Querying/2829/

DECLARE @Datum...

I do agree with what Matt has to offer. Thats why i earlier pointed out to NOT to use this type of solution. It would surely not scale...

Alen,

You proved me wrong on what i said. Thats why we people say post exactly what do you want. Anyways, it that solved all of your queries?

Jeff,

My apologies...

Alen,

Its my mistake, may be because its too late in the day;)

Solution 1

SELECT TOP 1 *, @Sku Sku

FROM ePrice2K5.dbo.[consel]

WHERE ( imp_fin <= @Prezzo AND tasso0 = @Tasso0 AND @Tasso0 =...

Oops...I didn't see that!!!

SELECT TOP 1 *, @Sku Sku

FROM ePrice2K5.dbo.[consel]

WHERE ( imp_fin <= @Prezzo AND tasso0 = @Tasso0 AND @Tasso0 = 1 )

OR ( imp_fin >= @Prezzo AND tasso0 =...

Hi Jeff,

I don't think we need to compare the amounts too, as i can see that this is an accounting related information.:)

ID is unique accross both tables, match lowest allocate...

The query will not work as the syntax is somewhat different when using joins...

DELETE FD FROM FileData FD INNER JOIN SupportingInformation SI ON FD.FileUID = SI.FileUID AND SI.SupportingUID = @SupportingUID

Alen,

So, have you used some other method for this function used in some other table as computed one?:cool: (earlier post here)

Now for the current post,

You could use OR clauses in...

Assuming your using SQL 2005, here is one of ways using ROW_NUMBER()....

SELECTC.AccountNumber, D.DebitID, D.DebitAmount, C.CreditID, C.CreditAmount

FROM(

SELECTROW_NUMBER() OVER( PARTITION BY AccountNumber ORDER BY CreditID ) AS RowNum,

AccountNumber, CreditID,...