Who is online?
0
guests and
0
members
Member login
|
Become a member
Home
Articles
Forums
Blogs
Jobs
Events
Files
Spaces
People
login
register
Home
» search results
Search Results: Stored Procedure
269 results found
TSQL Basics Part 4 -
Stored Procedure
First and foremost, let's start off with a definition of a Stored Procedure: It is a compiled set of SQL Commands stored within a database server and is executed as single entity. In this blog, I wanted to show you how to create a couple of different Stor
Author:
SMcDonald
Date: 7/19/2010 Section:
Blog
tags :
BIDN
,
Parameters
,
Pragmatic Works
,
TSQL
,
Stored Procedures
Fully Qualified
Stored Procedure
s
The other day while working at a client site, we were creating SSIS packages that would execute using TSQL in order to load a database. We wanted to eliminate having a bunch of different shared data sources and then having to create configuration files fo
Author:
SMcDonald
Date: 11/3/2010 Section:
Blog
tags :
fully qualified
,
Pragmatic
,
Sherri McDonald
,
SSIS execute SQL Task
,
stored procedure
,
Harding coding
Building a Report from the Ground Up - Part 1: Creating a
Stored Procedure
In this article, Dustin covers the basics of how to create a stored procedure and save it for future use within your database using SQL Server Management Studio.
Author:
DustinRyan
Date: 11/24/2009 Section:
Article
tags :
Parameter
,
SQL
,
Stored Procedure
,
SSRS
SSRS dataset fields disappear when using a stored procedure with dynamic SQL – How to get them back and save your report
Every once in a while I write some dynamic SQL for a stored procedure that I am using for several different reports. Pros and Cons of dynamic SQL aside, this is a very useful technique in some circumstances. However from time to time if you use dynamic SQ
Author:
Daniel
Date: 6/16/2011 Section:
Blog
tags :
Dynamic SQL
,
Fields disappear
,
Fields Missing
,
SSRS
Get a Count of Stored Procs in a Database
This morning, I had to compare a documentation of a SQL database to what was actually in the database. More specifically, the stored procedures. The client wasn’t sure if all the stored procedures were showing up in the documentation. I looked at the stor
Author:
ShawnHarrison
Date: 9/23/2010 Section:
Blog
tags :
Management Studio
,
sysobjects
,
TSQL
,
Stored Procedures
SSIS 2008 Logging and Package Configuration Objects FAQ
SSIS 2008 Logging to SQL Server 1. Can I change the dbo.sp_ssis_addlogentry system stored procedure to non-system stored procedure and if so how is this done? Yes – you must drop and recreate the procedure (and don’t run [sp_MS_marksystemobject] N’[dbo].[
Author:
JoeSalvatore
Date: 2/25/2011 Section:
Blog
tags :
2005
,
2008
,
2008 R2
,
Business Intelligen
,
SQL Server Versions
,
SSIS Integration Services
,
SQL Server
Parameterized Report using a
Stored Procedure
Download Sample Project: Parameterized Report In a recent forum post on BIDN.com a person asked how to filter the result on the report based on a stored procedure parameter. Since a short blog post without screen shots wouldn’t fully explain how to accomp
Author:
PatrickLeBlanc
Date: 6/13/2010 Section:
Blog
tags :
Stored Procedures
,
SQL Reporting Services
Stored Proc: xp_cmdshell to exec dtexec utility
UPDATE / Solution? - You decide. Resolution: Lack of understanding as to how a SQL Agent Job functions when executed within a Stored Procedure. Brief Recap: Stored procedure executed from a sql script. Stored procedure expects 1 parameter. Within Stored P
Author:
JohnG
Date: 7/29/2010 Section:
Forum
tags :
dtexec utility
,
sql agent job
,
Stored Procedure
,
SSIS
Dataset with Text or
Stored Procedure
As most of you already know, Reporting Services reports make use of Datasets to get data. These Datasets can get the data from Text, Table (rarely used) or a Stored Procedure. Which query type to use has been a topic on many forum boards and I’ve ha
Author:
briankmcdonald
Date: 10/2/2011 Section:
Blog
tags :
Brian K McDonald
,
Dataset with query type text or stored proc
,
sqlbigeek
how to use parameter label as database named in dataset
As far as I understand from your problem, you have 2 databases and you want to select data from one table wich has the same name in both databases. Question: Can you select data from both tables when connected to the default database? Can this be a soluti
Author:
marcoadf
Date: 1/15/2012 Section:
Forum
tags :
database
,
Dataset
,
from
,
if
,
multiple
,
parameter
,
select
,
sp
,
Stored Procedure
,
table
Memorized Reports
While all suggestions are good ones, you could capture the results of the parameters and the users from the ReportServer database. There are executions of each report, who executed them, how long it took and a lot more. With that being said, you would jus
Author:
briankmcdonald
Date: 9/10/2012 Section:
Forum
tags :
Brian K. McDonald
,
parameters
,
Pro SQL Server 2012 Reporting Services
,
SQLBIGeek
Notes on Parameters in SSRS Session
Last weekend, I presented a session on basic parameters in SSRS at SQL Saturday #38 in Jacksonville. First off, I would like to thank everyone who attended. I just wanted to go over a few notes from the presentation. Always use parameters in your reports.
Author:
ShawnHarrison
Date: 5/11/2010 Section:
Blog
tags :
parameters
,
SSRS
,
SQL Saturday
Capture SSIS Package Execution Status
Executing an SSIS package from within a stored procedure is not an uncommon request. People sometimes scratch their head when it comes to figuring out if that package ran successfully or not though. There may be a process that runs a stored procedure and
Author:
BradSchacht
Date: 8/5/2010 Section:
Blog
tags :
Stored Procedure
,
SSIS
SQL Server™ Schemas and Data Warehouse Solution Organization
Good organization helps us to develop efficiency and, even more importantly, increases our solutions understandability. Organizing the physical implementation of a business intelligence solution’s data tier within SQL Server™ is critical for organizing th
Author:
JoeSalvatore
Date: 2/25/2011 Section:
Blog
tags :
2008
,
2008 R2
,
Business Intelligence
,
Data Design
,
Schemas
,
SQL Server
,
SQL Server Versions
,
2005
Reporting Services Parameters Not Updating
In this article, Brian will show you how to map report parameters after modifying stored procedures that didn't have any (or after adding) parameters.
Author:
briankmcdonald
Date: 6/12/2010 Section:
Article
tags :
Parameters Not Mapping
,
Reporting Services
Delete data
I personally would use an Execute SQL task and pass in the parameter to a stored procedure. However, you don't have to have a stored procedure. You could just pass the paramters in and do something like this. DELETE FROM TableName WHERE ((ColA = ? OR ColA
Author:
briankmcdonald
Date: 9/12/2011 Section:
Forum
tags :
Delete Data
Minimum Requirements
Situation: Test User needs to run an application that executes stored procedures, which execute SSIS packages. Test User's PC is not installed with the FULL version of Sql Server 2008 R2 Resolution: In order for Test User to execute dtexec for package exe
Author:
JohnG
Date: 7/30/2010 Section:
Forum
tags :
installation requirements
,
SQL Agent Job
Using a
Stored Procedure
as a Data Source in SSIS or SSRS
We often like to use stored procedures to return our result sets because we can easily aggregate data together and perform multiple steps in an organized way. However, SSIS and SSRS both see result sets a little differently than you might think. Many stor
Author:
benagee
Date: 12/2/2009 Section:
Blog
Building a Report from the Ground Up-Part 5: Parameters
In Part 5 of Building a Report from the Ground Up, Dustin covers how to add a drop down list parameter to your report.
Author:
DustinRyan
Date: 12/1/2009 Section:
Article
tags :
parameters
,
SSRS
Building a Report from the Ground Up - Part 3: Displaying the Data in a Table
In Part 3 of Building a Report From the Ground Up, Dustin covers how to add a table to your report and display data. Dustin also briefly covers formatting your header and text boxes.
Author:
DustinRyan
Date: 12/18/2009 Section:
Article
tags :
Reporting Services
,
SSRS 2008
Passing an argument to an Oracle
Stored Procedure
and returning a record set to SSRS 2008 R2
Hi all! I am having an issue retreiving data from a Stored Procedure in Oracle to SSRS. First, I have to keep this Stored Procedure in Oracle because it is passing data of the LONG data type to SSRS and I can not seem to find a way to get a SQL Storded Pr
Author:
EvilEd209
Date: 5/6/2011 Section:
Forum
tags :
ORACLE
,
Parameters
,
Stored Procedure
Parameters
syale said: Unfortuneatly I only have read privileges on the datasource. Getting a stored procedure instantiated in a data sensitive area will take weeks. I'm with Brian, get the procedure modified - or at least get the process started. As a stop-gap, you
Author:
KeithHyer
Date: 9/15/2011 Section:
Forum
tags :
avoid dynmaic sql
,
optional parameters
Problem Passing a SSIS Variable with a string datatype to a
Stored Procedure
requiring a uniqueidentifier
I have a SSIS package that uses a SQL Server stored procedure as a data source. The parameter in the stored procedure is pulling data from a column with a uniqueidentifer (guid) data type. I created a package level variable in SSIS with a string datatype.
Author:
knollwooddrive
Date: 5/20/2011 Section:
Forum
Run SSIS Package through Store Procedure
Take a look at these regarding executing a package from a stored procedure: Running a package from a procedure as the administrator: http://www.databasejournal.com/features/mssql/executing-a-ssis-package-from-stored-procedure-in-sql-server.html Running a
Author:
KeithHyer
Date: 10/11/2011 Section:
Forum
tags :
credential
,
package from procedure
,
permissions
,
proxy
Pivoting Diagnoses, Procedures and POA using a
Stored Procedure
called from SSIS
In this article, I describe the way in which I used a stored procedure to pivot data into columns as well as the use of SSIS in automating the process of extracting data from SQL Server, transmitting to my customer and notifying us in an automated fashion
Author:
schilders
Date: 8/3/2011 Section:
Article
Page 1 of 11 (269 items)
<< Prev
1
2
3
4
5
6
7
8
9
10
11
Next >>
Go to page:
[Go]