Hello:

If you're using transactional replication, replicated objects are supposed to be "read only" at

subscribers side, if they don't, then you have to re-think your approach.

I think You should better...

Yes!!! I just converted the txt file to UNICODE ant it worked fine... Thanks a lot!!!!

Thanks a lot Jeff, I'm coming from SQL Server 2000 and did not have knowledge about rownumber().

I said "performance is vital" to avoid the use of temp tables or...

I don't want just the highgest value, but the highest value and the second highest value (orderdate+ordernumber) for ecah product code... in other words: the most recent two orders for...

Thanks Gail.... That's exactly what I told him, anyway I posted the question considering that someone could have some tool or trick or "non documented" method to 'apply' a...

Jason:

I did not find a solution for x64 platform... In my case I needed the SQL DBA Toolkit to use the Jaro-Winkler string similarity functions... Googled a lot and found...

That is not rigorously correct...

As many people has said, the primary key is...

There's an space character at the beginning of the function name. remove that space or just change your function call to select * from dbo.[ Get_variation_List] ('xxxx,yyy')...

The primary key in fact is a concept in relational databases....

It's not recommended to install antivirus software in your MSSQL servers. In place of this you can install antivirus on other station and schedule a remote scan of your SQL...

Once I had a a very similar issue after applying a service pack. After rebuilding indexes and updating statistics all returned to the habitual rates...

Your field contains nonprintable characters....

what does return select ascii(right(field_name,1)) ????

insert Invoices

select distinct B.Invoice_num, B.Invoice_Amount, max(A.line_item)+1 from Invoices A

inner join #tbl_invoices B

ON a.Invoice_num= B.Invoice_num and Invoice_AmountB.Invoice_Amount

group by B.Invoice_num, B.Invoice_Amount

As you have said, the index field can only have 6 possible values. Since the table has some million rows, the selectivity of the index is very low.... so a...

Your problem resides in the WHERE clause where you have 4 OR operator. If one of the 4 conditions becomes true, then the WHERE will be true too.

This should work:

select...