Click here to Skip to main content
15,867,771 members
Home / Discussions / Database
   

Database

 
GeneralWrong forum Pin
pmarfleet18-Dec-07 21:23
pmarfleet18-Dec-07 21:23 
GeneralUPDATE depends on UPDATE, the two UPDATEs come together Pin
followait18-Dec-07 17:39
followait18-Dec-07 17:39 
GeneralRe: UPDATE depends on UPDATE, the two UPDATEs come together Pin
SimulationofSai18-Dec-07 20:09
SimulationofSai18-Dec-07 20:09 
GeneralRe: UPDATE depends on UPDATE, the two UPDATEs come together Pin
GuyThiebaut18-Dec-07 22:41
professionalGuyThiebaut18-Dec-07 22:41 
Generalselect year/month syntax (for contracts up for renewal in X month) Pin
tellytub18-Dec-07 16:09
tellytub18-Dec-07 16:09 
GeneralRe: select year/month syntax (for contracts up for renewal in X month) Pin
Giri K18-Dec-07 17:11
Giri K18-Dec-07 17:11 
GeneralRe: select year/month syntax (for contracts up for renewal in X month) Pin
tellytub18-Dec-07 20:15
tellytub18-Dec-07 20:15 
GeneralRe: select year/month syntax (for contracts up for renewal in X month) Pin
Giri K19-Dec-07 11:55
Giri K19-Dec-07 11:55 
@Date is your parameter @DateStart, convert the Dateformat, so that you can strip it out and select which ever datepart you want, like year, month, days. the concatination separates the date part, to be able to easily select

like select contractID from XXX
where @DateStart between 01-10-2007 to 03-12-2007

hope you get this time..
Questionjoins of two tables +search Pin
regin18-Dec-07 1:42
regin18-Dec-07 1:42 
GeneralRe: joins of two tables +search Pin
pmarfleet18-Dec-07 1:59
pmarfleet18-Dec-07 1:59 
GeneralRe: joins of two tables +search Pin
andyharman18-Dec-07 3:47
professionalandyharman18-Dec-07 3:47 
QuestionHow to get generated Primary Key when adding a record Pin
gunner_uk200018-Dec-07 1:35
gunner_uk200018-Dec-07 1:35 
AnswerRe: How to get generated Primary Key when adding a record Pin
Pete O'Hanlon18-Dec-07 1:38
subeditorPete O'Hanlon18-Dec-07 1:38 
AnswerRe: How to get generated Primary Key when adding a record Pin
Giorgi Dalakishvili18-Dec-07 1:42
mentorGiorgi Dalakishvili18-Dec-07 1:42 
Questionselect the max value from the row and its other values Pin
Deques18-Dec-07 1:19
Deques18-Dec-07 1:19 
GeneralRe: select the max value from the row and its other values Pin
Tobias Schoenig18-Dec-07 1:41
Tobias Schoenig18-Dec-07 1:41 
GeneralRe: select the max value from the row and its other values Pin
Deques18-Dec-07 1:51
Deques18-Dec-07 1:51 
GeneralRe: select the max value from the row and its other values Pin
Tobias Schoenig18-Dec-07 1:59
Tobias Schoenig18-Dec-07 1:59 
GeneralRe: select the max value from the row and its other values Pin
Deques18-Dec-07 2:05
Deques18-Dec-07 2:05 
GeneralRe: select the max value from the row and its other values Pin
Tobias Schoenig18-Dec-07 2:10
Tobias Schoenig18-Dec-07 2:10 
GeneralRe: select the max value from the row and its other values Pin
Deques18-Dec-07 2:17
Deques18-Dec-07 2:17 
GeneralRe: select the max value from the row and its other values Pin
Tobias Schoenig18-Dec-07 2:22
Tobias Schoenig18-Dec-07 2:22 
GeneralRe: select the max value from the row and its other values Pin
Deques18-Dec-07 2:31
Deques18-Dec-07 2:31 
GeneralRe: select the max value from the row and its other values Pin
Tobias Schoenig18-Dec-07 2:32
Tobias Schoenig18-Dec-07 2:32 
GeneralRe: select the max value from the row and its other values Pin
Deques18-Dec-07 2:43
Deques18-Dec-07 2:43 

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.