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
Hi all,
I am pulling my hair out here! I am trying to select all the children records from the following data (i.e. I need to return all of the data you see below.)
The only 'where clause' data is have is WHERE ID = 37
[ID] [ParentID] [Title]
37 1 BIG GIG
38 37...
Ah I finally worked it out! 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]...
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...
Hi all,
I am getting close to solving my problem, however some extra help would be great as I am now stumped!
I have a table that contains 'Sections'. There is a root section and many children, which can have more children etc. As you can see from my tree result below, the output is looking...
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 =...
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...
Hi all,
I am trying to write my first hierarchical query in oracle 8i. The data I have is as follows :
WID Name ParentID
1 Telecomunications NULL
2 Mobiles 1
3 Handheld Phones 8
4 Foxtel 1
5 Wholesale NULL
6...
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 "<BR>" after every 15 characters of a string?
eg strTempString = "abcdefghijklmnopqrstuvwxyz123456789098gfjkgdfgkd"
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 "2-(4,4,5,5-"...
Hi all,
I am trying to come up with a way to ignore numbers and symbols in my query for a particular field.
If i have a word like "4-Acetamidophenylboronic" I want to ignore all numbers and symbols.
For example I want my query to display the word...
Hi all,
I'm going crazy! I need to format a formula. I have a string that looks like this "a56c5t78h10K7".
What I need to do is somehow loop through the string and append the html tag <sub></sub> 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 "MY_DEMO", 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 "MY_DEMO", 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
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.