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....
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...
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
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 =...
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.
