what happens when you run a select * from SSMS? (are there still no rows)

If this is only happening from the .NET side have you tried running a trace to...

I agree with the others.

Have some more questions.

What are the actual speeds that are showing across the line? perhaps there is conjetion.

Also is this the only query where you have...

I guess we gonna have to ask for the execution plan.

I did notice that you don't have a covering index for OrgId, OrgName

but lets see what the plan says...

is a query in access? or is it a dynamic string run via ADO?

Also what are the connection speeds between your access app and the SQL server?

HI Gail,

Thanks again,

I have just created a few tables and played around with different data selectivity and with the columns being returned. I tried to work out before running the...

Hi Gail,

After the first seek is done are the other filters done on the index or resultant dataset return from the first filter(Index seek)

Also I guess I need to ask,...

what are the statistics on those indexes?

Also could you post the queries that you expect are giving diff results.

With samples of how the results are different. 🙂

Also here is another way to do what you doing:

DECLARE @strSKU VARCHAR(20)

SET @strSKU =...

mmm

I wish I could lie to you , but yes it is possible, but as most people here will tell you, you should avoid using cursor and definitely avoid nested...

Welcome to SQL servercentral 🙂

Please click on the link in my sig for help on how to post to get the best results.

could you give us some sample data and...

you would call it the same way you would if it was outside of a stored procedure.

What kind of function is it.

If you show us the function we can show...

The concept of Merge Join IS also used in SQL Server.

Here is a link to BOL

http://msdn.microsoft.com/en-us/library/ms141775.aspx

I guess it just depends how he wants his output?

Does he want a value of length 16 or is the max length 16?!?

could you give us some examples please.

What would you expect to be returned from the following

12345678 = 0000000012345678?

123 = 00000000123 or 0000000000000123

0 = 000000000 or 0 or 0000000000000000

etc...

Thanks

Chris