Now what are the values in the parameters when the function is run like:

Set @fechaInicio = '20080408'

Set @i = 10

Try putting:

Set NoCount On

after the AS in the trigger. The ODBC driver may be receiving the "N rows affected message" from the trigger when it is...

Just something like:

Create Table test

(

test_id int,

test_desc char(6)

...

Now, you may not be able to do this, but I have found that writing the queries on the linked server as a stored procedure and calling the procedure has...

Not being familiar with paradox I can't be sure this will work, but SQL Server allows for 4 part naming in LInked server queries like this:

Select

...

Business Intelligence Development Studio (BIDS) is included with the install of SQL Server 2005 tools so you should have it on you SQL Server 2005 media. This allows you...

Any replies to this should go to

http://www.sqlservercentral.com/Forums/Topic483305-149-1.aspx

Please do not cross post.

What is the data contained in the parameters?

For 1: That is essentially what the Identity function does. The only caveat is that a failed insert will increment Identity while using your own sequence table allows...

Could you post some sample data on which to test?

I agree with PW that it looks like having the AchieveLevel in the Group By may contribute to the results, but...

It's not really simple to do that with an identity column. Do you need it to do that for display purposes or is there another reason? I ask...

I believe you need to have your source server set up as a MASTER JOB SERVER and the destination server one of the nodes assigned to the Master Server. ...

I don't know how to do it in a cube but in Reporting Services you can do:

IIF(Fields!Field_Name.Value Is System.DBNULL.Value, 0, Fields!Field_Name.Value

I am still new to 2005 so I don't have a lot of experience with schemas, but in my main project I have used schemas for data access and organization....

My opinions on the subject:

1. I use identity, I consider it a surrogate key (I know Celko and others disagree) and use it mainly for relationships within the database....