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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.