Thanks I started to update the tables to the correct data type. Would you know of an easy way to update the value with say 400000 rows. I have one...

In there current query they don't use a a date range rather they go by the year that is hard coded in the query this is one of the columns...

Ill try this out. I copy pasted the script not the one you updated they are both the same except the where clause. The reason they needed dbo.tblLoan.Expected_Close = 9).

Is...

Yes this is the same query they just wanted instead of actual date range tblProcessingFile.Funded to (dbo.tblLoan.Expected_Close = 9) because some actual close on the 1st through the 5th.

Is there...

Thank you that worked perfectly and now of course, the requirement changes a little. I have been asked where this Expected_Close = 8) is in the where clause.

Could someone...

Ok Thanks I will move to raise the level so I can use the new functionality. Thanks for your help

I have just came across this compatibility issue in my new company. The original DB was created SQL 7. or compatibility 70

My question is if there isn't any issues with...

Yes is makes sense, So I tried to add my own link into the subscription which i can use the date picker but when the link is sent out to...

Thanks I got it.

Yes agreed. But this is coming from our VP and this is what he wants done.

I was using this to try and get all the nullable columns, Can you tell me if this looks correct. Even if I run the script suggested in the last...

Hello Im still struggling with this. Any suggestions on he syntax. THis would be one column in the index to desc leaving the rest to asc.

We have to do this...

Yes we tested both ways. Having the index in asc slows our system down. The developer stated because all the rest of our things are created to use desc order.Some...

Yes this has een tested and I saw it also. My boss and development team has been working on this and then tasked me with the change.

Thanks for your help

Yes that is correct one column in the index. This should have been set these way before. We are changing a few thinks to use RANK and it's going to...