Search results for query: *

Ok, I have 9 levels at the moment .... it's a website struction, lots of sections and information. I have created the query as such, which seems to be fine. I just thought it could be shortened a little ... select DISTINCT M2.SectionID from TBL_SectionsTree as M1 left outer join...

Thanks Rudy, however, would a query like this drain the CPU? Is there a way to create a SP and call itself. What happens if I have 10 levels? I just keep building up the query do i? kloner

...Previous Events 45 40 2003 - Wembley Arena, London I have been trying to do a recursive query .... with no luck. SELECT M2.* FROM TBL_SectionsTree AS M1 JOIN TBL_SectionsTree AS M2 ON M1.SectionID = M2.ParentID WHERE M1.Sectionid = 37 or M1.ParentID = M1.SectionID...

...Thanks anyway guys! Happy I answered my own question ... SELECT [FunctionName], [ModuleName], [ErrorCode], [ErrorDescription], COUNT(*) AS ErrorCount FROM [dbo].[Tbl_Error] GROUP BY [FunctionName], [ModuleName], [ErrorCode], [ErrorDescription] ORDER BY [FunctionName]...

Hi guys, I would appreciate any helpon this one as I am pulling out my hair trying to get it to work. What I have got so far is a recordset with all the correct distict data. The query is below. What I am after is to also return the count of each distinct record. SQL Query: SELECT...

...SET @SectionName = (SELECT SectionName FROM dbo.TBL_Sections WHERE ID = @Root) -- SET SECTION NAME HERE -- --PRINT REPLICATE('-', @@NESTLEVEL * 2) + @SectionName SET @SectionNameToPrint = REPLICATE('--', @@NESTLEVEL * 2) + @SectionName PRINT @SectionNameToPrint -- SET PARENTID HERE...

Hi all, was wondering if someone could help me strip this string : Dim strURL strURL = /products.asp?L1=3&L2=0&PARENT_PAGEID=0&TBL_PAGEID=4&offset=50 If the string contains "&offset=" then i would like the string stripped so that it looks like : strURL =...

Anyone able to help me out here? kloner

Thankyou for your help! That worked! Can someone explain what the different JOIN's are, and what they do? kloner

SELECT E.Name, E.GroupClass, E.NIIN FROM Equipment E WHERE (E.Assessor LIKE 'te%') AND (E.ArchivedBy IS NULL OR WHERE (E.Assessor LIKE 'te%') AND (E.ArchivedBy IS NULL OR E.ArchivedBy = '') AND (E.ArchivedByID IS NULL OR E.ArchivedByID = 0) AND (E.ArchivedByPosID IS NULL OR...

...Can anyone help me here? There are only 2 levels allowed. I have been looking at a few pots and have gotten this far : SELECT RPAD( ' ', LEVEL * 2 ) || NAME AS NAME, PARENTID, WORKGROUPID FROM SEC_WORKGROUP CONNECT BY PRIOR WORKGROUPID = PARENTID START WITH PARENTID IS NULL How do...

I have just had the same problem today! WinNT\system32\msdtc.exe was hanging, using all my CPU. I installed McAfee 7.0 yesterday and thought it would be the cause of the problem. I acually booted up into safe mode, and manually stopped the service from continuing. Have now uninstalled McAfee and...

Hi all, In VBSCRIPT, how do you print a &quot;<BR>&quot; after every 15 characters of a string? eg strTempString = &quot;abcdefghijklmnopqrstuvwxyz123456789098gfjkgdfgkd&quot; and output would be : abcdefghijklmno <br> pqrstuvwxyz1234 <br> 56789098gfjkgdf <br> gkd Thanks kloner

Thanks for that, however I am still after a solution to display all 'NAMES' starting with 'A' (or any other letter), but ignoring all numbers and symbols until I reach the 'A'. eg. 'T' would be ... 2-(4,4,5,5-Tetramethyl-1,3,2-dioxaborolan-2-yl)phenol ignoring the &quot;2-(4,4,5,5-&quot...

...all numbers and symbols. For example I want my query to display the word &quot;4-Acetamidophenylboronic&quot; when I do something like SELECT * FROM TBL_PRODUCT WHERE (TBL_PRODUCT.NAME LIKE 'A%') ORDER BY SORT Now I want to somehow ignore the &quot;4-&quot; and still display...

Hi all, I'm going crazy! I need to format a formula. I have a string that looks like this &quot;a56c5t78h10K7&quot;. What I need to do is somehow loop through the string and append the html tag  around the integers. eg final string returned should look like ...

HI all, I was wondwring if it was possible to created a share on a specified folder in VB 6.0. I have looked everywhere for some help but to no sucess. EG. Directory is C:\MY_DEMO And I want to share it under the name &quot;MY_DEMO&quot;, and let only authenticated people have full control...

HI all, I was wondwring if it was possible to created a share on a specified folder in VB 6.0. I have looked everywhere for some help but to no sucess. EG. Directory is C:\MY_DEMO And I want to share it under the name &quot;MY_DEMO&quot;, and let only authenticated people have full control...

Hi all, I'm trying to create a IIS 5 application with virtual directories etc using Visual Basic. Can someone please tell me what reference library I should be using. I am using VB 6.0. thanks so much kloner

Hi all, I'm trying to create a IIS 5 application with virtual directories etc using Visual Basic. Can someone please tell me what reference library I should be using. I am using VB 6.0. thanks so much kloner