I think you can make this work if you call a StoredProc on the linked server... no need for dynamic sql there.

It can also mean Happy to help. Which is the meaning I use it for on this site.

And the answer is??

You can't do that in sql server. You have to use dynamic sql for such a task (and build the whole cursor part in the dynamic sql).

Why is the...

Can't you just do this?

Select * from MyLinkedServer.DbName.dbo.EmployeeNameTable where emplid = @Param

You can use the import data wizard on the target server's database. Or you can use dts (copy object task). It's all wizards and easy to understand in...

View,the values are hard coded. The table function allows to have them dynamic. Look in books online in you need the syntax for the function.

HTH.

HTH.

If the condition is always exactly the same, you can create a view with that condition included, then you just have to select from that view, flushing the statement in...

I'll take your word on this one Michael, the quote I have from the sitcom "Friends" doesn't use the t. But frankly I don't really care

Don't forget to change all the calls for all those objects in tha application. Then retest the whole app to be sure you didn't forget something. Now that can...

Just create a table like this I assume :

Account_id int?

DateInterest smalldatetime

Amount decimal(12,2)

But this seems to me like this should be part of a transaction table with transaction type... but...

Please do not cross-post, we monitor all boards.

Finish the thread here :

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=146&messageid=199020

Please do not cross-post, we monitor all boards.

Finish the thread here :

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=146&messageid=199020