What requirement cannot be achieved with Lowells solution?

The BETWEEN clause will "fetch data for next 3 months" as per your requirement.

If you need more assistance you might want to...

Standard answer for non-precise questions:"It depends"

If you import those sample data into one column: the variable length doesn't matter as long as the column is wide enough.

If you need to...

Did you try the GROUP BY clause (for details please see BOL)?

On my system the 2k5 templates are located at

"C:\Programs\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\sqlworkbenchprojectitems\Sql\Stored Procedure\"

It's easy to modify those templates.

Ray K (2/1/2010)

---

lmu92 (2/1/2010)

---

If you feel to have a look at a thread named

VERY UNIQUE PROBLEM: Updating Table with XML Data in SQL 2005

Updating Table with...

If you feel to have a look at a thread named

VERY UNIQUE PROBLEM: Updating Table with XML Data in SQL 2005

Updating Table with Column Type of...

The main reasons why I think you didn't get an answer yet:

The "sample data" you posted are obviously so huge that it takes forever to open that thread. I strongly...

They actually have. Sort of, at least...

But is doesn't have anything to do with...

Since you start "from scratch" you might want to consider storing the hierarchy data as nested sets. For details please search for "Celko nested sets hierarchy". It might be a...

Easiest way would be a calendar table holding each day in one column and the fiscal year information and other stuff you might need (e.g. work day yes/no, holidays) in...

Instead of relying on forum information you could use BOL (BooksOnLine, the SQL Server help system) to get the information you're looking for:

varchar [ ( n | max ) ]...

I would add that "feature" to the SQL script (so you can run and test it separately).

You could either store the result of each query in a temp table or...

If you add...

You don't have to provide your real data. Get the basic concept and transform it...

add

AND A.Piloto LIKE 'ACD%'

to your WHERE clause.

If that's not what you're looking for please provide sample data and expected results as described in the first link in my...