Click here to Skip to main content
15,916,846 members
Home / Discussions / Database
   

Database

 
GeneralRe: Extract number from string Pin
kyi kyi29-Oct-08 18:06
kyi kyi29-Oct-08 18:06 
GeneralRe: Extract number from string Pin
Meysam Mahfouzi29-Oct-08 20:02
Meysam Mahfouzi29-Oct-08 20:02 
QuestionUsing SQL as categorized tagging backend Pin
jchalfant29-Oct-08 4:36
jchalfant29-Oct-08 4:36 
AnswerRe: Using SQL as categorized tagging backend Pin
Wendelius29-Oct-08 8:12
mentorWendelius29-Oct-08 8:12 
GeneralRe: Using SQL as categorized tagging backend Pin
jchalfant29-Oct-08 8:37
jchalfant29-Oct-08 8:37 
GeneralRe: Using SQL as categorized tagging backend Pin
Wendelius29-Oct-08 8:53
mentorWendelius29-Oct-08 8:53 
AnswerRe: Using SQL as categorized tagging backend Pin
Ashfield29-Oct-08 9:53
Ashfield29-Oct-08 9:53 
GeneralRe: Using SQL as categorized tagging backend Pin
Wendelius3-Nov-08 9:19
mentorWendelius3-Nov-08 9:19 
QuestionAlternative to SOUNDEX? Pin
Richard Jones29-Oct-08 3:54
Richard Jones29-Oct-08 3:54 
AnswerRe: Alternative to SOUNDEX? Pin
Wendelius29-Oct-08 8:05
mentorWendelius29-Oct-08 8:05 
GeneralRe: Alternative to SOUNDEX? Pin
Richard Jones29-Oct-08 9:15
Richard Jones29-Oct-08 9:15 
GeneralRe: Alternative to SOUNDEX? Pin
Wendelius29-Oct-08 9:36
mentorWendelius29-Oct-08 9:36 
GeneralRe: Alternative to SOUNDEX? Pin
Richard Jones29-Oct-08 9:40
Richard Jones29-Oct-08 9:40 
GeneralRe: Alternative to SOUNDEX? Pin
ChandraRam30-Oct-08 1:23
ChandraRam30-Oct-08 1:23 
QuestionSSIS - Multiple packages using the same sharepoint path Pin
notes4we29-Oct-08 3:03
notes4we29-Oct-08 3:03 
Questionhow to get in report watermark text Pin
imranafsari28-Oct-08 23:56
imranafsari28-Oct-08 23:56 
QuestionEmbedded Fire Bird - Programmatically creating a new database [solved] Pin
Harvey Saayman28-Oct-08 23:54
Harvey Saayman28-Oct-08 23:54 
Questionincrement number Pin
susanhalim28-Oct-08 21:35
susanhalim28-Oct-08 21:35 
AnswerRe: increment number Pin
notes4we29-Oct-08 3:09
notes4we29-Oct-08 3:09 
AnswerRe: increment number Pin
PIEBALDconsult29-Oct-08 5:05
mvePIEBALDconsult29-Oct-08 5:05 
AnswerRe: increment number Pin
mahsa shahi1-Mar-14 7:09
mahsa shahi1-Mar-14 7:09 
Questioncategory tree like structure in sql Pin
S.Dhanasekaran28-Oct-08 21:13
S.Dhanasekaran28-Oct-08 21:13 
Hi all, i am building a category tree like structure for my FAQ app. i need to show all active categories. The hitch is that

if a parent category is checked as inactive, then the sub or child categories under it should not be displayed even if they

are marked as active. I need a query which will return me such a resultset which i can display in a table. the columns in my

table are categoryid, category, ParentcategoryID,companyID and active. The ParentcategoryID contains id of another category

or 'No parentcategory' which denotes its the main category. It is easy to get the immediate parentcategory and find out if

its active or not. But to find out if that parent category's parent and so on is active or not is tough. please help.
AnswerRe: category tree like structure in sql Pin
Wendelius29-Oct-08 8:00
mentorWendelius29-Oct-08 8:00 
Question[Message Deleted] Pin
kyi kyi28-Oct-08 17:22
kyi kyi28-Oct-08 17:22 
AnswerRe: Function problem Pin
balaji.t28-Oct-08 22:17
balaji.t28-Oct-08 22:17 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.