Click here to Skip to main content
11,584,040 members (62,407 online)
   

Database

 
AnswerRe: Repeating Field in SSRS report. Pin
David Mujica14-Mar-13 1:54
memberDavid Mujica14-Mar-13 1:54 
GeneralRe: Repeating Field in SSRS report. Pin
Laurence123414-Mar-13 4:31
memberLaurence123414-Mar-13 4:31 
QuestionPersisted Primary Key? Pin
H JJ13-Mar-13 20:56
memberH JJ13-Mar-13 20:56 
AnswerRe: Persisted Primary Key? Pin
Mycroft Holmes13-Mar-13 21:18
memberMycroft Holmes13-Mar-13 21:18 
GeneralRe: Persisted Primary Key? Pin
H JJ13-Mar-13 23:14
memberH JJ13-Mar-13 23:14 
AnswerRe: Persisted Primary Key? Pin
Eddy Vluggen14-Mar-13 1:20
mvpEddy Vluggen14-Mar-13 1:20 
GeneralRe: Persisted Primary Key? Pin
Jörgen Andersson14-Mar-13 7:21
memberJörgen Andersson14-Mar-13 7:21 
QuestionWant to get data on weekly basis Pin
VishwaKL12-Mar-13 23:07
memberVishwaKL12-Mar-13 23:07 
AnswerRe: Want to get data on weekly basis Pin
Mycroft Holmes13-Mar-13 2:15
memberMycroft Holmes13-Mar-13 2:15 
AnswerRe: Want to get data on weekly basis Pin
Davidduraisamy13-Mar-13 20:44
memberDavidduraisamy13-Mar-13 20:44 
GeneralRe: Want to get data on weekly basis Pin
VishwaKL14-Mar-13 22:16
memberVishwaKL14-Mar-13 22:16 
GeneralRe: Want to get data on weekly basis Pin
Davidduraisamy14-Mar-13 22:23
memberDavidduraisamy14-Mar-13 22:23 
GeneralRe: Want to get data on weekly basis Pin
VishwaKL17-Mar-13 23:02
memberVishwaKL17-Mar-13 23:02 
QuestionClarification on SQL Server Function? Pin
HARI JJ12-Mar-13 19:34
memberHARI JJ12-Mar-13 19:34 
Friends,
Need one big helpSmile | :) Getting error while creating function in SQL Server. Pls help to resolve the issue.

FYI, the inputs as follows. -

Function name: func_check_seat_availability

Description: The function will check for the availability of seats in a particular bus on a given day.

Input Parameters: in_bus_No, in_DateOfJourney, in_NoOfAdults, in_NoOfChildren.

Return Values: Return 1 if the seats are available, else return 0.

Table details:
Column Data Type Constraints
-----------------------------------------------------------
BookingId Varchar(4) P_Key, Starts with B100
-----------------------------------------------------------
BusNo Int (REFERENCES tbl_busdetails)
-----------------------------------------------------------
CustomerId Int (REFERENCES tbl_Customer)
-----------------------------------------------------------
DateOfBooking DateTime
-----------------------------------------------------------
DateOfJourney DateTime DateOfJourney>=DateOfBooking
-----------------------------------------------------------
NoOfAdults Int Greater than zero
-----------------------------------------------------------
NoOfChildren Int Greater than or = to zero
-----------------------------------------------------------
AnswerRe: Clarification on SQL Server Function? Pin
Shameel12-Mar-13 20:26
memberShameel12-Mar-13 20:26 
GeneralMessage Removed Pin
HARI JJ12-Mar-13 22:54
memberHARI JJ12-Mar-13 22:54 
GeneralRe: Clarification on SQL Server Function? Pin
Shameel12-Mar-13 23:01
memberShameel12-Mar-13 23:01 
AnswerRe: Clarification on SQL Server Function? Pin
Mycroft Holmes12-Mar-13 20:44
memberMycroft Holmes12-Mar-13 20:44 
GeneralMessage Removed Pin
HARI JJ12-Mar-13 22:55
memberHARI JJ12-Mar-13 22:55 
GeneralRe: Clarification on SQL Server Function? Pin
Mycroft Holmes13-Mar-13 21:20
memberMycroft Holmes13-Mar-13 21:20 
AnswerRe: Clarification on SQL Server Function? Pin
Uma Shankar Patel13-Mar-13 2:00
memberUma Shankar Patel13-Mar-13 2:00 
QuestionArithmetic overflow error converting expression to data type nvarchar. Pin
Vuyiswa Maseko12-Mar-13 10:19
memberVuyiswa Maseko12-Mar-13 10:19 
AnswerRe: Arithmetic overflow error converting expression to data type nvarchar. Pin
Mycroft Holmes12-Mar-13 12:35
memberMycroft Holmes12-Mar-13 12:35 
AnswerRe: Arithmetic overflow error converting expression to data type nvarchar. Pin
Richard Deeming13-Mar-13 2:18
memberRichard Deeming13-Mar-13 2:18 
Questionput a condition in join query Pin
demoninside912-Mar-13 1:38
memberdemoninside912-Mar-13 1:38 
AnswerRe: put a condition in join query Pin
Jörgen Andersson12-Mar-13 2:19
memberJörgen Andersson12-Mar-13 2:19 
GeneralRe: put a condition in join query Pin
demoninside912-Mar-13 18:47
memberdemoninside912-Mar-13 18:47 
GeneralRe: put a condition in join query Pin
Mycroft Holmes12-Mar-13 20:40
memberMycroft Holmes12-Mar-13 20:40 
GeneralRe: put a condition in join query Pin
demoninside912-Mar-13 20:49
memberdemoninside912-Mar-13 20:49 
GeneralRe: put a condition in join query Pin
Mycroft Holmes12-Mar-13 22:23
memberMycroft Holmes12-Mar-13 22:23 
GeneralRe: put a condition in join query Pin
demoninside912-Mar-13 22:39
memberdemoninside912-Mar-13 22:39 
QuestionHow to Recover the Data if the Delete Query is Fire?? Pin
eg_Anubhava11-Mar-13 22:11
membereg_Anubhava11-Mar-13 22:11 
AnswerRe: How to Recover the Data if the Delete Query is Fire?? Pin
Mycroft Holmes11-Mar-13 22:40
memberMycroft Holmes11-Mar-13 22:40 
GeneralRe: How to Recover the Data if the Delete Query is Fire?? Pin
eg_Anubhava11-Mar-13 23:44
membereg_Anubhava11-Mar-13 23:44 
Questiondatabase design for a self food ordering system? Pin
suryakanthithommy11-Mar-13 6:40
membersuryakanthithommy11-Mar-13 6:40 
AnswerRe: database design for a self food ordering system? Pin
Sandeep Mewara11-Mar-13 7:04
mvpSandeep Mewara11-Mar-13 7:04 
Questionwhy i am unable to retrieve holiday name Pin
Member 870181310-Mar-13 22:35
memberMember 870181310-Mar-13 22:35 
AnswerRe: why i am unable to retrieve holiday name Pin
Mycroft Holmes10-Mar-13 23:20
memberMycroft Holmes10-Mar-13 23:20 
GeneralRe: why i am unable to retrieve holiday name Pin
Member 870181311-Mar-13 4:31
memberMember 870181311-Mar-13 4:31 
QuestionBCP - Exported files (docx, xlsx & pptx) are corrupted Pin
ragasai10-Mar-13 16:52
memberragasai10-Mar-13 16:52 
QuestionDatabase design for E commerce web site Pin
subbaraogaddam8-Mar-13 19:44
membersubbaraogaddam8-Mar-13 19:44 
AnswerRe: Database design for E commerce web site Pin
gvprabu8-Mar-13 20:04
membergvprabu8-Mar-13 20:04 
GeneralRe: Database design for E commerce web site Pin
subbaraogaddam8-Mar-13 20:21
membersubbaraogaddam8-Mar-13 20:21 
GeneralRe: Database design for E commerce web site Pin
gvprabu8-Mar-13 20:31
membergvprabu8-Mar-13 20:31 
GeneralRe: Database design for E commerce web site Pin
subbaraogaddam8-Mar-13 20:40
membersubbaraogaddam8-Mar-13 20:40 
GeneralRe: Database design for E commerce web site Pin
Shameel11-Mar-13 4:51
memberShameel11-Mar-13 4:51 
AnswerRe: Database design for E commerce web site Pin
Richard MacCutchan8-Mar-13 22:08
mvpRichard MacCutchan8-Mar-13 22:08 
AnswerRe: Database design for E commerce web site Pin
jschell10-Mar-13 6:30
memberjschell10-Mar-13 6:30 
Questiondb_accessadmin? Pin
ThePotty17-Mar-13 23:57
memberThePotty17-Mar-13 23:57 
AnswerRe: db_accessadmin? Pin
JammoD878-Mar-13 1:21
memberJammoD878-Mar-13 1:21 

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