Search results for query: *

Thanks for the info, I'll check it out!

If you click on it, do you get "Sites and Workspaces" ? If so then that's a list of subsites and wokspaces that your main sites has. If it's not "Sites and Workspaces" then I'm not sure what you are referring too.

Hello guru's, I'm importing data in access that have html tags and need to get rid of them. I can't think of any easy way of doing this but with a macro that would search for values and replace them with spaces by means of an automated solution. I know there's a find / replacement functions in...

I have a list in sharepoint that I loaded in an access table(through external data link). All the html tags are shown in my data i.e.: <p> or <div>. The easy solution would be to turn off HTML text in my lists in sharepoint, but I can't afford to do that. Anyway I can easily remove these...

I understand the data position, but like James said, we need to see values to help you further...

Look up AQT - Advanced Query Tool - Great tool, and it will definitely do your first point, for the second one, I'm unsure. http://www.querytool.com/index.html

I'm unsure if your Mydate field is datetime or varchar or char so here's your first option... If your field is datetime, then the below code will wipe any record that is greather than or equal to 7 DELETE FROM History WHERE CONVERT(int,DATEDIFF(day, MyDate, getdate()))>=7 IF your Mydate...

I rarely write code with declares, but use the CASE statement all the time. I only use the CASE statement in the SELECT condition. So I don't know if having a CASE statement in the WHERE condition will work. Again because of your declares, I'm unsure where you would put your case statement...

yeah my bad. There shouldn't be a space after the *. So the code should be this way WHERE rls.lse_s *= rar1.lse_s and rls.lse_s *= rar2.lse_s and rls.lse_s *= rar3.lse_s and rls.lse_s *= rar4.lse_s This will work. Sybase will accept the *, I run all my queries in sybase. Give it a hoot...

I took a stab at it, I just coded it differently. since I don't have the data, I wasn't able to test it. So the query might require some small corrections. So I assumed you had these 2 tables with these columns. select lse_s (LEASE #), tamt_b_d (AMMT), d_pmtdu_s (DT) from rar select lse_s...

Are the values you are trying to insert stored anywhere? If so, then: INSERT INTO TBL_STATES (STATENAME,ABBREVAITESTATE) SELECT (column that has the statename), (column that has the abbrev state) FROM (the table that has this date) If not, then this is the only way to go: INSERT INTO...

Thanks for taking the time to write out the sp. I'm not an sp expert, but seems pretty straight forward. I'll give it a try. Thanks

I need to accomplish a select of records with a max rowcount. Let me try to explain. I have over 2 million records that would of hit different strategy types and strategy ids. I want to simply select a population of 5 records(call them refno's) for every strategy type for every strategy ID. I...