J Livingston SQL (7/29/2015)

---

dandenise316 (7/29/2015)

---

Thanks for the input guys..

I tried using the second solution with month(n.campaign_date)

..

WHERE

day(campaign_date) between 1 and 23

And I'm getting the following error.

ERROR: 42883: function day(timestamp without...

below86 (7/29/2015)

---

Not to be to political, but people 'hired' George W. Bush because 'He was someone I could see having a beer with'. That turned out to be a...

Lynn Pettis (7/29/2015)

---

See my select statement at the end. I use your code to set the stage.

DECLARE @fiscal_year INT

SET @fiscal_year = 2015

DECLARE @fiscal_period INT

SET @fiscal_period = 11

DECLARE @Year SMALLINT,...

See my select statement at the end. I use your code to set the stage.

DECLARE @fiscal_year INT

SET @fiscal_year = 2015

DECLARE @fiscal_period INT

SET @fiscal_period = 11

DECLARE @Year SMALLINT, @Period TINYINT;

DECLARE...

J Livingston SQL (7/29/2015)

---

you havent given any us any scripts to set up sample data plus the DATE_TRUNC is not MS SQL

but heres an idea for MS SQL

SELECT TOP...

armoredeagle (7/29/2015)

---

I have seen the same type of error and I agree that basically the reason is that the column INSPTYPE is specified explicitly and is also include in the...

This doesn't answer the question directly, but hopefully it helps you come up with a solution.

with rCTE as (

select

ag.id,

ag.catlevel,

...

Not based on what you have posted so far. If you post the DDL for the table(s) including indexes and the execution plan (without the hint) as a *.sqlplan...

Okay, obviously you are set on doing this using a loop instead of taking an opportunity to see if there may be a better way to accomplish the task.

Okay, time for a Chicken Dentist 'cause I'm done trying to pull teeth on thread where someone thinks a loop is the only way to accomplish a one off report...

How about answering the question as to why you have to process...

When working...

sqlguy-736318 (7/27/2015)

---

Hi, can I safely use top n select/delete in a while loop? For example:

declare @FieldVal int

while (select count(*) from @MyTempTable) > 0

begin

select top 1 @FieldVal = FieldVal from...

You do know that this is a 6 year old thread, right? The OP never really provided enough information to really give...

This has been deprecated:

Using the below query.

set rowcount 1

select * from employees order by id desc

Use TOP instead.