Also - you are going to want to be clear about whether "3rd week"="3rd FULL week" or not.

There was a recent editorial on here about cool things you could do...

select DISTINCT name, emailID from table

Count ( column) counts the number of non null values in the column. Count(*) counts all rows regardless of nulls.

yup - with 2000, yuo need to download it from MS download center separately (they were going to charge for it, and then stopped).

andrewbrinker (10/8/2007)

---

tcp/ip in enabled under client protocols, port 1433 is allowed. no are no components installed so i didnt configure surface area. our network is behind a PIX...

Right on! Careful what you ask for - you just might get it :hehe:

Using a visual tool (allowing for rendering) like VS would allow you to view data (including images) stored in SQL. That being said - in a lot of cases...

We just stepped right through data, through metadata, and landed right in metaphysics. I think there's a huge difference between data and results on one side, and truth on...

Anyone knowing enough to navigate in query analyzer should be smart enough to find some other way around this - but you could use a group policy to prevent ANY...

Actually - it would be in the User interface form.

Assuming .NET 2.0 as a webform:

- form gets 2 visual controls, a drop-down list (with the list of...

Are you looking for a blank record between groups? Are you trying to create a report object (as in a SSRS report) of some sort? Views or single...

doesn't look like dynamic SQL would buy you any advantage whatsoever. You might try this just slightly friendlier syntax

INSERT INTO Table

SELECT 1, @Param1 WHERE @Param1 IS NOT NULL

UNION...

Actually if they're using IP, and DNS hasn't been updated (or rather - DNS still has both names pointing to the IP address) - BOTH aliases should work.

Using a select * in conjunction with group by will usually cause that, since * can't be in the group by clause.

Are you sure you're not looking to use the...

Well - that's what Steve is getting at - you don't HAVE to have a bunch of stored procedures if you're okay when them running less than ideally. ...