Forum: MS SQL  Apr 16th, 2007 |
| Replies: 13 Views: 26,971 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 Views: 3,595 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 Views: 21,069 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 Views: 1,704 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 Views: 5,455 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 Views: 11,172 Hi,
Try "select (50 * 1.0/100)" instead of "select (50/100)"
Eralper
http://www.kodyaz.com |
