DECLARE @FILENAME TABLE (PHONE VARCHAR(10))

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=186228

In this post you will find that.

This is how I made it with syscolumns. I don't want to ype 18 columns (original table has 18 columns and 18 row report). Also it helps to sort the...

I mis-read the original post.

Can you play around like this and post the results

/* Just to analize the data */

SELECT KeyField, * FROM dbo.EBTable WHERE KeyField IS NULL --...

Thanks Scott. Noel gave the idea and I did something close to what you did to get my result set. Yes with xslt it would be elegant and easy. But...

No Noel. Instead of typing 18 columns I can get the columns for category like that. I would do it in client if it is simple asp report. This needs...

Cool. Thanks Noel.

With 18 columns (Report will have 18 rows) that will be a big query. But if I want to use SQL to compute I have to do it.

Key field has value as 'NULL'.

It is not counted as NULL. It happens when you make a wrong query to insert nulls

SELECT COUNT(*) FROM dbo.EBTable WHERE KeyField IS NULL OR...

Some one did not get the question. It was me. May be again.

Null values are ignored in aggregate function if you want to ignore them try using this

SELECT COUNT(DISTINCT COALESCE(ProductID,...

DECLARE @myCol VARCHAR(50)

DECLARE @myNum FLOAT

SET  @myCol = '12.50'

SELECT @myNum = CASE WHEN ISNUMERIC(@myCol) = 1 AND @myCol <> '-' AND @myCol <> '.'  THEN CONVERT(FLOAT, @myCol) ELSE 0 END

SELECT @myNum

SET ...

SELECT [ProductID], COUNT(*) AS Expr1 FROM [Order Details] GROUP BY [ProductID]

Sure Hanslindgren it doesn't matter. I would say some places it is easy to implement than other places.

As I mentioned the idea is...

Thanks Vasc. It works now. Let me see whether I can reproduce it in SQL.

Recursive is way too fast than non recursive. Check 1200. Not found is the answer.

Can that program check whether there are any rows in the staging tables.

1. Create one step to check whether there are still rows in staging table that needs processing....

Vasc - I trying to make your VB non-recursive logic without sucess. Can you please post the entire form code as that I can save as .frm and work. I...