Hi all, I have a windows service which is written in VB.NET. Windows Service reads data from the database, does calculation and stores to database....
I am using inner join to link all the tables along with some where condtions which contains like operators and that conditon status=1. i browsed the...
Hi all, I am using a query which will join more than 10 tables to fetch data. When i analsyed the execution plan i noticed that the query cost is...
The table that I am going to fetch contains around 11,000 records. The recursive function finds teh first parent of the current child value. So it...
Hi all, I am having a SELECT query to fetch data for SQL Server Reports. The SELECT query is having a recursive function to retrieve value for each...
Hi all, I am using a DTS active-x vbscript to read data from database, process it and store to destination table. The total number of records that I...
Hi all,<br /><br />I am getting the error "Invalid use of default parameter" when I run the DTS which uses VBScript language. DTS calls a package...
Hi all, Whether adding or deleting columns from the sql server affect the replication of the sql server. Do we need to do remove the columns from...
Hi all,<br /><br />I am having a scenario to generate auto numbers for inserting into a table inside Transform Data Task.<br /><br />I have used...
Hi all, How to display an image in SQL Server Reports. Thanks and Regards, Ram Kumar N D
The temp table is already having some rows. so i need to get the identity values for the latest select query thet i had executed
Hi all, I am using the following sql statements to select from a table and insert into destination table. SELECT * INTO TEMP_TABLE FROM TABLE1 How...
CREATE FUNCTION [dbo].[FindParent] (@no varchar(25)) RETURNS varchar(25) AS BEGIN DECLARE @Parent varchar(25) SELECT @Parent =...
This is my stored procedure template:<br /><br />ALTER PROCEDURE InsertData (@l_FromDate as nvarchar(10), @l_ToDate As nvarchar(10)) as<br />...
Both the servers are in the same network<br /><br />the database where we are going to insert records in the actual production server and i am...
I have a stored procedure in one server and a DTS in another server which just calls the stored procedure. The logic of the stored procedure is as...
Separate names with a comma.
