Click here to Skip to main content
15,902,635 members
Home / Discussions / Database
   

Database

 
GeneralRe: Rewrit a Scalar function to a table valued function Pin
Richard Deeming21-Oct-14 2:00
mveRichard Deeming21-Oct-14 2:00 
GeneralRe: Rewrit a Scalar function to a table valued function Pin
Ambertje21-Oct-14 2:25
Ambertje21-Oct-14 2:25 
GeneralRe: Rewrit a Scalar function to a table valued function Pin
Mycroft Holmes21-Oct-14 12:52
professionalMycroft Holmes21-Oct-14 12:52 
SuggestionRe: Rewrit a Scalar function to a table valued function Pin
Richard Deeming21-Oct-14 1:55
mveRichard Deeming21-Oct-14 1:55 
AnswerRe: Rewrit a Scalar function to a table valued function Pin
Eddy Vluggen21-Oct-14 2:33
professionalEddy Vluggen21-Oct-14 2:33 
QuestionStored Procedure for Item Allotment Pin
avisharma@sharma19-Oct-14 20:01
avisharma@sharma19-Oct-14 20:01 
QuestionRe: Stored Procedure for Item Allotment Pin
Jörgen Andersson19-Oct-14 21:22
professionalJörgen Andersson19-Oct-14 21:22 
AnswerRe: Stored Procedure for Item Allotment Pin
avisharma@sharma19-Oct-14 23:04
avisharma@sharma19-Oct-14 23:04 
I HAVE 2 TABLES

TABLE 1 = "ITEM ALLOTMENT" it has initially "total_item" = 10 or some other value, "allotted_item" = 0 and "item_available" = 0
CONSISTS OF COLUMNS---

ITEM_NAME NVARCHAR(50)
TOTAL_ITEM--- INT
ALLOTTED_ITEM---- INT
ITEM_AVAILABLE--- INT

AND

TABLE 2 = ITEM it only stores the allocation details after clicking assign button
CONSISTS OF COLUMNS---
ITEM_ID (PRIMARY KEY)
PRODUCT_NO -- nvarchar(50)
ITEM_NAME -- nvarchar(50)

now after allotment details are filled in "ITEM" table that this "item_name" is allocated to this "product_no" and what is has to done in "item allotment" table is just after allotment its value must be updated that means column name
"allotted_item" value must be increased and in "item_available" column the subtracted value is have to shown example
If in "total_item" there is 10 items stored after allocation "allotted_item" value will be increased to 1 and subtracted value will be shown in "item_available" column

all these have to be done on assign button click. So, I that i am using Stored Procedure
Please help me out ,I am failing to which.

Thanks
GeneralRe: Stored Procedure for Item Allotment Pin
Shweta N Mishra20-Oct-14 2:24
professionalShweta N Mishra20-Oct-14 2:24 
GeneralRe: Stored Procedure for Item Allotment Pin
avisharma@sharma27-Oct-14 2:42
avisharma@sharma27-Oct-14 2:42 
GeneralRe: Stored Procedure for Item Allotment Pin
Shweta N Mishra27-Oct-14 3:37
professionalShweta N Mishra27-Oct-14 3:37 
GeneralRe: Stored Procedure for Item Allotment Pin
Jörgen Andersson20-Oct-14 4:53
professionalJörgen Andersson20-Oct-14 4:53 
QuestionCheck if email for each specific recipient was sent or not sql server 2008 Pin
bjay tiamsic19-Oct-14 0:25
bjay tiamsic19-Oct-14 0:25 
AnswerRe: Check if email for each specific recipient was sent or not sql server 2008 Pin
Wendelius19-Oct-14 0:41
mentorWendelius19-Oct-14 0:41 
GeneralRe: Check if email for each specific recipient was sent or not sql server 2008 Pin
bjay tiamsic19-Oct-14 17:58
bjay tiamsic19-Oct-14 17:58 
GeneralRe: Check if email for each specific recipient was sent or not sql server 2008 Pin
Wendelius19-Oct-14 18:20
mentorWendelius19-Oct-14 18:20 
SuggestionRe: Check if email for each specific recipient was sent or not sql server 2008 Pin
Richard Deeming20-Oct-14 2:16
mveRichard Deeming20-Oct-14 2:16 
GeneralRe: Check if email for each specific recipient was sent or not sql server 2008 Pin
Wendelius20-Oct-14 17:23
mentorWendelius20-Oct-14 17:23 
QuestionSQL report to get average amount of time for helpdesk closures Pin
Danpeking17-Oct-14 3:29
Danpeking17-Oct-14 3:29 
AnswerRe: SQL report to get average amount of time for helpdesk closures Pin
GuyThiebaut17-Oct-14 3:45
professionalGuyThiebaut17-Oct-14 3:45 
AnswerRe: SQL report to get average amount of time for helpdesk closures Pin
Wendelius17-Oct-14 3:47
mentorWendelius17-Oct-14 3:47 
GeneralRe: SQL report to get average amount of time for helpdesk closures Pin
GuyThiebaut17-Oct-14 4:16
professionalGuyThiebaut17-Oct-14 4:16 
GeneralRe: SQL report to get average amount of time for helpdesk closures Pin
Wendelius17-Oct-14 4:25
mentorWendelius17-Oct-14 4:25 
GeneralRe: SQL report to get average amount of time for helpdesk closures Pin
Danpeking17-Oct-14 6:03
Danpeking17-Oct-14 6:03 
AnswerRe: SQL report to get average amount of time for helpdesk closures Pin
Wendelius19-Oct-14 0:35
mentorWendelius19-Oct-14 0:35 

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.