I Have created an SSRS Report for retrieving 55000 records using a Stored Procedure.When Executing from SP it is taking just 3 Seconds but when executing from SSRS report It is taking more than one Minuits.How i can solve this problem?
Answer Question | December 20, 2008 12:05 PM
SQL Server Reporting Services, SQL Server stored procedures, SSRS, SSRS Performance, Stored Procedures
How do views, user-defined functions (UDFs) and stored procedures work in SQL, and what conditions are there on their usage?
Answer Question | November 19, 2008 2:55 PM
SQL Server stored procedures, SQL Server views, UDF
This one will be easy, I’m sure. I’m a novice at Stored Procedures, and I’m wondering what function I can use to display a smalldatetime field (currently displaying as Dec 19, 2008 12:00AM) as a short date (12/19/2008)? I am on Sql Server…
Answer Question | November 11, 2008 9:18 PM
DateTime, SQL Server stored procedures, Stored Procedures
I need to write a stored procedure to insert into a SQL database the contents of a file that has been in read in ASP.net. How would I do this?
Answer Question | November 10, 2008 3:37 PM
ASP.NET, SQL Database, SQL Server stored procedures
Hi the code is like this. Its taking too long to excute. if exists(select jbadsd from saldayf sa where substring(convert(char(7),sa.jbadsd),4,4) = substring(convert(char(7),@jbadsd),4,4) and substring(convert(char(7),sa.jbadsd),2,2) = ’07′) –print’exists’ update [national].dbo.tempsaldayfna set castsdly = sa.sum_castsdly from [national].dbo.tempsaldayfna sna inner join (select cusnsd,dseqsd,slmnsd,pnumsd,slm4sd,slm5sd,jbadsd, sum( castsd) as ‘sum_CASTSDlY’ from saldayf group by cusnsd,dseqsd,slmnsd,pnumsd,slm4sd,slm5sd,jbadsd) as sa on sa.cusnsd = sna.cusnsd [...]
Answer Question | November 6, 2008 5:05 PM
SQL Server 2005, SQL Server stored procedures
I am supposed to Run an sproc /script for more than one database. I thought of scheduling this sproc as a job for all database instances. But, DBA’s suggested me to go with SSIS Package. Can any one quide me in doing this.
Answer Question | November 6, 2008 12:57 PM
Business Intelligence, SQL Server 2005, SQL Server 2005 Integration Services, SQL Server Integration Services, SQL Server stored procedures, SSIS Package, Stored Procedures
I have a stored procedure that runs on my Production database in 0.394 seconds. However, when I try to run the SP on a DEV box it takes well over 15 minutes to run *every* time. I have checked indexes and everything seems to be identical (I did a backup/restore to the Dev box in [...]
Answer Question | November 3, 2008 9:01 PM
SQL Server 2000, SQL Server 2005, SQL Server Query, SQL Server stored procedures, Stored Procedures
Using LSXODBC and ODBCResultSet, how do you pass parameters to a stored procedure using result.Execute or result.ExecProcedure? I am looking for a working example not just syntax.
Answer Question | October 8, 2008 5:57 PM
LotusScript, ODBC, SQL Server stored procedures
I’d like to execute different tables at runtime on my SQL Server by creating stored procedures. This is the syntax I am attempting to use: “create procedure sp1(colname varchar(400), tab_name IN varchar2) AS BEGIN select * from ‘@TABLENAME’ where CompanyName=’@COLUMNNAME’ end” Is this syntax accurate, and if not, how could I create this stored procedure?
Answer Question | September 18, 2008 7:21 PM
SQL Server stored procedures, Stored Procedures
I ‘ve a problem with porting my ms access database to sql server. In my inventory database, i have 4 tables: (1)Purchase, (2)Sales, (3)Quantity Adjustment, (4)Amount Adjustment. I want to calculate the stock position from those 4 tables. In access database, i do with this kind of queries : a. parameterized query to filter each [...]
Answer Question | September 1, 2008 6:27 PM
Access Database, Microsoft Access, SQL Server database, SQL Server stored procedures
when a stored procedure is executed in query analyzer its working fine and getting the result quickly.but when same procedure is executed through visual studio timeout expired error is generated.can any one olve this issue
Answer Question | May 21, 2008 6:24 AM
SQL, SQL Query Analyzer, SQL Server stored procedures, Stored Procedures, Visual Studio
I want to have a stored procedure on a server in Domain A, read data from some tables in Domain B. Is this possible in SQL Server?
Answer Question | April 29, 2008 3:49 PM
SQL Server stored procedures, Stored Procedures
WE are dealing with stored procedures in a PL/SQL program. I am trying to execute the procedure from within the program itself. Is there a need to do it within a cursor or is there a specific manner to do that?!
Answer Question | April 28, 2008 10:53 AM
EXEC, PL/SQL, SQL Server stored procedures, Stored Procedures
Is there any way I can create a stored procedure which will check for the Transaction Log file size – where we have a specified limit to grow – and if the Log file reached 80 percent of total size, email alerts can be sent to DBAs?
Answer Question | April 18, 2008 1:11 PM
SQL Server availability, SQL Server stored procedures, SQL Server transaction logs