Basicially I have data in SQL databases I want to be able to put up on a website. So I think this is OLAP.

I'm just keen to know what web analytics involves. I use SAS and SQL for datawarehousing but I need a way of doing web based analytics. Is this through SSRS...

this may not be much help, but I would use an SSIS package to do what you are doing,

are you setting up a staging table (create table) from a source...

I am trying to understand what the update does in the below code and trying to understand by doing that other example. In this example I do not understand how...

Yes that is correct Wayne thanks very much

ok, I am just learning SQL so would like to use a cursor if possible then i'll look for a solution without using them.

I have created a table called "demo"...

cheers mate, very much if I can help let me know

what do you work in?

thanks heaps for the reply, do you mean this?

**************************************

While @@FETCH_STATUS = 0

begin

if @Statisticvalue <=100

Begin

and does the 2nd 'end' go with the last end?

thanks Craig

cheers thanks heaps for this, used print and it does nothing. Is the set @x statement actually correct?

Thanks, but have changed it to @Tablename in first fetch statement but tried "print" and getting nothing, it seems its correct though, anything else I've missed?