Also don't see any reason for folderList to be mentioned in this query.

Unless you need to slow it down.

Magy,

you're tryint to count number of hits ON WHAT?

On pages?

Then show it to you query. Put PageID into GROUP BY.

Also logic of your query is flipped over.

SELECT PL.pageId, COUNT(EL.eventTargetId) AS...

Yes, there is.

Parse XML, put data into relational database and do search from there.

And sorry, Jeff, I edited my reply while you replied on it.

🙂

In "report specific" tables typically it's not up to you or me to define names.

😉

Actually, Adrian's script is not quite perfect.

🙂

If any table or column name is happened to have spece or other "unnormal" character it will fail.

When you build any kind of generic...

paravia , blank string value cannot be implicitly converted to numeric value.

SELECT CONVERT(int, '')

will return an error

What those blanks do actually mean?

NULL? Zero? Something else?

In any case update your...

SELECT @ErrNo = @@ERROR, @RowCnt = @@ROWCOUNT

To avoid "Division by 0" error it's better to use "else NULL" instead of "else 0".

Store IP address as int or binary(4).

Convert it to varchar on SELECT using UDF and use value stored in column for ORDER BY clause.

I believe error message says it all.

Procedure xp_filesize does not in you database indeed.

But there is one in master database.

In order to call it you need to qualify SP name...

Did you try OPENQUERY, OPENROWSET?

Mark, you're facing the problem only because you don't like to read manuals and don't listen to people trying to help you.

You original format is standard ISO format, and of...

Check topic "Cross-Tab Reports" in BOL.

It describes how to build queries exactly like yours.

Good examples included.

It looks like data issue.

Try to run

SELECT

'[' + LTRIM(RTRIM(EMP_INFO_FIXED.CoNo)) + '] ' + LNK_COMPANY.CoDesc,

...