The transaction log files are the ldf files (Assuming normal convention of file extension). So your question is a bit confusing. Can you clarify what makes you think they are...

Can you tell us the rules for why those rows are being returned and not others?

Also you will get the best replies if you post create table statements, plus...

Thanks for pointing out my incorrect assumption - so used to including both the BEG END and GO I had forgotten which avoided the issue!

Mike John

Removed duplicated post.

One other thing to check,

In the script that CREATES the stored procedure, have you by chance got a call to the same stored procedure.

Something like

create procedure a (@params...

That is interesting, can you elaborate on what has changed please? I have not found anything documented.

Many Thanks

Mike John

Totally agree with Jack.

Mike John

I'll chip in in support of underscores to break words up and all names lowercase. Reasons are simply I have seen a db that was PascalCase moved to a system...

Glad to know it sorted the problem - thanks for coming back.

Mike John

For the characters in your example you need to use the data-type "Nvarchar" rather than "varchar".

This would apply to the column definition in the table, and any parameters in...

I think when you say "stored as in my example" you are probably referring to the ORDER of the rows in the example tables, as nothing else in there would...

I think you will need to explain more about what you mean by "mapped to" in order to get a comprehensive reply.

You can certainly install SSIS,, SSAS, and the core...

On the line that defines the CTE:

WITH cteSource ( NAME, ID, GR, SC,

You have a column called NAME, but the select that immediately follows starts with a...

While cast to decimal may have worked in this instance, I think looking at the table definition and changing the underlying datatype there would be a better option - assuming...

Float is not an exact data type. The internal storage format can mean rounding is being done that may not be visible to you. It would be interesting to get...