Click here to Skip to main content
       

Database

 
GeneralRe: SQL weirdness when aliasing columns PinmemberGregory.Gadow28-Feb-13 9:09 
GeneralRe: SQL weirdness when aliasing columns PinmemberMycroft Holmes28-Feb-13 12:04 
GeneralRe: SQL weirdness when aliasing columns PinmemberGregory.Gadow1-Mar-13 5:10 
AnswerSolution PinmemberGregory.Gadow1-Mar-13 9:28 
GeneralRe: Solution PinmemberMycroft Holmes1-Mar-13 11:53 
QuestionDatabase PinmemberMember 961179522-Feb-13 8:52 
AnswerRe: Database Pinmemberjschell22-Feb-13 9:30 
AnswerRe: Database Pinmembermark merrens22-Feb-13 10:38 
GeneralRe: Database PinmemberMember 961179523-Feb-13 1:05 
GeneralRe: Database PinmemberS Douglas28-Feb-13 7:58 
AnswerRe: Database PinmemberJörgen Andersson22-Feb-13 11:11 
AnswerRe: Database PinmemberPIEBALDconsult22-Feb-13 13:38 
QuestionSQL Server + Procedure or function has too many arguments specified PinmemberHemant Thaker21-Feb-13 18:53 
AnswerRe: SQL Server + Procedure or function has too many arguments specified PinmvpSandeep 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 PinmemberMycroft Holmes21-Feb-13 20:29 
AnswerRe: Resolved --> SQL Server + Procedure or function has too many arguments specified PinmemberHemant Thaker21-Feb-13 22:11 
QuestionDual Primary Key? PinmemberRichard.Berry10021-Feb-13 6:25 
AnswerRe: Dual Primary Key? PinmvpEddy Vluggen21-Feb-13 7:10 
GeneralRe: Dual Primary Key? PinmemberRichard.Berry10021-Feb-13 7:42 
GeneralRe: Dual Primary Key? PinmvpEddy Vluggen21-Feb-13 8:32 
GeneralRe: Dual Primary Key? PinmemberMycroft Holmes21-Feb-13 12:08 
GeneralRe: Dual Primary Key? PinmemberPIEBALDconsult21-Feb-13 18:14 
GeneralRe: Dual Primary Key? PinmvpEddy Vluggen21-Feb-13 22:42 
Questionjdbc PinmemberDurgesh1704r15-Feb-13 20:24 
AnswerRe: jdbc PinmvpRichard MacCutchan15-Feb-13 22:31 
AnswerRe: jdbc PinmemberMycroft Holmes16-Feb-13 15:21 
QuestionOlder generation SQL syntax - Oracle Pinmembervanikanc13-Feb-13 2:37 
AnswerRe: Older generation SQL syntax - Oracle PinmemberJörgen Andersson13-Feb-13 10:30 
GeneralRe: Older generation SQL syntax - Oracle Pinmembervanikanc13-Feb-13 10:37 
AnswerRe: Older generation SQL syntax - Oracle PinmemberShameel15-Feb-13 4:17 
QuestionHaving a bad SQL day PinmemberTheComputerMan12-Feb-13 23:40 
AnswerRe: Having a bad SQL day PinmemberJörgen Andersson13-Feb-13 0:20 
GeneralRe: Having a bad SQL day PinmemberTheComputerMan13-Feb-13 0:32 
GeneralRe: Having a bad SQL day [modified] PinmemberJörgen Andersson13-Feb-13 0:40 
GeneralRe: Having a bad SQL day PinmemberBernhard Hiller13-Feb-13 3:24 
GeneralRe: Having a bad SQL day PinmemberTheComputerMan13-Feb-13 3:33 
AnswerRe: Having a bad SQL day PinmemberShameel13-Feb-13 0:53 
GeneralRe: Having a bad SQL day PinmemberJörgen Andersson13-Feb-13 0:56 
GeneralRe: Having a bad SQL day PinmemberPIEBALDconsult13-Feb-13 4:01 
GeneralRe: Having a bad SQL day PinmemberJörgen Andersson13-Feb-13 6:27 
QuestionWhat is Ado.net PinmemberHimanshu Sharma 88812-Feb-13 19:20 
AnswerRe: What is Ado.net PinmvpRichard MacCutchan12-Feb-13 22:31 
GeneralRe: What is Ado.net PinmemberShameel13-Feb-13 0:44 
GeneralRe: What is Ado.net PinmemberThomas Gabriel20-Feb-13 22:42 
AnswerRe: What is Ado.net PinmvpSandeep Mewara13-Feb-13 0:23 
QuestionSQL 2008 Truncate vs Delete Pinmembermrfalk12-Feb-13 6:47 
AnswerRe: SQL 2008 Truncate vs Delete PinmvpEddy Vluggen12-Feb-13 7:48 
GeneralRe: SQL 2008 Truncate vs Delete Pinmembermrfalk12-Feb-13 8:27 
GeneralRe: SQL 2008 Truncate vs Delete PinmvpEddy Vluggen12-Feb-13 8:36 
GeneralRe: SQL 2008 Truncate vs Delete PinmemberKhorshed 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
Web04 | 2.8.141015.1 | Last Updated 20 Oct 2014
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid