CREATE

FUNCTION [dbo].[GetTaskDesc] ( @Task_Code VARCHAR(20) )

RETURNS

VARCHAR

From your example try this out

Considering all your variables are of VARCHAR type.

DECLARE @sql VARCHAR(2000)

DECLARE @dc_prd_year1  VARCHAR(50)

DECLARE store1  VARCHAR(50)

DECLARE @sc_store  VARCHAR(50)

SET

@sql =

Take a look at the article below. It could be of some help.

INSERT-EXEC section @

http://www.sommarskog.se/share_data.html

From your experience on the system can you specify if both master and detail tables are getting inserted in the same transaction boundaries? Triggers are realtime solution but you may...

Can you also specify how many columns are required to be compared. Cursor is very expensive method with respect to Performance.

Infact RIGHT function should also work

SELECT

CASE WHEN LEN(Incident_Details.Description)

Also if you are going with your own engine do take care of indexes the appropriate columns that are used as part of your search.

In most cases than not, cursors impact the performance adversely for obvious reasons of looping through and hitting db. Just to experience what difference it makes with reference to the...

Can u check with the .txt or .csv extensions? Or please open your excel file and paste some data that has more than 256 characters in the first row and...

Better way is to format it prior to sending to the table from your frontend code or inside the query.

Well you need to write a On Insert trigger for that if you want it to be automatically get appended with '00' as suffix.

Save the file as CSV or txt and try importing. You can also refer to http://support.microsoft.com/kb/281517/EN-US/

Yes, CASE statements can be nested without any restriction.

Probably you can write a small function and call it. Something like this

CREATE FUNCTION GetSize(

 @ProductNo VARCHAR(100),

 @Description VARCHAR(100)

RETURNS VARCHAR(1000)

AS

BEGIN

DECLARE @Size VARCHAR(1000)

SET @Size = ''

 SELECT @Size =@Size + CASE WHEN...

You can download the evaluation version from the microsoft site at:

http://www.microsoft.com/downloads/details.aspx?familyid=BA517C01-2E2F-4BC7-84AF-149B7637F807&displaylang=en