Questions in topic: stored-procedures

votes

answers

780

views

Syntax error when creating a stored procedure with multiple PIVOTs

Feb 19 '10 at 04:17 PM Matt Whitfield ♦♦ 29.2k

stored-procedures pivot

-1

votes

answers

358

views

[Closed] call procedure and passing the next line

Feb 19 '10 at 01:29 PM Kev Riley ♦♦ 46.1k

stored-procedures

votes

answers

1.2k

views

Stored procedure that reads continually from a message queue

Feb 18 '10 at 05:55 AM murfinp 11

stored-procedures

votes

answers

1.2k

views

cannot pass null value into sp

Feb 16 '10 at 08:26 AM Kev Riley ♦♦ 46.1k

stored-procedures null

votes

answers

431

views

CLR Stored Procedure

Feb 16 '10 at 01:21 AM Partha 1

stored-procedures clr

votes

answers

427

views

Create Table syntax - flat file

Feb 12 '10 at 03:51 PM Jim Czerniak 24

sql-server-2000 stored-procedures

votes

answers

453

views

Empty Stored Proc takes 8ms to complete?

Feb 11 '10 at 09:16 AM Rich 1 1

sql-server-2008 stored-procedures

votes

answers

1.5k

views

Error 21001: [SQL-DMO]Stored procedure

Feb 09 '10 at 09:27 AM Kev Riley ♦♦ 46.1k

sql-server-2000 stored-procedures

votes

answers

5.8k

views

Must declare the table variable in a stored procedure

Feb 07 '10 at 04:24 PM graz ♦ 525

stored-procedures table-variable temporary-tables

votes

answers

774

views

row as column in ms sql 2005

Feb 07 '10 at 04:23 PM graz ♦ 525

stored-procedures pivot

votes

answers

1.3k

views

Create a new table and insert / update it in one procedure?

Feb 05 '10 at 05:50 AM Fatherjack ♦♦ 38.8k

stored-procedures existing-table

votes

answers

1.8k

views

Passing Unicode Parameter to Stored Procedure

Feb 04 '10 at 11:43 AM graz ♦ 525

stored-procedures programming unicode

votes

answers

725

views

how to create stored procedures?

Feb 02 '10 at 06:37 AM Steinar 1.7k

sql-server-2005 stored-procedures

votes

answers

316

views

Create/Save stored procedure with errors on MS SQL 2005

Feb 01 '10 at 09:53 AM Kristen ♦ 2.2k

sql-server-2005 stored-procedures

votes

answers

1.3k

views

How to pass a CSV to a stored procedure for an IN statement

Jan 31 '10 at 03:09 PM graz ♦ 525

sql-server-2005 stored-procedures csv

votes

answers

1.6k

views

Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.

Jan 29 '10 at 01:55 AM Rob Farley 5.7k

stored-procedures

votes

answers

617

views

Stored procedure problem

Jan 28 '10 at 11:42 AM Car 3

sql-server-2005 t-sql stored-procedures

votes

answers

734

views

Looping through a dataset of records.

Jan 28 '10 at 12:52 AM Batteryacid 12

sql-server-2005 t-sql stored-procedures query

votes

answers

2.8k

views

Execute Permission to Particular Stored Procedure or Function in All databases of a SQL Server 2008 Instance

Jan 27 '10 at 09:13 PM Rob Farley 5.7k

sql-server-2008 sql stored-procedures permissions

votes

answers

1.3k

views

Split a field into rows and columns - SQL 2005

Jan 27 '10 at 10:57 AM graz ♦ 525

sql-server-2005 t-sql stored-procedures

votes

answers

1.8k

views

Same procedure taking different times to run from the website and management studio

Jan 25 '10 at 09:10 AM Colin Wilson 41

stored-procedures profiler timeout-expired

votes

answers

3.4k

views

SQL server load testing tool?

Jan 22 '10 at 07:19 PM Bhaskar 333

stored-procedures

votes

answers

873

views

Can we use Oracle Developer Tools 11g for Visual Studio with Visual Source Safe ?

Jan 22 '10 at 07:39 AM David Atkinson 317

oracle stored-procedures

votes

answers

1.3k

views

Alternative to 'GO' for batching SQL statements

Jan 22 '10 at 07:10 AM Nigel Ford 1

stored-procedures

votes

answers

942

views

Need to Create function for this block

Jan 21 '10 at 11:42 PM Rob Farley 5.7k

sql-server-2005 stored-procedures functions date-functions

votes

answers

954

views

Matching corresponding records from two or more tables

Jan 20 '10 at 04:55 PM desiabhi 33

sql-server-2005 sql-server-2008 t-sql stored-procedures

votes

answers

547

views

Which stored procedure will we be running to add a linked server?

Jan 18 '10 at 09:48 AM OraLearner 1.3k

stored-procedures sqlserver procedures

votes

answers

1.6k

views

Stored Procedure to delete child and parent table

Jan 15 '10 at 08:37 AM Kev Riley ♦♦ 46.1k

stored-procedures

votes

answers

735

views

Moving Average Stored Procedure

Jan 09 '10 at 02:31 PM Kristen ♦ 2.2k

sql-server-2005 stored-procedures

votes

answers

1.5k

views

SSIS Execute SP with parameters from CSV

Jan 07 '10 at 03:03 PM AlAlper 3

sql-server-2005 ssis stored-procedures

votes

answers

370

views

Sql Server Stored Procedure

Jan 04 '10 at 09:03 AM Kev Riley ♦♦ 46.1k

stored-procedures

-1

votes

answers

700

views

Create Stored procedure not working properly

Dec 28 '09 at 08:46 AM NewBie 2

stored-procedures

votes

answers

263

views

Create stored procedure in the MYsql DB

Dec 28 '09 at 03:04 AM NewBie 2

stored-procedures

votes

answers

697

views

Create a dynamic Where clause based on Parms from report services

Dec 21 '09 at 11:57 AM Goldie50 1

stored-procedures parameters

votes

answers

1.5k

views

Threading and Stored Procedures

Dec 16 '09 at 06:33 PM Kev Riley ♦♦ 46.1k

stored-procedures parallelism

votes

answers

981

views

How to view return value of Oracle stored function containing DML in PLSQL Developer?

Dec 12 '09 at 08:43 PM jcraig11 21

sql stored-procedures plsql

votes

answers

336

views

Stored Procedure - syntax error

Dec 11 '09 at 07:26 AM Kev Riley ♦♦ 46.1k

stored-procedures

votes

answers

36.1k

views

Grant execute permission to all stored procedures

Dec 08 '09 at 01:29 PM Steve Jones - Editor ♦♦ 5.1k

stored-procedures permissions

votes

answers

1.2k

views

Easy way to manage full database name in stored procedures and triggers?

Dec 07 '09 at 07:32 PM Giablo 25

sql-server-2000 stored-procedures trigger

votes

answers

1.7k

views

Consolidate multiple scripts into one job?

Dec 07 '09 at 05:14 PM Kev Riley ♦♦ 46.1k

stored-procedures job script maintenance-plans

votes

answers

2.6k

views

How To Update A Dynamic SQL Table With A Set Variable?

Dec 03 '09 at 04:44 PM Kristen ♦ 2.2k

t-sql sql-server-2000 stored-procedures

votes

answers

1.8k

views

How To Create A Cursor That Uses Dynamic SQL?

Dec 03 '09 at 09:34 AM Kristen ♦ 2.2k

t-sql sql-server-2000 stored-procedures cursor

votes

answers

607

views

How To Create A Stored Procedure To Create A Table Passing Table Name In As A Parameter

Dec 02 '09 at 06:50 AM David 2 1 314

t-sql sql-server-2000 stored-procedures

votes

answers

355

views

stored procs and joins

Nov 30 '09 at 03:38 PM arun 1

stored-procedures

votes

answers

262

views

Stored procedure Issue.

Nov 27 '09 at 04:13 AM vinoth 1

stored-procedures

votes

answers

views

Trouble Creating Procedure With While Loop

Nov 25 '09 at 09:00 AM Kristen ♦ 2.2k

t-sql sql-server-2000 stored-procedures

votes

answers

543

views

Error Handling for Inline sp

Nov 25 '09 at 08:54 AM Kristen ♦ 2.2k

sql-server-2000 stored-procedures error-handling

votes

answers

776

views

Which system stored procedures do you use?

Nov 23 '09 at 08:55 PM Matt Whitfield ♦♦ 29.2k

t-sql stored-procedures

votes

answers

1.8k

views

how can we use "Select into" statement with a newly declared table(Stored procedures)

Nov 20 '09 at 11:06 AM Melvyn Harbour 1 ♦♦ 1.4k

t-sql stored-procedures

votes

answers

1.3k

views

Input Parameter for Stored Proc in Execute SQL Task 2008

Nov 20 '09 at 08:56 AM Kev Riley ♦♦ 46.1k

sql-server-2008 stored-procedures

340 questions

685answers

Follow @Ask_SSC

Follow Ask SSC on Facebook

Find Ask SSC on Google+

Find us on LinkedIn

Tags