Alvin Ramard (5/20/2009)

---

Jack Corbett (5/20/2009)

---

I have to admit being disappointed you didn't say something like:

"Use the...

4 million rows * 4 = 16 million rows

5 ms * 4 = 20 ms

Seems like your query is performing in a fairly linear progression. Granted I've never worked...

No Problem.

-Luke.

This could be done one of two ways...

First, you could add the parameters to your where statement of your query to only bring back the details you want. ...

Hey Alvin, Don't forget your DigiCam so we can all see it 😉

Any chance you could elaborate a bit more on this?

An HTML Report could be used just like any other piece of HTML code. You generate it using the HTML...

IDS software is great. IF this is particularly for a website the best IDS service can still be gotten around. Like AntiVirus services, most IDS systems work on...

I'd suggest you use a table instead of a list in your report.

Since you didn't specify I'm assuming you're writing the report in Visual Studio, not report builder. Also...

I guess what I was trying to say with my example, is that you could still ahve your report as it, with no additional table and just pull out the...

You could do this a couple of different ways. Create a lookup table and join to it in your query as you suggested. This could well be something...

If this is a one time thing than most any of the database comparison tools should work as they all have trial version. I've had decent luck with RedGate's...

Seems you updated your post as I was posting...

My question still stands, but I also would like to bring up something you may or may not be thinking about... ...

David Kranes (5/18/2009)

---

Hello, I am trying to write a simple insert trigger that will check if a row exists in a table based on the inserted values. If so...

Is there any reason why you can't just do this all in one query in your database using a Join?

Instead of creating 2 datasets, just create one dataset...

I stand corrected, apparently it can be done, but according to the discussion from that article there are a number of caveats. One of the more important is the...