I'm going to repeat what a couple of other people said. Let people you know know you are looking, even if you don't know them well.

Attend tech events/user groups....

jcrawf02 (7/15/2009)

---

Steve Jones - Editor (7/15/2009)

---

That happened to me as well, Grant. Had to email them to get it fixed. took about a day.[/quote

]

Grant Fritchey (7/15/2009)

--------------------------------------------------------------------------------

My Twitter account just got...

Uh-oh,...

First you create your datasets like Products, ProductType, ProductName. Then in the ProductType dataset you put a parameter in the SQL for your ProductID. and then the same...

I have to agree with Steve on this one. I think the rules change a bit when working on a shrink-wrapped or commercial product, but for in-house development you...

I believe you are correct. It is the sp_ that causes SQL Server to look in master first, but, imo, you really don't need to prefix stored procedures and...

You design reports using Business Intelligence Design Studio (BIDS) which is included in the SQL Server 2005/8 client tools install, or if you already have VS 2005 installed it adds...

Here's what you need:

with Dups

as (SELECT

...

Can you post table definitions, some sample data, and the expected/desired results from the sample data? The first article linked in my signature explains how to do this and...

Can you post some sample data? Please see the top article in my signature for how to post the sample data.

Oops, you are correct, I only verified the rows returned and the 1st 2 columns assuming I had the others correct. Boy, I wish 2000 had row_number().

Sorry, permissions for running Profiler/Trace are at the server level and cannot be assigned or revoked by database. Pre-2005 you would need to be sysadmin, post-2005 you can assign...

I would say that LeeM's suggestion is the only way to make it happen. Since the ID's can be in any order you need some kind of indexer to...

Jan Van der Eecken (7/14/2009)

---

Guys and Gals, you are freaking me out! I've been out of the office for not even six hours and there are already 38 new notifications...

The best way to do it is to allow a person to edit a record (a record may be more or less than a row in the database) in the...