Click here to Skip to main content
12,885,022 members (30,956 online)
   

Database

 
QuestionConvert datetime to certain format Pin
vanikanc25-Sep-12 9:09
membervanikanc25-Sep-12 9:09 
AnswerRe: Convert datetime to certain format Pin
ihoecken25-Sep-12 20:58
memberihoecken25-Sep-12 20:58 
QuestionSql server topics and materials Pin
Azizullahazizi24-Sep-12 18:32
memberAzizullahazizi24-Sep-12 18:32 
AnswerRe: Sql server topics and materials Pin
Andrei Straut24-Sep-12 20:12
memberAndrei Straut24-Sep-12 20:12 
AnswerRe: Sql server topics and materials Pin
Sandeep Mewara24-Sep-12 20:23
mvpSandeep Mewara24-Sep-12 20:23 
QuestionSQL Search within a table Pin
veon cheng24-Sep-12 9:31
memberveon cheng24-Sep-12 9:31 
AnswerRe: SQL Search within a table Pin
djj5525-Sep-12 1:08
memberdjj5525-Sep-12 1:08 
GeneralRe: SQL Search within a table Pin
veon cheng25-Sep-12 3:37
memberveon cheng25-Sep-12 3:37 
Sorry its kinda messy, its from access.. the bold part is the 1 have issue. once againg sorry


SELECT Product.[Electronic Product Code], Product.[Item Name], IIf([parent - category] Is Null,[name],[Category].[name]=[category].[Category ID].[name]) AS Category , IIf([Parent - Category] Is Not Null,[name],"") AS SubCategory, Location.Country, Location.Building, Location.[Street Address], [Tracking Record].Timestamp, [RFID Reader].[Reader ID]
FROM Location RIGHT JOIN ((([RFID Reader] RIGHT JOIN (Product LEFT JOIN [Tracking Record] ON Product.[Electronic Product Code] = [Tracking Record].[Electronic Product Code]) ON [RFID Reader].[Reader ID] = [Tracking Record].[RFID Reader ID]) LEFT JOIN Has ON Product.[Electronic Product Code] = Has.[Electronic Product Code]) LEFT JOIN Category ON Has.[Category ID] = Category.[Category ID]) ON (Location.Latitude = [Tracking Record].Latitude) AND (Location.Longtitude = [Tracking Record].Longtitude)
WHERE (((Product.[Electronic Product Code]) Like &quot;*&quot; &amp; [forms]![Search History]![tbxEPC] &amp; &quot;*&quot;) AND ((Product.[Item Name]) Like &quot;*&quot; &amp; [forms]![Search History]![tbxProductName] &amp; &quot;*&quot;) AND ((Category.[Category ID])=[forms]![Search History]![cmbCat])) OR (((Product.[Electronic Product Code]) Like &quot;*&quot; &amp; [forms]![Search History]![tbxEPC] &amp; &quot;*&quot;) AND ((Product.[Item Name]) Like &quot;*&quot; &amp; [forms]![Search History]![tbxProductName] &amp; &quot;*&quot;) AND (([forms]![Search History]![cmbCat]) Is Null)) OR (((Product.[Electronic Product Code]) Like &quot;*&quot; &amp; [forms]![Search History]![tbxEPC] &amp; &quot;*&quot;) AND ((Product.[Item Name]) Like &quot;*&quot; &amp; [forms]![Search History]![tbxProductName] &amp; &quot;*&quot;) AND (([forms]![Search History]![cmbCat]) Is Not Null) AND ((Category.[Parent - Category])=[forms]![Search History]![cmbCat]));</pre>

AnswerRe: SQL Search within a table Pin
ihoecken25-Sep-12 4:13
memberihoecken25-Sep-12 4:13 
QuestionCONNECTING MSSQL DB FILE FROM PEN DRIVE Pin
r_mohd22-Sep-12 22:38
memberr_mohd22-Sep-12 22:38 
AnswerRe: CONNECTING MSSQL DB FILE FROM PEN DRIVE Pin
Eddy Vluggen23-Sep-12 2:38
memberEddy Vluggen23-Sep-12 2:38 
AnswerRe: CONNECTING MSSQL DB FILE FROM PEN DRIVE Pin
jschell23-Sep-12 8:10
memberjschell23-Sep-12 8:10 
GeneralRe: CONNECTING MSSQL DB FILE FROM PEN DRIVE Pin
r_mohd24-Sep-12 2:28
memberr_mohd24-Sep-12 2:28 
GeneralRe: CONNECTING MSSQL DB FILE FROM PEN DRIVE Pin
jschell24-Sep-12 12:37
memberjschell24-Sep-12 12:37 
QuestionDb over internet Pin
leone22-Sep-12 8:56
memberleone22-Sep-12 8:56 
AnswerRe: Db over internet Pin
Eddy Vluggen23-Sep-12 0:42
memberEddy Vluggen23-Sep-12 0:42 
AnswerRe: Db over internet Pin
jschell23-Sep-12 8:16
memberjschell23-Sep-12 8:16 
GeneralRe: Db over internet Pin
leone24-Sep-12 0:45
memberleone24-Sep-12 0:45 
GeneralRe: Db over internet Pin
Jörgen Andersson24-Sep-12 2:05
memberJörgen Andersson24-Sep-12 2:05 
AnswerRe: Db over internet Pin
Chris Quinn27-Sep-12 2:36
memberChris Quinn27-Sep-12 2:36 
Questionconnection of mssql 2008 to cloud in windows form application Pin
KUNWAR99921-Sep-12 3:28
memberKUNWAR99921-Sep-12 3:28 
AnswerRe: connection of mssql 2008 to cloud in windows form application Pin
David Mujica21-Sep-12 3:50
memberDavid Mujica21-Sep-12 3:50 
AnswerRe: connection of mssql 2008 to cloud in windows form application Pin
Eddy Vluggen21-Sep-12 4:44
memberEddy Vluggen21-Sep-12 4:44 
QuestionSQL XP_StartSMTP to send email Pin
MWRivera20-Sep-12 5:45
memberMWRivera20-Sep-12 5:45 
AnswerRe: SQL XP_StartSMTP to send email Pin
Chris Meech21-Sep-12 2:45
memberChris Meech21-Sep-12 2:45 

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.


Advertise | Privacy | Mobile
Web02 | 2.8.170424.1 | Last Updated 24 Apr 2017
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid