Search Result

Rettla · Mar 9 '12, 01:54 PM

Hi guys,

I am working on a project that simulates an online shares and securities trading environment. Participants can place buy/sell orders and cancel them. If an order is placed before the market closes at 1700, it should only be cancelled before 1700. It however seems that there is a loophole and participants are cancelling orders that would have already been processed.I have attached a copy of the stored procedure that I had tried...

choong1990 · Jan 16 '12, 12:43 PM

How to insert multiple data into mssql without using loop?
i'm developing a clinic management system, while doctor may give few medicines to patient,therefo re i hope inside my database,the data will look like

Code:

|-----------------------------------|
|   RecordID  |  ItemID   |   Amount|
|-----------------------------------|
|      1      |     1     |    10   |
|      1      |     2     |    100  |

...

Palyadav · Dec 19 '11, 05:49 AM

How can i add below 4 field in Existing stored procedure ?

Code:

DECLARE @StartTime datetime
DECLARE @CurrentDate datetime
Declare @Days int
Declare @Hours int
Declare @Minutes int
declare @Second int
SET @StartTime = EmployeeTempAttendanceDetail.EmpInTime
SET @CurrentDate = EmployeeTempAttendanceDetail.EmpOutTime

SET @Days = DATEDIFF(Day, @StartTime, @CurrentDate)
SET @Hours = DATEDIFF(Hour,

...

Palyadav · Dec 14 '11, 11:45 AM

Code:

ALTER PROCEDURE [dbo].[SpLeaveApprovalSaveNew]
	@LeaveApplicationId int,
	@LeaveId int,
	@EmployeeId int,
	@LeaveApprovalFromDate datetime,
	@LeaveApprovalToDate datetime,
	@LeaveApprovalHalfDay bit,
	@LeaveApprovalApplicaitonDate datetime,
	@LeaveApprovalDuration numeric(18,2),
	@LeaveApprovalDate datetime,
	@LeaveApprovalRemark nvarchar(15),
	@LeaveApprovalApplicationBy

...

Palyadav · Dec 14 '11, 04:56 AM

Code:

;with cte as (
    select
        empid,
        cast(datepart(hh, logtime) as varchar(2)) + ':' +
        right('0' + cast(datepart(mi, logtime) as varchar(2)), 2) as logtime,
        row_number() over (partition by empid order by logid) as row
    from #timing
)
select c1.empid as EmployeeID, min(c1.logtime) as InTime, max(c2.logtime) as OutTime, min(isnull(p.punches, '')) as Punches

...

ajavadi · Oct 24 '11, 07:19 AM

Hi my Frineds

I had an encrypted stored procedure in SQL Sever 2008 R2, but it was deleted by a mistake. I have the backup of whole database, but I can't restore whole of that, bicause it's not uptodate. Is there any way for transfering an encripted stored procedure from one database to another one?

Thanx

pacosino · May 25 '11, 06:05 AM

Hello,
I have a strange situation with something and maybe someone here can help me. I have a function in Oracle that returns a sequence number. When i try to get that value in C# by a parameter it always tells me that the parameter type is invalid. A sample value of that returned value is 115545. If indeed this error is correct then what is the correspondent in ODBCType for this value? If it isn't correct then what is the problem?
...

dblack64 · Sep 16 '10, 06:03 PM

I am working in Access 2007.
I have a form named Master Terms List that contains 4 bound text boxes and 7 cascading combo boxes. The bound text boxes have data sources from a table named Termslist. The record source for the 7 cascading combo boxes is also the table Termslist.
The names of the fields on form Master Terms List and the type of controls they are follows:
Termslistmonth - text box
DateReceived - text box...

user1980 · May 17 '10, 06:14 PM

Hello there

I would like to know if I can call a stored procedure from java script function.. I have a hyperlink, which should allow user to insert or delete or edit a column in the database. can this be done?? i would like to put the functionality in the javascript function
my page is an asp page.......

thank you

gpnich · Apr 28 '10, 09:21 PM

Will a stored procedure
delay until the ssis package ran from sp_start_job, is complete or finished before proceding to the next task in the stored procedure?

Will the full sql agent job complete before the next step in the stored procedure is executed?

tomex · Mar 9 '10, 11:12 AM

hello guys
How do you use a sql stored procedure in php
--where do you save the query???
-- will you put it in your code in php?
---- what will i do??
--- please help or give me a link
---- this is just a simple question please help me with this thank you

RAQUELIII · Feb 12 '10, 11:58 PM

HI!
I MADE A STORED PROCEDURE BUT WHEN I CALL IT ONLY RETURN THE FIRST RECORD AS A MESSAGE, AND DOESNT RETURN ALL THE RECORDS THAT I QUERY.
THIS IS THE CODE:
CREATE PROCEDURE SCHEMA.PROCED21 ( OUT CVE_PROGRAMA INTEGER, OUT NOMBRE_CARRERA VARCHAR(120) )

RESULT SETS 1

LANGUAGE SQL

NOT DETERMINISTIC

READS SQL DATA

P1: BEGIN

DECLARE ANIOI...

FrustratedNoob · Jan 16 '10, 01:16 AM

I've got a database that I've been working on for over a year and a half but I've just recently finished the back end to the point of feeling comfortable with starting on a front end.

So while I've been able to pick up a great deal just stumbling through on my own with the several apress books I've gotten a hold of I've figured out a great deal and have some half decent forms for data entry but for the life of me I can't figure out how...

barmatt80 · Dec 15 '09, 09:49 PM

I am stumped on a web service.

I have a web service that calls a sql stored procedure. the procedure has 1 input and 20 output paramenters.

I can call the stored procedure just fine and it works, but the problem i am having is values in the database are null values.

How do i handle this so it does not kill my web service?

Thanks for the help

jamesclose · Sep 18 '09, 10:50 AM

My problem is this (apologies if this is a little long ... hang in there):

I can define a function in VB.NET with optional parameters that wraps a SQL procedure:

Code:

 Sub Test(Optional ByVal Arg1 As Integer = 0, _
           Optional ByVal Arg2 As Integer = 0, _
           Optional ByVal Arg3 As Integer = 0)

    ' Call my SQL proc with the same signature

  End Sub

...

Search Result

Stored procedure to cancel an order

problem of insert multiple data into multiple table of sql

Help About Stored Procedure In Sql Server 2008

Help in stored procedure Using Sql Server 2008

How Can I Do Stored Procedure ?

How can I transfer an encrypted stored procedure in SQL Sever 2008 R2

Invalid parameter type between C# and Oracle

How to Use results of text and combo boxes for new record in table

How to call a stored procedure in Javascript

ssis package ran from sp_start_job complete before SP does next step?

using sql stored procedure on php

Db2 stored procedure fetch multiple rows

How to get a DataGrid that uses a Stored Procedure to initially populate to refresh

Null values and web service

How to specify DEFAULT for optional parameter to stored procedure wrapper function