Click here to Skip to main content
15,920,383 members
Home / Discussions / Database
   

Database

 
Generalbcp Pin
sardinka1-Oct-03 3:07
sardinka1-Oct-03 3:07 
GeneralUpdating Related Tables Pin
Wjousts30-Sep-03 11:07
Wjousts30-Sep-03 11:07 
GeneralRe: Updating Related Tables Pin
STW2-Oct-03 7:29
STW2-Oct-03 7:29 
GeneralRe: Updating Related Tables Pin
Wjousts2-Oct-03 8:54
Wjousts2-Oct-03 8:54 
GeneralRe: Updating Related Tables Pin
STW2-Oct-03 22:31
STW2-Oct-03 22:31 
GeneralRe: Updating Related Tables Pin
Wjousts3-Oct-03 4:52
Wjousts3-Oct-03 4:52 
GeneralRe: Updating Related Tables Pin
Wjousts3-Oct-03 5:20
Wjousts3-Oct-03 5:20 
Generalwhere close Pin
sardinka30-Sep-03 5:05
sardinka30-Sep-03 5:05 
I am getting an error msg:
"The conversion of char data type to smalldatetime data type resulted in an out-of-range smalldatetime value."
when I have the following code in where close:
and n.dateentered between (case
When DatePart (dw , getdate())=2 Then (getDate()-3 )
When DatePart (dw , getdate())=4 Then (getDate()-2 )
When DatePart (dw , getdate())=6 Then (getDate()-2 )
Else GetDate() End ) and (getdate()-1)
but when I run with this (I put dates manually) it is fine.
and n.dateentered between '09/20/2003' and '09/29/2003'
Any idea why?
GeneralRe: where close Pin
Edbert P16-Oct-03 20:45
Edbert P16-Oct-03 20:45 
Generaladd record to a database Pin
ranjjj30-Sep-03 4:33
ranjjj30-Sep-03 4:33 
GeneralGetting the SQL commands from OleDbDataAdapter.Update Pin
Wjousts29-Sep-03 10:38
Wjousts29-Sep-03 10:38 
GeneralRe: Getting the SQL commands from OleDbDataAdapter.Update Pin
Guillermo Rivero29-Sep-03 11:53
Guillermo Rivero29-Sep-03 11:53 
GeneralRe: Getting the SQL commands from OleDbDataAdapter.Update Pin
Wjousts29-Sep-03 12:18
Wjousts29-Sep-03 12:18 
GeneralRe: Getting the SQL commands from OleDbDataAdapter.Update Pin
Wjousts30-Sep-03 4:57
Wjousts30-Sep-03 4:57 
GeneralRedistribute MS DataGrid Control Pin
pallattila29-Sep-03 7:57
pallattila29-Sep-03 7:57 
GeneralRe: Redistribute MS DataGrid Control Pin
Steve S30-Sep-03 5:21
Steve S30-Sep-03 5:21 
GeneralSQLServer and XML RAW Pin
Guillermo Rivero29-Sep-03 7:45
Guillermo Rivero29-Sep-03 7:45 
GeneralRe: SQLServer and XML RAW Pin
Mike Dimmick1-Oct-03 12:43
Mike Dimmick1-Oct-03 12:43 
GeneralRe: SQLServer and XML RAW Pin
Guillermo Rivero3-Oct-03 2:37
Guillermo Rivero3-Oct-03 2:37 
GeneralPrimary Key as a Foreign Key Pin
DotNet_Newbie29-Sep-03 6:44
DotNet_Newbie29-Sep-03 6:44 
GeneralRe: Primary Key as a Foreign Key Pin
STW2-Oct-03 22:40
STW2-Oct-03 22:40 
Generalado.net Pin
Member 23171029-Sep-03 0:37
Member 23171029-Sep-03 0:37 
GeneralRe: ado.net Pin
Roger Wright29-Sep-03 5:17
professionalRoger Wright29-Sep-03 5:17 
GeneralWinforms - Menu Generation from SQL Database at runtime Pin
sunny12328-Sep-03 22:47
sunny12328-Sep-03 22:47 
GeneralRe: Winforms - Menu Generation from SQL Database at runtime Pin
Guillermo Rivero29-Sep-03 8:09
Guillermo Rivero29-Sep-03 8:09 

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.