Glad I could help.

Just a little tip, you should share what you are really trying to do, unless doing that would violate some policy at your office. Then just...

Carl Federl (8/20/2008)

---

Were you aware that the "WHERE" conditions are applied after the "OUTER JOINS" are performed, so should any of the columns be in the outer joined tables, this...

Okay, I understand what you mean now. As far as my code, you can ignore all but the update as the rest is just generating some data to test...

If you are just calling the SP in VB 2005 using a command object it does not change the query within the SP. Can you post your VB Code?

The...

craig (8/20/2008)

---

Thanks, but your case statement doesnt take into account for leap years, or peoples birthdays who have yet to occur yet in the current year. But the idea looks...

Yes you can use a CASE expression. Also if you already have the CASE in your Select you can just reference the alias for the CASE.

You could do this:

[font="Courier New"]UPDATE dbo.Persons

      SET title = CASE

                       WHEN DATEDIFF(YEAR, GETDATE(), birth_date) >= 50 THEN 'Sr'

                       ELSE 'Jr'

                   END

[/font]

To set up a global or default profile go to Database Mail -> Right-click -> Configure Database Mail. Select "Manage profile security" and on either the public or Private...

Nope, there is only Order By [column_name(s)] asc/desc.

Not that I am aware of.

BTW-if your question pertains to SQL Server 2000 you should have posted it in a SQL Server 2000 forum.

You could use sys.dm_db_index_usage_stats to tell. You would have to do some aggregation of columns and rows, but it looks like it would work.

This is probably better than trying...

What does the Reporting Services Configuration Manager say? In Start -> Programs -> Microsoft SQL Server 2005 - > Configuration Tools. I believe you can install the databases...

Kenena Klosson (8/20/2008)

---

Hello,

I am creating a stored procedure that will run 6 other stored procedures. Why do you say not to use the BEGIN/END. Also where does GO...

It would be easier to help if we knew the error you were getting. Several folks have looked at the post, but can't answer because we don't know the...

You can use the Row_Number function to set the sequence. It works like this:

Row_Number() Over(Partition By ProdNum Order By ProdNum)

Partition By says to restart the numbers when ProdNum changes....