First of all: you did an excellent job in providing sample data!!

Not seen too often...

One thing I'd like you to add: what is the output you're expecting?

Best thing would be...

The problem is the content of firstname and lastname: The character "&" causes the problem.

lastname="sddgdf@#$%^" will work

lastname="sddgdf@#$%^&" won't work.

Sergiy (9/15/2009)

---

select * INTO Temp_ CONTACTCALLDETv1

from CONTACTCALLDETv1

where 1=0

Then check the new table columns, find the one of tinyint type and find which one of the sources of the data for...

Would you mind sharing the reason for posting a request again and again that has been resolved two days ago????

You obviously didn't even take the time to look at arun's...

duplicate post.

discussion already started here .

Panchi (9/15/2009)

---

Thank You for your reply . Your solution shows fy_month_start =3/29/2009 and fy_month_end ='4/25/2009' but its supposed to be '3/27/2009' and fy_month_end ='4/23/2009' .

For 2010 the fiscal year starts...

I'd guess that the problem is within the definition of your view rather than the STARTDATE column in the SELECT clause.

Reason: The values provided for STARTDATE exceed the tinyint data...

First of all: my previous post didn't include your last post. So please disregard, since you provided the data I asked for.

Following please find a proposal to calculate your business...

I figured that one... (assuming it's always the last Friday of March).

In this case...

If you look back the last three month:

What did change in your company that wouldn't have been changed if you hadn't brought attention to it?

That could give you some positive...

What is the business rule to calculate the change to the next business month?

That's what I figured so far:

a) It's not adding 4 weeks (would leed to June 19th instead...

Hi Mike,

I wouldn't use an intermediate table just to get some ID values...

There are much more powerful and less resource intensive options available (like ROW_NUMBER).

The intermediate table would need to...

Your sample is a little confusing:

Is emp_number 3 a com_manager or emp_number 4?

If either 3 or 4 are managers, how come they have another manager the report to, who's not...

It seems like your link doesn't work. That might be one reason why you don't have an answer yet...

Hi Matt,

please follow the link in my signature on how to post sample data.

Based on what you've provided so far I think it's a job for the ROW_NUMBER function.

For...