A subroutine available to applications accessing a relational database system.
0
votes
1answer
10 views
Stored procedure: take rows with summary resilts and place them in output parameters
Lets take a simple query
SELECT SUM(Field1), Field2 FROM TableName GROUP BY Field2
In my case I know for a fact that there are MAX 5 distinct values for field2 (1-5), so this query will return ...
1
vote
0answers
12 views
Dynamic XML to Stored Procedure Insert
I have xml similar like this:
<main>
<kim id="child1_id" name="this is child1" active="1" />
<kim id="Child2 id" name="this is child2" active="1" />
<lee ...
-3
votes
1answer
34 views
while using same table multiple times
I have Transaction table like this:
transactID TBarcode Ecode DelEcode PAICID status
------------------------------------------------------------
1 1234 E001 E002 ...
1
vote
1answer
27 views
Sum across partitions with window functions
I have the following problem...
Time | A | B | C -- Sum should be
1 a1 b1 c1 a1 + b1 + c1
2 a2 b2 x a2 + b1 + c1
3 a3 x x a3 ...
1
vote
6answers
53 views
SQL Server - Select * vs Select Column in a Stored Procedure
In an ad-hoc query using Select ColumnName is better, but does it matter in a Stored Procedure after it's saved in the plan guide?
0
votes
0answers
15 views
Entity Framework: Import function from SP won't produce complex type
I have access to a Stored Procedure, but I have no permission to change the Stored Procedure. I have added the SP to my Entity Framework model, and when I try and create a new complex type in the ...
0
votes
0answers
10 views
Stored procedure result without using OPENROWSET
I am currently using the process shown in the below link:
http://www.interworks.com/blogs/bbickell/2010/01/15/how-execute-and-monitor-agent-job-using-t-sql-sql-server-20052008
To get a job status, ...
0
votes
0answers
6 views
How to synchronize(update, insert) static(reference/setlist) tables from one databse to another one?
I need to find algorithms to update static(set-list, reference) tables from one database to the other one.
I have a -called- Big database and a Small database. Small DB has same schema and tables, ...
-1
votes
1answer
38 views
Oracle UNION not working
I have an Oracle Stored Proc - called from Java 1.6 code. There's a message that is sent out to a number and the number can reply on it. My problem is that the UNION part is not working.
I want one ...
0
votes
1answer
19 views
Passing CheckBoxList parameters to Stored Procedure
I have an asp.net checkboxlist which keeps my numbers
01
02
03
04
05
.
.
.
And I have a number field in my sql server database table, which can contain the values above. So when above fields ...
0
votes
0answers
7 views
UDT Sql server cannot be used for other users
I've create an SP like this:
ALTER pROCEDURE [dbo].[CARGATC]
@userdefinedtype somename readonly
AS
BEGIN
...
the stored procedure works right using my user, but others database users get fail. ...
0
votes
0answers
23 views
Not able to execute MS Sql server 2008 stored procedure using PDO - PHP [closed]
Following is my php code :
<?php
$startTime = 13700658;
$endTime = 13716658;
try {
$dbh = new PDO('sqlsrv:Server=localhost;Database=<serverName>');
$sql = "{Call mySprocName ('@startTime' = ...
0
votes
1answer
39 views
Joining with different table stored procedure
I have stored procedure like this
ALTER Procedure [dbo].[spCarCallFetch] @Carid nvarchar(20)
as
begin
Select
k.tid, k.HBarcode, m.make, t.plateno ,v.vtype, l.locname,
mdl.model, ...
0
votes
1answer
23 views
stored procedure for fetching data from multiple tables
I have Stored procedure like this
Select k.HBarcode, m.make,t.plateno ,v.vtype ,l.locname,mdl.model,c.Colname
from transaction_tbl t,
KHanger_tbl k,
make_tbl m,
vtype_tbl v,
...
1
vote
2answers
16 views
Passing a variable from Access (frontend) to SQL (backend) Stored Procedure
MY DB is in SQL. I am using Access as a frontend. Is it possible to take the value of a textbox, store it as a variable and pass it from Access to a Stored Procedure in SQL?
