eralper

Hello gbhs, SQL Server has introduced new features called Windowing functions like Row_Number, Rank, NTile, etc Please refer to SQL tutorial titled [Exam Scores Grouped by Their Classes Using DENSE_RANK()](http://www.kodyaz.com/articles/tsql-dense-rank-function.aspx) just on this topic Please check the following SQL code which uses DENSE_RANK() function for sorting students according their exam …

SQL Server support [TDE (Transparent Data Encryption)](http://www.kodyaz.com/articles/sql-transparent-data-encryption-sql-server-2008.aspx) But as far as I know, Express editions do not support this feature http://msdn.microsoft.com/en-us/library/cc645993.aspx

Hi, You can find methods summarized with samples at the article named "How to delete duplicate records or rows among identical rows in a table where no primary key exists" at [URL="http://www.kodyaz.com/articles/delete-duplicate-records-rows-in-a-table.aspx"]http://www.kodyaz.com/articles/delete-duplicate-records-rows-in-a-table.aspx[/URL] Eralper

I don't think it is a good way of directly inserting data into SAP databases. Generally they do not let direct insert, update or delete on main process tables. You should better call Function Modules in order to insert data into SAP db. I recently worked on migrating sales orders …

Did you try enclosing with [ and ] like select * from [Sales].[CountryRegionCurrency]

Hello all, With SQL2008 a new command MERGE is introduced for use of developers. For this sample this command fits very well. here is my solution. select * from Table1 select * from Table2 MERGE Table1 USING ( SELECT Id, [Date] FROM Table2 ) MergeData ON Table1.id = MergeData.id WHEN …

Hi, Try "select (50 * 1.0/100)" instead of "select (50/100)" Eralper [url]http://www.kodyaz.com[/url]

Hi, I can recommend the below sites, [url]http://www.sqlteam.com[/url] [url]http://www.sql-server-performance.com[/url] [url]http://www.sqlservercentral.com[/url] And my own site :) [url]http://www.kodyaz.com[/url]

Hi, You can use the below syntax: [code]insert into ... select[/code] The exact sql is as follows: [code] insert into exam (e_score, l_name, s_id) select e_score, l_name, s_id from assignment [/code] Eralper [URL="http://www.kodyaz.com"]http://www.kodyaz.com[/URL]

Hi, I hope the below script may help you. WHERE CASE WHEN Code LIKE 'A%' THEN OrderNumber ELSE 10 END = 20 OR CASE WHEN Code LIKE 'E%' THEN OrderNumber ELSE 10 END = 6 The below checks whether OrderNumber equals to 20 where Code begins with 'A' CASE WHEN …

Hi, Did you find a solution to your problem? May be the IIS version is the underlying reason for the problem. Since IIS6 is more tight when considered with IIS5. You may need to update a few configuration settings in the IIS6 panels. Eralper [url]http://www.kodyaz.com[/url]