-- Short and Efficient version

--External Parameters---

declare @Month varchar(2)

declare @Year varchar(4)

declare @n int

--End External Parameters---

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

--Test Values

Set @n = 3

Set @Year = '2004'

Set @Month = '08'

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

declare @Date_str varchar(8)

declare @dt_temp as datetime

declare @num...

How about this...

I have removed the single qutoations for clarity, you need to add it as necessary

Modify your where clause for the numCycle as below...

( (numCycle BETWEEN @CycleBeg AND @CycleEnd)...

Try this. First replace the [UserName/RoleName] with the user you want or pass '' to get all users. Replace [DB NAME] with the DB you want to get the user...

I suggest you to simplify the SP to isolate the problem. Just create a physical table with same column names and fill it with some dummy data to see whether...