HI Dave,

If you wish to challenge yourself, try and look at the system tables and see if you can do it from there!

I'm not sure if it is possible but...

HI Adam,

Could you please post the query you are running.

I'll then have a look at this and try and point you in the correct direction.

thanks

Chris

HI There,

I'm not sure if this is what you are looking for.

I have not displayed all the columns you are looking for but I am sure you will get the...

Hi There,

I'm not a pro at this either but have come across this problem before myself.

Can you find out if it is the same code that is blocking with this...

what data type is you Sal column?

have you tried using the osql command in .BAT file?

I'm suer hwo you going to be running your proc.

If you can run it from a .BAT file or a dos...

I'm using 2005 but I'm pretty sure the same applies to 2000 if my memory serves me well.

Click on "Query" on you menu bar and there should be a Query...

Confused...

If you gonna do a nested select in the main select section of your query. You may find that a left join in the main query will give you better...

HI there,

What values do you have the SystemUsers table?

It seems that the inner join is filtering the results to nothing, which makes me thing the systemUsers table has no records...

Sorry all I forgot to change the column names on my last post.

This solution should work:

CREATE TABLE #tblDates

(

ID...

Hi guys,

I'm having a slow afternoon so tried to do some performance tuning based on the above with table A(40015 rows) and table B(455990 rows) 

the first solution comes back with...

Hi Dave,

I have played around with this today and I have found a solution.

Please not that the bigger your table gets you may need to do some optimization. But for...

I would have to agree with Lynn on this one.

How may loops is your cursor doing?

It's not recomended to user cursors all the time as they have been know to...

Hi Danny,

Another thing that you could try is to created indexes on your temp tables this may help the query joins the tables start to get bigger and bigger.

Hi Dan,

I've found some interesting results with your code.

What have found is that the REAL datatype is loosing one decimal space and in turn is change the result when you...