No announcements
Found 421766 threads
-
0 VotesDynamic Stored Procedure
User-767555139 posted HI, I want to create a dynamic stored procedure. How can I create ...Answered | 3 Replies | 3 Views | Created by Anonymous - Friday, December 24, 2010 6:24 AM | Last reply by Anonymous - Friday, December 24, 2010 9:03 AM
-
0 Votes
dynamic stored procedure
Hi! I m using sql server 2005. i want to wirtie a dynamic stored procedure which can accept multiple queries as the user select.the problem ...Answered | 1 Replies | 5586 Views | Created by OM_12 - Wednesday, July 9, 2008 11:26 AM | Last reply by Kent Waldrop _ - Wednesday, July 9, 2008 12:15 PM -
0 Votes
Using EF 4.0 as a ReportViewer 2010 DataSource
As you mentioned you are using Entity Data Model to retrieve data by a stored procedure as an imported function. I created an example by the following steps:Answered | 1 Replies | 5507 Views | Created by REHixon - Monday, September 20, 2010 2:21 PM | Last reply by Tony Chain - Wednesday, September 22, 2010 6:00 AM -
0 Votes
reportviewer and stored procedure problem
User-1176988413 posted can you please review my code .. I used reportviewer in past but I did first time using stored procedure and it was not working ...Answered | 2 Replies | 11 Views | Created by Anonymous - Wednesday, October 10, 2012 12:34 PM | Last reply by Anonymous - Wednesday, October 10, 2012 1:09 PM -
0 Votes
reportviewer dynamic stored procedure
works in SSIS query window for you. Umm.. I think i am gettng it wrong. Do you mean you are associating stored proc from .NetCode to reportViewer ...Unanswered | 3 Replies | 12 Views | Created by Anonymous - Wednesday, May 1, 2013 5:49 AM | Last reply by Anonymous - Thursday, May 2, 2013 12:31 AM -
0 Votes
Dynamic parameters with stored procedure
User2073733224 posted Hi, I have a crystal report uses stored procedure. This stored procedure has 2 parameters - @year and ...Answered | 1 Replies | 15 Views | Created by Anonymous - Sunday, February 22, 2009 4:03 AM | Last reply by Anonymous - Sunday, February 22, 2009 9:42 AM -
1 Votes
Dynamic Oracle Stored Procedure
temporary Oracle stored procedure with parameters, then execute it. Question is, HOW??? I have seen tons of articles creating dynamicAnswered | 4 Replies | 3414 Views | Created by TDLABRIE - Saturday, June 9, 2012 6:24 PM | Last reply by Mike Dos Zhang - Monday, June 11, 2012 6:38 AM -
0 Votes
Dynamic Stored Procedure
SQL Server : generate select statement dynamically inside a stored procedure with dynamic column namesAnswered | 1 Replies | 12 Views | Created by Anonymous - Wednesday, November 20, 2013 10:21 AM | Last reply by Anonymous - Wednesday, November 20, 2013 10:35 AM -
0 Votes
Dynamic stored Procedure
caches execution plans for stored procedures. However, dynamic SQL in a stored procedure can be slightly slower than fixed procedure ...Answered | 15 Replies | 5 Views | Created by Anonymous - Monday, December 8, 2008 12:12 PM | Last reply by Anonymous - Friday, December 12, 2008 9:13 PM -
0 Votes
Dynamic SQL Stored procedure
dynamic SQL stored procedure. I am not successful in doing so. <<Answered | 4 Replies | 7548 Views | Created by Dheeraj M Uthaiah - Saturday, October 13, 2012 5:19 AM | Last reply by --CELKO-- - Saturday, October 13, 2012 2:58 PM -
0 Votes
Dynamic select in stored procedure
I find lots of articles about how to create dynamic linq in stored procedure, but all of them are dynamically build 'where' statement, I want to dynamically create select ...Answered | 3 Replies | 2367 Views | Created by Doraemon_3 - Thursday, February 2, 2012 7:15 AM | Last reply by Erland Sommarskog - Thursday, February 2, 2012 9:30 AM -
1 Votes
Help to Dynamic Stored procedure
=@CategoryId ORDER By Id DESC; END Here is my Stored Procedure: CREATE PROCEDURE [dbo].[Get_searchCore_RssListAnswered | 5 Replies | 2320 Views | Created by Henrik Stensgaard - Tuesday, February 14, 2012 4:23 PM | Last reply by Erland Sommarskog - Tuesday, February 14, 2012 11:13 PM -
0 Votes
Stored Procedure wit dynamic sql
Hi. My stored procedure executes dynamic sql instead of selecting. Linq generated wrapper returns the return value (int) of the ...Answered | 3 Replies | 4065 Views | Created by doker - Monday, July 21, 2008 4:57 PM | Last reply by doker - Tuesday, July 22, 2008 7:22 AM -
0 Votes
Dynamic Stored Procedure from Linq
User-39444305 posted Hi, can anyone help this. I don't know this is the right forum for this. I have a dynamic Stored ...Answered | 2 Replies | 9 Views | Created by Anonymous - Monday, August 10, 2009 10:10 PM | Last reply by Anonymous - Tuesday, August 11, 2009 12:57 AM -
0 Votes
dynamic recursive stored procedure
Hi all, I have a recursive stored procedure, and I want to add a dynamic where condition like this;Answered | 2 Replies | 4595 Views | Created by keskinTr - Thursday, August 28, 2008 1:46 PM | Last reply by adolf garlic - Thursday, August 28, 2008 2:34 PM -
0 Votes
help with dynamic stored procedure
User-507786106 posted Can I please get help with accessing an external stored procedure, I am not sure if I formated the stored procedure ...Answered | 2 Replies | 6 Views | Created by Anonymous - Friday, May 17, 2013 1:06 PM | Last reply by Anonymous - Friday, May 31, 2013 5:27 PM -
0 Votes
Differnetiate between static Stored procedure and Dynamic stored procedure
of the same stored procedure. So altemately all stored procedures get sorted in this method. Sachin.Answered | 3 Replies | 7009 Views | Created by SachinMiraje - Wednesday, August 13, 2008 1:16 PM | Last reply by Tom Phillips - Wednesday, August 13, 2008 1:53 PM -
0 Votes
Dynamic SQL in stored procedure
sp_executesql stored procedure to minimize this risk: DECLARE @stmt nvarchar(max); DECLARE @params nvarchar(max); SET @stmtAnswered | 5 Replies | 5 Views | Created by Anonymous - Sunday, November 11, 2012 5:39 PM | Last reply by Anonymous - Monday, November 12, 2012 6:03 PM -
0 Votes
Dynamic Search using Stored Procedure
User1508394307 posted You can try to do following in the stored procedure DECLARE @sql VARCHAR(1000) SET @sql = 'SELECT ...Answered | 1 Replies | 5 Views | Created by Anonymous - Tuesday, March 8, 2011 3:02 AM | Last reply by Anonymous - Tuesday, March 8, 2011 3:15 AM -
0 Votes
Dynamic Query In stored Procedure
queries I want to ask u that if i have written dynamic Query in stored procedure Will it do the same and stored the execution plan now ...Answered | 7 Replies | 26 Views | Created by Anonymous - Thursday, October 23, 2008 2:01 AM | Last reply by Anonymous - Saturday, October 25, 2008 6:20 AM - Items 1 to 20 of 421766 Next ›
No announcements
