I would recommend, rather than trying to write a single query, you write three seperate stored procs, and call the one that you need from the front end.

With a stored...

Please don't post multiple times for the same problem. It fragments replies and wastes people's time

Continue here please

For SQL 2005, the first exam you need to write is the Technical Specialist exam. After that, you'll probably want to do the IT Professional Database Developer Certification.

All the info...

Did you try it?

Then run it in a loop a few thousand times, inserting into a table with an identity.

Is there any reason you refuse the first suggestion offered fo a particular problem...

Did he give you a reason why? Sound a bit strange.

Here's one that doesn't actually use replicate, but does the same thing as replicate would.

DECLARE @Length INT

SET @Length = 4

SELECT...

And please post the ASP code you're using to connect and submit query.

Cross join the table in a couple more times untill you have the number of rows you need.

Why the restriction against replicate?

Possibly, but if the requirement is that all rows other than where column=0 or...

karthikeyan (12/31/2007)

---

As you told if we want to display -1 or some other negative values,

we need to write,

select * from sometable where column > 0

select * from sometable where...

I did see your post. And, no, you don't "need to execute SET ANSI_NULLS OFF.Otherwise the above statement will give wrong output."

I specifically wrote that to illustrate how nulls...

This connection string requires that the login has access to the DB Atab. If it doesn't, you'll get the error message you described earlier.

The second...

karthikeyan (12/31/2007)

---

SELECT * FROM sometable

WHERE Column2 IS NOT NULL

AND Column2 <> 0

So the Better way is,

Select * from sometable

where Column2 > 0

Will...

You missed the point.

NULL is not a value. It's a placeholder for 'unknown'. Because it is an unknown value, it is not equal to anything. It's not unequal to anything...