latingntlman

Great glad to hear you have solved the problem, would you care to post your code to this forum so that others with similar problems can benefit ?

Another homework question and you are too lazy to read Books On Line .... or even use Google .... or?

With 166 visits you should know how to post code so that we can readily give you a tested answer. So next time please do so.

CREATE TABLE #T(sno INT,ID...

Wayne

As one who has gotten mountains of grief from having QODs published, the mountain of grief you would have gotten if...

Too often we don't build the best software the first time. It's certainly not all our fault since there are plenty of business people that "think" they know what they...

If you will be using SSRS then this info might help

How to: Add a Page Break (Reporting Services)

http://technet.microsoft.com/en-us/library/ms156434.aspx

If above is not satisfactory .. please post asking for additional assistance, specifying...

Very nice question ... thanks Wayne

Have you tried this:

1. In the Welcome line ...click on My Account

2. On next page click on Forums Control Panel

...

Getting back to Joe Celko ..

A rather simple question posted to a forum yesterday evening with what I thought was a simple answer:

http://www.sqlservercentral.com/Forums/Topic956023-392-1.aspx#bm956671

Today along comes Joe Celko, posting an answer...

This should do it

SELECT TOP (5) WITH TIES Item, val FROM @TEST ORDER BY VAL DESC

latingntlman

With what limited data you have posted, by the way in the most awarkward format for use .... Please Please next time you post to a forum asking a...

You may also find this article by Jeff Moden of great use to you

http://www.sqlservercentral.com/articles/T-SQL/63003/

Not sure if this is what you are looking for:

DECLARE @monday DATETIME

DECLARE @Sunday DATETIME

SET @monday = dateadd(wk, datediff(wk, 0, GETDATE()), 0) -- Beginning of this week (Monday)

SET @Sunday...

Duplicate posting see http://www.sqlservercentral.com/Forums/Topic953545-1292-1.aspx

Could you post the procedure as you see it ... i.e. something like

IF (@Parm <> 0)

BEGIN

...

END

ELSE

BEGIN

.....

END

As far as running manually,...