Click here to Skip to main content
15,878,814 members
Home / Discussions / Database
   

Database

 
GeneralRe: postgresql database issues Pin
Member 1191972225-Sep-15 1:01
Member 1191972225-Sep-15 1:01 
GeneralRe: postgresql database issues Pin
Member 1191972222-Sep-15 0:08
Member 1191972222-Sep-15 0:08 
GeneralRe: postgresql database issues Pin
Member 1191972222-Sep-15 0:20
Member 1191972222-Sep-15 0:20 
AnswerRe: postgresql database issues Pin
Tim Carmichael22-Sep-15 2:31
Tim Carmichael22-Sep-15 2:31 
SuggestionRe: postgresql database issues Pin
Richard Deeming22-Sep-15 4:45
mveRichard Deeming22-Sep-15 4:45 
GeneralRe: postgresql database issues Pin
Tim Carmichael22-Sep-15 5:08
Tim Carmichael22-Sep-15 5:08 
GeneralRe: postgresql database issues Pin
Member 1191972222-Sep-15 19:52
Member 1191972222-Sep-15 19:52 
GeneralRe: postgresql database issues Pin
Member 1191972222-Sep-15 19:59
Member 1191972222-Sep-15 19:59 
i did as u said n got output also without null values but if m writing the same query...with update statement as outer query the inner query gives foloowing error which is obvious coz inner query returns more than single value ..the query will be as follow as u said right?

update sc_bill_details set dt_open_date=(select dt_bill_date from sc_bill,sc_bill_details where sc_bill.st_bill_no=sc_bill_details.st_bill_no and dt_bill_date>'2015-07-01' )

getting follwing error when wrote above query ....

more than one row returned by a subquery used as an expression

i cant even use in operator with update statement since that will lead to syntax error??
GeneralRe: postgresql database issues Pin
Member 1191972222-Sep-15 19:50
Member 1191972222-Sep-15 19:50 
QuestionMigrate data from Mysql Server to Sql Server Pin
Member 1199919920-Sep-15 21:10
Member 1199919920-Sep-15 21:10 
QuestionSearching with desired column name with value is not working Pin
Member 1179609715-Sep-15 21:47
Member 1179609715-Sep-15 21:47 
AnswerRe: Searching with desired column name with value is not working Pin
Corporal Agarn16-Sep-15 0:40
professionalCorporal Agarn16-Sep-15 0:40 
GeneralRe: Searching with desired column name with value is not working Pin
Member 1179609716-Sep-15 1:06
Member 1179609716-Sep-15 1:06 
GeneralRe: Searching with desired column name with value is not working Pin
GuyThiebaut16-Sep-15 1:13
professionalGuyThiebaut16-Sep-15 1:13 
GeneralRe: Searching with desired column name with value is not working Pin
Richard Deeming16-Sep-15 2:33
mveRichard Deeming16-Sep-15 2:33 
GeneralRe: Searching with desired column name with value is not working Pin
Corporal Agarn16-Sep-15 1:18
professionalCorporal Agarn16-Sep-15 1:18 
GeneralRe: Searching with desired column name with value is not working Pin
Richard Deeming16-Sep-15 2:34
mveRichard Deeming16-Sep-15 2:34 
GeneralRe: Searching with desired column name with value is not working Pin
Corporal Agarn16-Sep-15 2:48
professionalCorporal Agarn16-Sep-15 2:48 
GeneralRe: Searching with desired column name with value is not working Pin
Richard Deeming16-Sep-15 2:40
mveRichard Deeming16-Sep-15 2:40 
QuestionHow to find a stored procedure by Author's HostName or LoginName Pin
Mphirana15-Sep-15 2:42
Mphirana15-Sep-15 2:42 
AnswerRe: How to find a stored procedure by Author's HostName or LoginName Pin
Eddy Vluggen15-Sep-15 4:51
professionalEddy Vluggen15-Sep-15 4:51 
AnswerRe: How to find a stored procedure by Author's HostName or LoginName Pin
CHill6015-Sep-15 7:02
mveCHill6015-Sep-15 7:02 
GeneralRe: How to find a stored procedure by Author's HostName or LoginName Pin
Eddy Vluggen15-Sep-15 8:08
professionalEddy Vluggen15-Sep-15 8:08 
AnswerRe: How to find a stored procedure by Author's HostName or LoginName Pin
Kornfeld Eliyahu Peter15-Sep-15 20:52
professionalKornfeld Eliyahu Peter15-Sep-15 20:52 
QuestionHow can i remove duplicate item from combobox with datasource? Pin
Member 1051522510-Sep-15 2:51
professionalMember 1051522510-Sep-15 2:51 

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.