quote:

---

Hi everyone,

I am relatively new to this forum and I tried very hard (for the past hour) to find an answer...

I would do a check first to see if the row already exists, then do an insert if it doesn't exist or an update if it does. Something like this:

IF...

I agree you should try upgrading MDAC, but could you show the SQL statement?

--

Chris Hedgate @ Apptus Technologies (http://www.apptus.se)

http://www.sql.nu

quote:

---

I am guessing it may not be the worms floating around because I have changed the sa password as soon as I...

I don't know of any common problems running SQL 2000 on NT4 and have done so myself without trouble. One thing to note however is that SQL 2000 will update...

A good option if you need to test the upgrade is to install SQL Server 2000 as a named instance and copy the database to the new instance. If everything...

Yes, newline is usually used to mean line feed (10) + carriage return (13), though newline is really just a synonym for line feed. So the question is which you...

Maffan76, for some info on joins read this article on sql.nu: http://www.sql.nu/articles/joins.shtml

Regarding your sum question, is this what you mean?

SELECT CASE WHEN SUM(somecol) > 1000 THEN 1000 ELSE SUM(somecol) END...

I gave this URL earlier today in another thread, it is probably the best article on dynamic sql in SQL Server.

http://www.algonet.se/~sommar/dynamic_sql.html

--

Chris Hedgate @ Apptus Technologies (http://www.apptus.se)

http://www.sql.nu

You can run the stored procedure before running the 'real' select statement, storing the returned value/table in a variable/temp table/table variable, then use this in the 'real' statement.

--

Chris Hedgate @...

quote:

---

Then, tell you what guys:

its MySQL and Good Design from now on!

Damn the vendors!

---

Ehm,...

Just remembered possibly the best article on this matter, written by Swedish MVP Erland Sommarskog: http://www.algonet.se/~sommar/dynamic_sql.html

--

Chris Hedgate @ Apptus Technologies (http://www.apptus.se)

http://www.sql.nu

What do you mean by 'developing SQL code'? Creating stored procs? Then I would suggest Query Analyzer, you really don't need more.

--

Chris Hedgate @ Apptus Technologies (http://www.apptus.se)

http://www.sql.nu

The solution presented in the other thread does work for your solution, you just need to create a dynamic sql statement of your query and concatenate your string of values...

Remember to remove the BUILTIN\Administrators account from SQL Server to get back at your admin so he can't access you SQL Server.

Seriously though, agree with Steve...