Click here to Skip to main content
15,906,333 members
Home / Discussions / Database
   

Database

 
QuestionService Broker Pin
Member 1116162519-Feb-15 17:15
Member 1116162519-Feb-15 17:15 
AnswerRe: Service Broker Pin
Richard MacCutchan19-Feb-15 21:32
mveRichard MacCutchan19-Feb-15 21:32 
QuestionThe following stored proc is not working Pin
indian14318-Feb-15 16:18
indian14318-Feb-15 16:18 
GeneralRe: The following stored proc is not working Pin
PIEBALDconsult18-Feb-15 16:21
mvePIEBALDconsult18-Feb-15 16:21 
GeneralRe: The following stored proc is not working Pin
indian14319-Feb-15 6:26
indian14319-Feb-15 6:26 
AnswerRe: The following stored proc is not working Pin
Wendelius18-Feb-15 17:28
mentorWendelius18-Feb-15 17:28 
GeneralRe: The following stored proc is not working Pin
indian14319-Feb-15 6:32
indian14319-Feb-15 6:32 
GeneralRe: The following stored proc is not working Pin
Wendelius19-Feb-15 6:57
mentorWendelius19-Feb-15 6:57 
The BETWEEN condition needs two single values; the lower and the upper bound. For example:
SQL
WHERE NumColumn BETWEEN 5 AND 10

In that example you can't replace neither 5 or 10 with table variables since then there would be more than one value in the comparison. You can think the BETWEEN condition as two separate conditions, like:
SQL
WHERE NumColumn >= 5 
AND NumColumn <= 10

I hope this clarifies your question.
AnswerRe: The following stored proc is not working Pin
Mycroft Holmes18-Feb-15 23:54
professionalMycroft Holmes18-Feb-15 23:54 
AnswerRe: The following stored proc is not working Pin
Eddy Vluggen19-Feb-15 5:31
professionalEddy Vluggen19-Feb-15 5:31 
GeneralRe: The following stored proc is not working Pin
indian14319-Feb-15 6:26
indian14319-Feb-15 6:26 
QuestionMultiple Queries in one Stored procedure Pin
sudevsu18-Feb-15 3:42
sudevsu18-Feb-15 3:42 
AnswerRe: Multiple Queries in one Stored procedure Pin
PIEBALDconsult18-Feb-15 4:00
mvePIEBALDconsult18-Feb-15 4:00 
GeneralRe: Multiple Queries in one Stored procedure Pin
sudevsu18-Feb-15 4:08
sudevsu18-Feb-15 4:08 
GeneralRe: Multiple Queries in one Stored procedure Pin
sudevsu18-Feb-15 4:10
sudevsu18-Feb-15 4:10 
GeneralRe: Multiple Queries in one Stored procedure Pin
Corporal Agarn18-Feb-15 4:33
professionalCorporal Agarn18-Feb-15 4:33 
AnswerRe: Multiple Queries in one Stored procedure Pin
Wendelius18-Feb-15 4:37
mentorWendelius18-Feb-15 4:37 
GeneralRe: Multiple Queries in one Stored procedure Pin
sudevsu18-Feb-15 5:11
sudevsu18-Feb-15 5:11 
GeneralRe: Multiple Queries in one Stored procedure Pin
Wendelius18-Feb-15 6:41
mentorWendelius18-Feb-15 6:41 
SuggestionRe: Multiple Queries in one Stored procedure Pin
Richard Deeming18-Feb-15 5:43
mveRichard Deeming18-Feb-15 5:43 
GeneralRe: Multiple Queries in one Stored procedure Pin
sudevsu18-Feb-15 6:21
sudevsu18-Feb-15 6:21 
GeneralRe: Multiple Queries in one Stored procedure Pin
Wendelius18-Feb-15 6:42
mentorWendelius18-Feb-15 6:42 
AnswerRe: Multiple Queries in one Stored procedure Pin
Smart00324-Feb-15 23:18
professionalSmart00324-Feb-15 23:18 
AnswerRe: Multiple Queries in one Stored procedure Pin
Abdulnazark9-Mar-15 7:08
Abdulnazark9-Mar-15 7:08 
AnswerRe: Multiple Queries in one Stored procedure Pin
deepankarbhatnagar11-Mar-15 0:02
professionaldeepankarbhatnagar11-Mar-15 0:02 

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.