Blogs RSS

Search Results

•

Showing results 1 to 6 of 6
Search took 0.01 seconds; generated 1 minute(s) ago. Posts Made By: eralper

Refine this Search

Save these search results for 24 hours

Forum: MS SQL

Apr 16th, 2007

Replies: 12

how to delete duplicate record in a table by using SQL query

Views: 16,864

Posted By eralper

Re: how to delete duplicate record in a table by using SQL query

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...

Forum: MS SQL

Apr 9th, 2007

Replies: 1

inser into (SQL Server 2000)

Views: 2,594

Posted By eralper

Re: inser into (SQL Server 2000)

Hi,
You can use the below syntax:
insert into ... select

The exact sql is as follows:

insert into exam (e_score, l_name, s_id)
select e_score, l_name, s_id from assignment

Forum: MS SQL

May 10th, 2006

Replies: 4

In-line If-Else Block?

Views: 11,626

Posted By eralper

Re: In-line If-Else Block?

Hi,

I hope the below script may help you.

WHERE
CASE
WHEN Code LIKE 'A%' THEN OrderNumber
ELSE 10
END = 20

Forum: MS SQL

May 10th, 2006

Replies: 3

SQL Resources?

Views: 1,383

Posted By eralper

Re: SQL Resources?

Hi,
I can recommend the below sites,

http://www.sqlteam.com
http://www.sql-server-performance.com
http://www.sqlservercentral.com

And my own site :) http://www.kodyaz.com

Forum: RSS, Web Services and SOAP

Aug 16th, 2005

Replies: 2

Problem with URL access to SQL Server 2000 db

Views: 4,656

Posted By eralper

Re: Problem with URL access to SQL Server 2000 db

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...

Forum: MS SQL

Aug 16th, 2005

Replies: 10

How to get the result for smaller number divide larger number?

Views: 8,501

Posted By eralper

Re: How to get the result for smaller number divide larger number?

Hi,

Try "select (50 * 1.0/100)" instead of "select (50/100)"

Eralper
http://www.kodyaz.com

Showing results 1 to 6 of 6

DaniWeb Home > Forums > Search Forums

Search Results