It is pretty unclear what you are trying to do here but I think you want a dynamic cross tab. Please see the articles in my signature about rows to...

Be careful now. That only shows index usage. If your queries are not sargable or you have a heap your results may not be exactly what you are...

How are you going to handle those once a year type of things? I can understand wanting to do this periodically but weekly? Are you really going to drop tables...

There is nothing by default...

MadRazzi (2/22/2013)

---

Hello

I have a table with 7 columns like Cumulative_cnt, AX1, AX2, AX3, AX4, AX5, POS

i want to find the first AX column with a 'null' and assign that column...

You are right this is probably a pretty simple query. However with no ddl or...

A tally table will perform far better for this than a recursive cte. The biggest challenge at this point is that we can't help much because we don't know what...

You need to use a calendar table for this type of thing.

http://www.sqlservercentral.com/articles/T-SQL/70482/%5B/url%5D

Thanks for the details. Makes this kind of thing a lot easier!!!

Something like this?

SELECT t.*, isnull(x.ItemCode, '') as ItemCode

FROM #tTestTB t

outer apply(select top 1 ItemCode as ItemCode from #tTestTB...

I am pretty sure of what you are looking for. Can you take a few minutes to read the article found in my signature about best practices when posting questions?...

Jeff Moden (2/15/2013)

---

I have to ask... if you're not using the DATE or...

Jeff Moden (2/15/2013)

---

I don't understand why people write functions for this. No matter how many time you run the code , the values will NEVER change.

Why not...

Here is David's solution with the syntax errors corrected.

create FUNCTION fn_fibo (@end INT)

RETURNS VARCHAR(255)

AS

BEGIN

DECLARE @a INT

,@b INT

,@fib INT

,@counter INT

DECLARE @fstring VARCHAR(255)

SET @end = @end - 2

SET @a = 0

SET @b-2...

Like this?

update #X set Samp = Samp / 100000

This type of display should be handled in the front end. SQL is not good at string manipulation...