Oleg good catch! that's the diff between using datepart and calculating elapsed time; i'm fiddling with it now of to test for accuracy;

Thanks!

::edited; i think this seems to calculate...

well the optimizer uses the stats to determine the fastest way to get the data; if the statistics imply that the selectivity of a record is very close to 1...

now that you have the two vals as datetime, it should be easy;

here's some examples i've saved that pulls out the peices; you can concat them togeter for the format...

statistics.

the statistics are different between the two databases.

even if the two db's started out as identical, the way the data is selected/updated can change the statistics, and THAT is what...

this one is just a basic error, no worries.

the issue is this part i think:

WHERE EMP_ID = ''' + @ZEMP_ID + ''''

you are doing VARCHAR + INT, which results in...

procs and functions are going to be the same logic; cursor with a try - catch, but instead a dynamic SQL;

get the text for the proc/function from sys.sql_modules, do...

I had looked into this same issue back in september;

see this thread here:

http://www.sqlservercentral.com/Forums/Topic785213-146-1.aspx

at the time, i was having some developers run scripts that dropped stuff, and then they found out...

do a select * from sys.servers

quite often, the alias for your linked server is different than the name of the actual server.

it's the name of the linkedserver, not the...

yeah i've used multiples before; i needed both a counter and a partitioning /grouping of the data;

here's a simple but lame example:

select

Row_number()...

the most common way is to have a trigger enter a row in a specific table; the your application can scan the table every minute or so for any...

Google Translator (4/21/2010)

---

Hello

I have an application that contains a cursor when I run the query in SSMS there are mistakes but he made the entire cursor (like on error...

I doubt R2 is much different from SQL 2008; there is a maintenance function to change editions in the SQL Server Installation Center for 2008:

as Lutz posted, both the syntax you used and the error you posted are for Oracle only; SQL server uses the plus + operator to concatenate strings:

Here is the equivilent...

yes that is exactly correct, Joy; you've got it now.

the views from INFORMATION_SCHEMA stuff are missing a lot of info;

to get theidentity or not,i would either use the ColumnProperty() function, or select from sys.columns instead.

select * from sys.columns where...