Questions in topic: stored-procedures

votes

answers

665

views

Table valued Parameters

Feb 27 '11 at 10:54 PM Cyborg 10.1k

votes

answers

704

views

Passing parameters to the stored proc from csv source to populate data in the destinaton

Feb 27 '11 at 05:30 AM ThomasRushton ♦ 29.1k

sql-server-2008 ssis stored-procedures

votes

answers

650

views

[Closed] Calculate Business Hours Function

Feb 20 '11 at 07:11 PM Cyborg 10.1k

stored-procedures functions

votes

answers

398

views

Change date of all stored procedures

Feb 18 '11 at 12:24 AM App_Master 31

stored-procedures

votes

answers

431

views

alter table vs create(drop) in a stored procedure

Feb 13 '11 at 05:58 PM alkaplun 13

stored-procedures

votes

answers

595

views

optimise a sp

Feb 13 '11 at 06:18 AM ThomasRushton ♦ 29.1k

stored-procedures optimization

votes

answers

1.1k

views

execute formula stored in table

Feb 12 '11 at 12:59 AM Fatherjack ♦♦ 38.8k

stored-procedures dynamic-sql

votes

answers

353

views

Strange problem in Stored Procedure

Jan 21 '11 at 12:04 AM Matt Whitfield ♦♦ 29.2k

sql-server-2008 stored-procedures

votes

answers

665

views

which is the best way of approach

Jan 10 '11 at 12:32 AM Fatherjack ♦♦ 38.8k

t-sql stored-procedures schedule

votes

answers

views

different ways to use parameterized TOP statement, but which one is the best?

Jan 07 '11 at 03:06 AM Christophe Vanderhaeghen 73

sql-server-2008 stored-procedures parameters top

votes

answers

320

views

Don't Show Else Results

Jan 06 '11 at 10:44 AM LtDan 305

stored-procedures

votes

answers

1.2k

views

Getting biweekly periods, start_date and end_date

Dec 31 '10 at 06:20 AM Yada 11

stored-procedures sql-server date-functions

votes

answers

views

Problem writing one script to Drop, re-Create, and Grant Execute Permissions to a stored procedure

Dec 13 '10 at 02:22 PM Fatherjack ♦♦ 38.8k

sql-server-2008 t-sql stored-procedures permissions

votes

answers

962

views

Stored Procedures unit Test?

Dec 06 '10 at 02:43 AM Fatherjack ♦♦ 38.8k

stored-procedures parameters

votes

answers

3.2k

views

How do we a store Procedure Result in a scalar variable?

Dec 04 '10 at 03:29 AM Fatherjack ♦♦ 38.8k

stored-procedures variable output scalar

votes

answers

518

views

SSRS executes SP with 24 Result Lines - How do I get all 24 results in SSRS?

Dec 01 '10 at 04:36 AM kickinwing 31

ssrs stored-procedures

votes

answers

459

views

Need Help in creating Table but the columns should be Procedure Parameters?

Dec 01 '10 at 02:39 AM Matt Whitfield ♦♦ 29.2k

stored-procedures create

votes

answers

1.1k

views

Error handling EXEC(@CMD) in SP (SS2000)

Nov 12 '10 at 07:33 AM Oleg 15.4k

sql-server-2000 stored-procedures error-handling

votes

answers

721

views

Determine the values of a parameter

Nov 12 '10 at 04:00 AM Fatherjack ♦♦ 38.8k

t-sql stored-procedures parameters

votes

answers

627

views

How to get the count of Input Parameters and their names in SP ?

Nov 12 '10 at 02:57 AM Kev Riley ♦♦ 46k

stored-procedures parameters

votes

answers

2.3k

views

Select or Insert from table dynamically

Oct 22 '10 at 09:34 AM Doiremik 71

stored-procedures dynamic

votes

answers

767

views

Execution plan cache

Oct 14 '10 at 07:14 PM andypee 41

stored-procedures

votes

answers

744

views

Stored procedure caching results

Oct 14 '10 at 02:12 PM andypee 41

stored-procedures

votes

answers

14.7k

views

How to store the result in Temp Table from EXEC command ?

Sep 29 '10 at 08:15 AM Oleg 15.4k

stored-procedures temporary-table execute

votes

answers

1.3k

views

Nested Transactions in the stored proc

Aug 29 '10 at 12:41 PM Kev Riley ♦♦ 46k

sql-server-2008 sql stored-procedures parameters transaction

votes

answers

710

views

parameter in stored procedure

Aug 24 '10 at 02:41 PM Katie 1 1.4k

sql-server-2008 stored-procedures parameters

votes

answers

953

views

Executing stored procedures

Aug 23 '10 at 09:59 AM Katie 1 1.4k

sql-server-2008 stored-procedures execute

votes

answers

1.1k

views

stored procedure issue

Aug 18 '10 at 10:41 AM Oleg 15.4k

sql-server-2008 t-sql stored-procedures

votes

answers

1.3k

views

vbs difficulty in obtaining a recordset from a stored proc

Aug 17 '10 at 11:00 PM Fatherjack ♦♦ 38.8k

stored-procedures vbscript

votes

answers

1.7k

views

Convert Access Modules to SQL (store procedures)

Aug 17 '10 at 01:22 AM Kev Riley ♦♦ 46k

sql-server-2005 stored-procedures microsoft-access

votes

answers

456

views

[Closed] What is the issue here in the code?

Aug 16 '10 at 01:24 PM Fatherjack ♦♦ 38.8k

sql-server-2008 stored-procedures closed

votes

answers

625

views

What is the issue here in the code?

Aug 16 '10 at 01:23 PM Fatherjack ♦♦ 38.8k

sql-server-2008 stored-procedures

votes

answers

955

views

The Gestalt of Performance? Just curious...

Aug 10 '10 at 09:23 AM Mark 2.6k

sql-server-2000 stored-procedures performance

votes

answers

438

views

how to know the tables used in the stored procedure in a easy way

Aug 07 '10 at 01:55 AM mohandoss 13

stored-procedures

votes

answers

654

views

name most used / common stored procedures?

Aug 06 '10 at 01:35 PM codemihir1 1

stored-procedures

votes

answers

4.4k

views

There is already an object named '#tmpCostTable' in the database

Aug 01 '10 at 10:53 AM Fatherjack ♦♦ 38.8k

t-sql stored-procedures

votes

answers

950

views

Database enters null values alternately instead of variable value

Jul 19 '10 at 07:43 AM Kev Riley ♦♦ 46k

t-sql stored-procedures

votes

answers

513

views

[Closed] How to make a repetition?(pressing F10 without pressing it manually)

Jul 19 '10 at 01:48 AM Fatherjack ♦♦ 38.8k

stored-procedures closed

votes

answers

846

views

TVF is slower but less IO than stored proc

Jul 14 '10 at 07:22 AM Fatherjack ♦♦ 38.8k

sql-server-2005 stored-procedures table-valued

votes

answers

762

views

Violation of PRIMARY KEY constraint, when using hierarchical data

Jul 13 '10 at 06:40 AM MaverickUK 3

stored-procedures insert

votes

answers

1.4k

views

SQL Business Hours Calculation

Jul 09 '10 at 12:32 AM Fatherjack ♦♦ 38.8k

sql-server-2005 stored-procedures

votes

answers

159

views

Debugging remote stored procedures?

Jul 07 '10 at 03:46 PM Rick Schott 3

stored-procedures

votes

answers

969

views

Splitting column data into multiple columns through stored procedure

Jul 03 '10 at 09:09 AM Prashant Avhad 1

stored-procedures

votes

answers

344

views

SET @Where = @Where + ' AND AA.TargetDate >= ''' +

Jun 29 '10 at 05:25 AM Salim Akhtar 1

stored-procedures

votes

answers

1.3k

views

Passing input parameters to Stored Procedure from table

Jun 23 '10 at 02:09 PM evolveit 3

stored-procedures

votes

answers

1.1k

views

Column 'PrinterID' does not belong to table Printers

Jun 22 '10 at 07:29 AM Kev Riley ♦♦ 46k

sql-server-2008 stored-procedures vb

votes

answers

395

views

Is there a way to change the columns to rows in a stored procedure?

Jun 17 '10 at 12:18 PM Jenn S 1

sql-server-2005 stored-procedures

votes

answers

2.4k

views

Update Else Insert Procedure

Jun 16 '10 at 03:56 PM Kev Riley ♦♦ 46k

sql-server-2005 t-sql stored-procedures update insert

votes

answers

1.3k

views

SQL Server very slow creating stored procedure

Jun 15 '10 at 07:46 PM Kev Riley ♦♦ 46k

t-sql stored-procedures

votes

answers

813

views

Format Columns with sp_makeWebTask

Jun 14 '10 at 03:20 AM Umar 1 1

sql-server-2000 stored-procedures

340 questions

684answers

Follow @Ask_SSC

Follow Ask SSC on Facebook

Find Ask SSC on Google+

Find us on LinkedIn

Tags