Click here to Skip to main content
11,702,130 members (64,300 online)
   

Database

 
GeneralRe: SQL weirdness when aliasing columns Pin
Gregory.Gadow28-Feb-13 9:09
memberGregory.Gadow28-Feb-13 9:09 
GeneralRe: SQL weirdness when aliasing columns Pin
Mycroft Holmes28-Feb-13 12:04
memberMycroft Holmes28-Feb-13 12:04 
GeneralRe: SQL weirdness when aliasing columns Pin
Gregory.Gadow1-Mar-13 5:10
memberGregory.Gadow1-Mar-13 5:10 
AnswerSolution Pin
Gregory.Gadow1-Mar-13 9:28
memberGregory.Gadow1-Mar-13 9:28 
GeneralRe: Solution Pin
Mycroft Holmes1-Mar-13 11:53
memberMycroft Holmes1-Mar-13 11:53 
QuestionDatabase Pin
Member 961179522-Feb-13 8:52
memberMember 961179522-Feb-13 8:52 
AnswerRe: Database Pin
jschell22-Feb-13 9:30
memberjschell22-Feb-13 9:30 
AnswerRe: Database Pin
mark merrens22-Feb-13 10:38
membermark merrens22-Feb-13 10:38 
GeneralRe: Database Pin
Member 961179523-Feb-13 1:05
memberMember 961179523-Feb-13 1:05 
GeneralRe: Database Pin
S Douglas28-Feb-13 7:58
memberS Douglas28-Feb-13 7:58 
AnswerRe: Database Pin
Jörgen Andersson22-Feb-13 11:11
memberJörgen Andersson22-Feb-13 11:11 
AnswerRe: Database Pin
PIEBALDconsult22-Feb-13 13:38
memberPIEBALDconsult22-Feb-13 13:38 
QuestionSQL Server + Procedure or function has too many arguments specified Pin
Hemant Thaker21-Feb-13 18:53
memberHemant Thaker21-Feb-13 18:53 
AnswerRe: SQL Server + Procedure or function has too many arguments specified Pin
Sandeep Mewara21-Feb-13 19:00
mvpSandeep Mewara21-Feb-13 19:00 
Hemant Thaker wrote:
If its running for 3 days, then for the first day it executes perfectly.

For the second day and remaining all days it gives following error.

Strange. Based on what you share, sounds like some logical error where you are considering the DayNo. Are you? Somehow, somewhere the current day is getting into picture while running the procedure and the error. Did you DEBUG and see? Check if so.
Sandeep Mewara
Microsoft ASP.NET MVP 2012 & 2013

[My Blog]: Sandeep Mewara's Tech Journal!
[My Latest Article]: HTML5 Quick Start Web Application

AnswerRe: SQL Server + Procedure or function has too many arguments specified Pin
Mycroft Holmes21-Feb-13 20:29
memberMycroft Holmes21-Feb-13 20:29 
AnswerRe: Resolved --> SQL Server + Procedure or function has too many arguments specified Pin
Hemant Thaker21-Feb-13 22:11
memberHemant Thaker21-Feb-13 22:11 
QuestionDual Primary Key? Pin
Richard.Berry10021-Feb-13 6:25
memberRichard.Berry10021-Feb-13 6:25 
AnswerRe: Dual Primary Key? Pin
Eddy Vluggen21-Feb-13 7:10
mvpEddy Vluggen21-Feb-13 7:10 
GeneralRe: Dual Primary Key? Pin
Richard.Berry10021-Feb-13 7:42
memberRichard.Berry10021-Feb-13 7:42 
GeneralRe: Dual Primary Key? Pin
Eddy Vluggen21-Feb-13 8:32
mvpEddy Vluggen21-Feb-13 8:32 
GeneralRe: Dual Primary Key? Pin
Mycroft Holmes21-Feb-13 12:08
memberMycroft Holmes21-Feb-13 12:08 
GeneralRe: Dual Primary Key? Pin
PIEBALDconsult21-Feb-13 18:14
memberPIEBALDconsult21-Feb-13 18:14 
GeneralRe: Dual Primary Key? Pin
Eddy Vluggen21-Feb-13 22:42
mvpEddy Vluggen21-Feb-13 22:42 
Questionjdbc Pin
Durgesh1704r15-Feb-13 20:24
memberDurgesh1704r15-Feb-13 20:24 
AnswerRe: jdbc Pin
Richard MacCutchan15-Feb-13 22:31
mvpRichard MacCutchan15-Feb-13 22:31 
AnswerRe: jdbc Pin
Mycroft Holmes16-Feb-13 15:21
memberMycroft Holmes16-Feb-13 15:21 
QuestionOlder generation SQL syntax - Oracle Pin
vanikanc13-Feb-13 2:37
membervanikanc13-Feb-13 2:37 
AnswerRe: Older generation SQL syntax - Oracle Pin
Jörgen Andersson13-Feb-13 10:30
memberJörgen Andersson13-Feb-13 10:30 
GeneralRe: Older generation SQL syntax - Oracle Pin
vanikanc13-Feb-13 10:37
membervanikanc13-Feb-13 10:37 
AnswerRe: Older generation SQL syntax - Oracle Pin
Shameel15-Feb-13 4:17
memberShameel15-Feb-13 4:17 
QuestionHaving a bad SQL day Pin
TheComputerMan12-Feb-13 23:40
memberTheComputerMan12-Feb-13 23:40 
AnswerRe: Having a bad SQL day Pin
Jörgen Andersson13-Feb-13 0:20
memberJörgen Andersson13-Feb-13 0:20 
GeneralRe: Having a bad SQL day Pin
TheComputerMan13-Feb-13 0:32
memberTheComputerMan13-Feb-13 0:32 
GeneralRe: Having a bad SQL day Pin
Jörgen Andersson13-Feb-13 0:40
memberJörgen Andersson13-Feb-13 0:40 
GeneralRe: Having a bad SQL day Pin
Bernhard Hiller13-Feb-13 3:24
memberBernhard Hiller13-Feb-13 3:24 
GeneralRe: Having a bad SQL day Pin
TheComputerMan13-Feb-13 3:33
memberTheComputerMan13-Feb-13 3:33 
AnswerRe: Having a bad SQL day Pin
Shameel13-Feb-13 0:53
memberShameel13-Feb-13 0:53 
GeneralRe: Having a bad SQL day Pin
Jörgen Andersson13-Feb-13 0:56
memberJörgen Andersson13-Feb-13 0:56 
GeneralRe: Having a bad SQL day Pin
PIEBALDconsult13-Feb-13 4:01
memberPIEBALDconsult13-Feb-13 4:01 
GeneralRe: Having a bad SQL day Pin
Jörgen Andersson13-Feb-13 6:27
memberJörgen Andersson13-Feb-13 6:27 
QuestionWhat is Ado.net Pin
Himanshu Sharma 88812-Feb-13 19:20
memberHimanshu Sharma 88812-Feb-13 19:20 
AnswerRe: What is Ado.net Pin
Richard MacCutchan12-Feb-13 22:31
mvpRichard MacCutchan12-Feb-13 22:31 
GeneralRe: What is Ado.net Pin
Shameel13-Feb-13 0:44
memberShameel13-Feb-13 0:44 
GeneralRe: What is Ado.net Pin
Thomas Gabriel20-Feb-13 22:42
memberThomas Gabriel20-Feb-13 22:42 
AnswerRe: What is Ado.net Pin
Sandeep Mewara13-Feb-13 0:23
mvpSandeep Mewara13-Feb-13 0:23 
QuestionSQL 2008 Truncate vs Delete Pin
mrfalk12-Feb-13 6:47
membermrfalk12-Feb-13 6:47 
AnswerRe: SQL 2008 Truncate vs Delete Pin
Eddy Vluggen12-Feb-13 7:48
mvpEddy Vluggen12-Feb-13 7:48 
GeneralRe: SQL 2008 Truncate vs Delete Pin
mrfalk12-Feb-13 8:27
membermrfalk12-Feb-13 8:27 
GeneralRe: SQL 2008 Truncate vs Delete Pin
Eddy Vluggen12-Feb-13 8:36
mvpEddy Vluggen12-Feb-13 8:36 
GeneralRe: SQL 2008 Truncate vs Delete Pin
Khorshed Alam, Dhaka18-Feb-13 18:09
memberKhorshed Alam, Dhaka18-Feb-13 18:09 

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
Web01 | 2.8.150819.1 | Last Updated 26 Aug 2015
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid