Click here to Skip to main content
15,881,248 members
Home / Discussions / Database
   

Database

 
GeneralRe: Assistance with a Stored Proc working with the return results from another SP Pin
JOAT-MON30-Jun-11 8:22
JOAT-MON30-Jun-11 8:22 
GeneralRe: Assistance with a Stored Proc working with the return results from another SP Pin
Alaric_1-Jul-11 5:01
professionalAlaric_1-Jul-11 5:01 
GeneralRe: Assistance with a Stored Proc working with the return results from another SP Pin
Alaric_1-Jul-11 8:45
professionalAlaric_1-Jul-11 8:45 
GeneralRe: Assistance with a Stored Proc working with the return results from another SP Pin
JOAT-MON1-Jul-11 8:56
JOAT-MON1-Jul-11 8:56 
Questionusing ?: operation in sql server 2008 Pin
reza assar29-Jun-11 3:47
reza assar29-Jun-11 3:47 
AnswerRe: using ?: operation in sql server 2008 Pin
dasblinkenlight29-Jun-11 4:29
dasblinkenlight29-Jun-11 4:29 
GeneralRe: using ?: operation in sql server 2008 Pin
reza assar29-Jun-11 5:35
reza assar29-Jun-11 5:35 
GeneralRe: using ?: operation in sql server 2008 Pin
dasblinkenlight29-Jun-11 5:58
dasblinkenlight29-Jun-11 5:58 
1. No problem
2. This does not make any more sense than "for loops are not high performance statements".
3. Assuming TBL1 and TBL2 have identical structure, you can do it like this:
SQL
select * from TBL1 where @flag=1
union all
select * from TBL2 where @flag<>1
<pre>

GeneralRe: using ?: operation in sql server 2008 Pin
reza assar29-Jun-11 7:36
reza assar29-Jun-11 7:36 
QuestionParameterised SQL Insert fails; plain text Insert works Pin
hairy_hats29-Jun-11 1:53
hairy_hats29-Jun-11 1:53 
AnswerRe: Parameterised SQL Insert fails; plain text Insert works Pin
Mycroft Holmes29-Jun-11 12:57
professionalMycroft Holmes29-Jun-11 12:57 
GeneralRe: Parameterised SQL Insert fails; plain text Insert works Pin
hairy_hats29-Jun-11 21:35
hairy_hats29-Jun-11 21:35 
AnswerRe: Parameterised SQL Insert fails; plain text Insert works Pin
dasblinkenlight29-Jun-11 17:30
dasblinkenlight29-Jun-11 17:30 
QuestionDTS not working in sql 2008 Pin
Robymon28-Jun-11 22:21
Robymon28-Jun-11 22:21 
AnswerRe: DTS not working in sql 2008 Pin
Corporal Agarn29-Jun-11 3:41
professionalCorporal Agarn29-Jun-11 3:41 
AnswerRe: DTS not working in sql 2008 Pin
Mycroft Holmes29-Jun-11 12:59
professionalMycroft Holmes29-Jun-11 12:59 
QuestionChanging DAO to ADO Pin
Kyudos28-Jun-11 14:34
Kyudos28-Jun-11 14:34 
AnswerRe: Changing DAO to ADO Pin
Kyudos28-Jun-11 14:39
Kyudos28-Jun-11 14:39 
Questioncheck the key value before inserting data [modified]---ALREADY SOLVED--- Pin
Dhyanga28-Jun-11 10:46
Dhyanga28-Jun-11 10:46 
AnswerRe: check the key value before inserting data Pin
UNCRushFan28-Jun-11 11:11
UNCRushFan28-Jun-11 11:11 
AnswerRe: check the key value before inserting data Pin
Mycroft Holmes28-Jun-11 12:50
professionalMycroft Holmes28-Jun-11 12:50 
AnswerRe: check the key value before inserting data Pin
Chris Meech28-Jun-11 12:56
Chris Meech28-Jun-11 12:56 
GeneralRe: check the key value before inserting data Pin
Mycroft Holmes28-Jun-11 18:07
professionalMycroft Holmes28-Jun-11 18:07 
AnswerRe: check the key value before inserting data Pin
Eddy Vluggen29-Jun-11 2:35
professionalEddy Vluggen29-Jun-11 2:35 
GeneralRe: check the key value before inserting data Pin
Mycroft Holmes29-Jun-11 12:45
professionalMycroft Holmes29-Jun-11 12: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.