Click here to Skip to main content
15,617,020 members
Home / Discussions / Database
   

Database

 
GeneralRe: Nested Cursor loop problem [modified] Pin
Member 387988117-Jul-08 19:59
Member 387988117-Jul-08 19:59 
GeneralRe: Nested Cursor loop problem Pin
Mark J. Miller18-Jul-08 5:20
Mark J. Miller18-Jul-08 5:20 
QuestionCompact database not working Pin
krishnan.s17-Jul-08 2:41
krishnan.s17-Jul-08 2:41 
AnswerRe: Compact database not working Pin
Paul Conrad17-Jul-08 16:51
professionalPaul Conrad17-Jul-08 16:51 
QuestionNot In operation? Pin
Member 387988117-Jul-08 1:03
Member 387988117-Jul-08 1:03 
AnswerRe: Not In operation? Pin
TheFM23417-Jul-08 3:00
TheFM23417-Jul-08 3:00 
GeneralRe: Not In operation? Pin
Member 387988117-Jul-08 3:09
Member 387988117-Jul-08 3:09 
Questionselect datas using union operation Pin
deepthy.p.m16-Jul-08 22:48
deepthy.p.m16-Jul-08 22:48 
i want to select both values using union operation how can i do this i use the following sql query


SELECT ProdReqId ,ProdSlNo, convert(varchar(10),ProdCurrDate,105) AS Date1
FROM tbl_ProductRequirementDetails where BrachId=4 and Status=1

UNION ALL

select PurOrderId ,PurOrderCode,convert(varchar(10),PurOrderCurrDate,105) AS Date2 from tbl_PurchaseOrder where BrachId=4 and Status=1




I want to select -- ProdReqId ,ProdSlNo, convert(varchar(10),ProdCurrDate,105) AS Date1 -- and -- PurOrderId ,PurOrderCode,convert(varchar(10),PurOrderCurrDate,105) AS Date2 --
how can i select that
AnswerRe: select datas using union operation Pin
Vimalsoft(Pty) Ltd17-Jul-08 0:50
professionalVimalsoft(Pty) Ltd17-Jul-08 0:50 
Questionreturn Table name + Column Name in sql query Pin
farabba16-Jul-08 20:51
farabba16-Jul-08 20:51 
AnswerRe: return Table name + Column Name in sql query Pin
Harvey Saayman16-Jul-08 23:01
Harvey Saayman16-Jul-08 23:01 
GeneralRe: return Table name + Column Name in sql query Pin
Mycroft Holmes17-Jul-08 20:08
professionalMycroft Holmes17-Jul-08 20:08 
GeneralRe: return Table name + Column Name in sql query Pin
Harvey Saayman17-Jul-08 20:19
Harvey Saayman17-Jul-08 20:19 
GeneralRe: return Table name + Column Name in sql query Pin
Mycroft Holmes17-Jul-08 20:44
professionalMycroft Holmes17-Jul-08 20:44 
AnswerRe: return Table name + Column Name in sql query Pin
MBCDC21-Jul-08 0:39
MBCDC21-Jul-08 0:39 
Questiondynamically applyin styles based on DB Value to reports Pin
ch.ramesh16-Jul-08 19:06
ch.ramesh16-Jul-08 19:06 
AnswerRe: dynamically applyin styles based on DB Value to reports Pin
Ashfield16-Jul-08 20:13
Ashfield16-Jul-08 20:13 
GeneralRe: dynamically applyin styles based on DB Value to reports Pin
ch.ramesh16-Jul-08 20:21
ch.ramesh16-Jul-08 20:21 
GeneralRe: dynamically applyin styles based on DB Value to reports Pin
Ashfield17-Jul-08 2:24
Ashfield17-Jul-08 2:24 
QuestionMultiple queries within an ADO connection Pin
Airickjay16-Jul-08 9:50
Airickjay16-Jul-08 9:50 
AnswerRe: Multiple queries within an ADO connection Pin
tsaunders16-Jul-08 15:09
tsaunders16-Jul-08 15:09 
AnswerRe: Multiple queries within an ADO connection Pin
andyharman17-Jul-08 7:15
professionalandyharman17-Jul-08 7:15 
AnswerRe: Multiple queries within an ADO connection Pin
Airickjay17-Jul-08 8:30
Airickjay17-Jul-08 8:30 
AnswerRe: Multiple queries within an ADO connection Pin
MBCDC21-Jul-08 0:59
MBCDC21-Jul-08 0:59 
Questionerror when deleting with the WITH clause? Pin
harcaype16-Jul-08 7:01
harcaype16-Jul-08 7:01 

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.