Click here to Skip to main content
11,571,102 members (64,396 online)
   

Database

 
GeneralRe: sql server Pin
Eddy Vluggen18-Jan-13 2:13
mvpEddy Vluggen18-Jan-13 2:13 
GeneralRe: sql server Pin
Richard Deeming18-Jan-13 2:18
memberRichard Deeming18-Jan-13 2:18 
GeneralRe: sql server Pin
Eddy Vluggen18-Jan-13 2:22
mvpEddy Vluggen18-Jan-13 2:22 
GeneralRe: sql server Pin
PIEBALDconsult18-Jan-13 14:36
memberPIEBALDconsult18-Jan-13 14:36 
AnswerRe: sql server Pin
PIEBALDconsult18-Jan-13 4:04
memberPIEBALDconsult18-Jan-13 4:04 
GeneralRe: sql server Pin
Shameel22-Jan-13 4:31
memberShameel22-Jan-13 4:31 
QuestionDo I need a pivot Query? Pin
GREG_DORIANcod16-Jan-13 10:09
memberGREG_DORIANcod16-Jan-13 10:09 
AnswerRe: Do I need a pivot Query? Pin
Mycroft Holmes16-Jan-13 19:36
memberMycroft Holmes16-Jan-13 19:36 
GeneralRe: Do I need a pivot Query? Pin
GREG_DORIANcod17-Jan-13 1:59
memberGREG_DORIANcod17-Jan-13 1:59 
AnswerRe: Do I need a pivot Query? Pin
Jörgen Andersson21-Jan-13 8:58
memberJörgen Andersson21-Jan-13 8:58 
QuestionTotals of each transaction type Pin
Richard.Berry10015-Jan-13 21:38
memberRichard.Berry10015-Jan-13 21:38 
AnswerRe: Totals of each transaction type Pin
Mycroft Holmes15-Jan-13 22:57
memberMycroft Holmes15-Jan-13 22:57 
GeneralRe: Totals of each transaction type Pin
Richard.Berry10016-Jan-13 0:36
memberRichard.Berry10016-Jan-13 0:36 
GeneralRe: Totals of each transaction type Pin
PIEBALDconsult16-Jan-13 3:42
memberPIEBALDconsult16-Jan-13 3:42 
As to the dates, you probably want to use BETWEEN -- I do hope you are storing dates as DATE or DATETIME, not strings.

If you execute your command in SSMS, what line does it tell you the error is on?
GeneralRe: Totals of each transaction type Pin
Richard.Berry10016-Jan-13 5:36
memberRichard.Berry10016-Jan-13 5:36 
QuestionCustomize color coding in SQL editor window Pin
biop.codeproject15-Jan-13 20:04
memberbiop.codeproject15-Jan-13 20:04 
AnswerRe: Customize color coding in SQL editor window Pin
Mycroft Holmes15-Jan-13 22:51
memberMycroft Holmes15-Jan-13 22:51 
GeneralMessage Removed Pin
biop.codeproject16-Jan-13 19:26
memberbiop.codeproject16-Jan-13 19:26 
GeneralRe: Customize color coding in SQL editor window Pin
Mycroft Holmes16-Jan-13 19:34
memberMycroft Holmes16-Jan-13 19:34 
GeneralRe: Customize color coding in SQL editor window Pin
Shameel22-Jan-13 4:41
memberShameel22-Jan-13 4:41 
Questionquery.. Pin
vishal.v.patil14-Jan-13 17:49
membervishal.v.patil14-Jan-13 17:49 
AnswerRe: query.. Pin
Mycroft Holmes14-Jan-13 17:54
memberMycroft Holmes14-Jan-13 17:54 
GeneralRe: query.. Pin
vishal.v.patil14-Jan-13 18:21
membervishal.v.patil14-Jan-13 18:21 
GeneralRe: query.. Pin
Blue_Boy15-Jan-13 3:11
memberBlue_Boy15-Jan-13 3:11 
QuestionBuilding dictionary translation Pin
Y@ssco14-Jan-13 16:19
memberY@ssco14-Jan-13 16:19 
AnswerRe: Building dictionary translation Pin
Mycroft Holmes14-Jan-13 17:52
memberMycroft Holmes14-Jan-13 17:52 
GeneralRe: Building dictionary translation Pin
Y@ssco14-Jan-13 18:41
memberY@ssco14-Jan-13 18:41 
GeneralRe: Building dictionary translation Pin
Mycroft Holmes14-Jan-13 18:52
memberMycroft Holmes14-Jan-13 18:52 
GeneralRe: Building dictionary translation Pin
djj5515-Jan-13 1:51
memberdjj5515-Jan-13 1:51 
GeneralRe: Building dictionary translation Pin
Y@ssco15-Jan-13 18:23
memberY@ssco15-Jan-13 18:23 
AnswerRe: Building dictionary translation Pin
Eddy Vluggen16-Jan-13 2:41
mvpEddy Vluggen16-Jan-13 2:41 
Questionembedding sql server express in application Pin
Danzy8313-Jan-13 16:48
memberDanzy8313-Jan-13 16:48 
AnswerRe: embedding sql server express in application Pin
PIEBALDconsult13-Jan-13 17:02
memberPIEBALDconsult13-Jan-13 17:02 
AnswerRe: embedding sql server express in application Pin
Eddy Vluggen14-Jan-13 2:07
mvpEddy Vluggen14-Jan-13 2:07 
QuestionSQL Query For String Searching Pin
lhsunshine10-Jan-13 3:35
memberlhsunshine10-Jan-13 3:35 
AnswerRe: SQL Query For String Searching Pin
djj5510-Jan-13 4:40
memberdjj5510-Jan-13 4:40 
GeneralRe: SQL Query For String Searching Pin
lhsunshine10-Jan-13 17:51
memberlhsunshine10-Jan-13 17:51 
AnswerRe: SQL Query For String Searching Pin
Richard MacCutchan10-Jan-13 4:58
mvpRichard MacCutchan10-Jan-13 4:58 
AnswerRe: SQL Query For String Searching Pin
PIEBALDconsult10-Jan-13 7:37
memberPIEBALDconsult10-Jan-13 7:37 
GeneralRe: SQL Query For String Searching Pin
lhsunshine10-Jan-13 11:55
memberlhsunshine10-Jan-13 11:55 
GeneralRe: SQL Query For String Searching Pin
PIEBALDconsult10-Jan-13 12:43
memberPIEBALDconsult10-Jan-13 12:43 
GeneralRe: SQL Query For String Searching Pin
lhsunshine10-Jan-13 17:01
memberlhsunshine10-Jan-13 17:01 
GeneralRe: SQL Query For String Searching Pin
PIEBALDconsult10-Jan-13 17:44
memberPIEBALDconsult10-Jan-13 17:44 
AnswerRe: SQL Query For String Searching Pin
jschell10-Jan-13 14:10
memberjschell10-Jan-13 14:10 
GeneralRe: SQL Query For String Searching Pin
PIEBALDconsult11-Jan-13 16:55
memberPIEBALDconsult11-Jan-13 16:55 
JokeRe: SQL Query For String Searching Pin
Eddy Vluggen11-Jan-13 17:18
mvpEddy Vluggen11-Jan-13 17:18 
QuestionMaximum number of concurrent connections to SQL Server 2008 Pin
Danzy8310-Jan-13 1:21
memberDanzy8310-Jan-13 1:21 
AnswerRe: Maximum number of concurrent connections to SQL Server 2008 Pin
David Mujica10-Jan-13 2:56
memberDavid Mujica10-Jan-13 2:56 
AnswerRe: Maximum number of concurrent connections to SQL Server 2008 Pin
PIEBALDconsult10-Jan-13 3:03
memberPIEBALDconsult10-Jan-13 3:03 
GeneralRe: Maximum number of concurrent connections to SQL Server 2008 Pin
Mycroft Holmes10-Jan-13 11:47
memberMycroft Holmes10-Jan-13 11:47 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    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
Web03 | 2.8.150624.2 | Last Updated 1 Jul 2015
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid