if you are using this code in stored procedure then plz paste complete sp here

since what problem is there in compliation if field is not exist and u are updating...

Hi

if your intention is to only return table by dynamic sql which later on you will join with other tables then why you are not writing stored procedure instead of...

Hi

No I dont think so

I think you are trying to insert data from table A to table B

if any column's data is > 512 character then you need to...

Hi Anoop

You can take the output of calling sp using output parameter. Alternatively you can use udf also.

Thanx

Vaseem

Hi

I was facing the same problem last week where I have to update my database table from a flat file changed everyday having some new records and some updated records.

Truncating...

Thanks

I have a table like

tblProducts

Id Voltage

1 230

2 200/250

3 230/180

4 250

I want...

Hi

How to add Event handlers in SSIS.

Can anybody explain?

Vaseem

Hi

I have create a package configuration using package type "XML configuration" and exported the all connection ( database/flat file location/ftp location) and its created myfile.dtsConfig properly.

After this I have saved...

Hi

Staging table logic works great.

Now I have some other requirement. I want to do all these task on a specific condition else some other task. Is there any method...

Thanks for prompt response.

i will check the options which you are suggesting but performance will be the issue since I m working on huge records more than 3 lakhs, so...

Hi

Thanks

its working properly. Now I want some other task, I do not want to insert records from flat file to table every time, I want to insert only that record...

Hi

Definitely there is no need of Group by statement since you need only one coulumn MIN(User2.StartDate) and in where clause you already given User1.UserGuid = User2.UserGuid.

SELECT

User1.UserGUID,

User1.BranchID,

User1.StartDate,

(

SELECT MIN(User2.StartDate) FROM...

Great work tariq

Its really good logic

yes, in case of @product_name = 'All' its giving error

but you cannot return list from case statement.

you can use this one for your requirement

DECLARE @product_name nvarchar(3)

SET @product_name = 'All'

SELECT...

Hi

Use this one

DECLARE @product_name nvarchar(3)

SET @product_name = 'A'

SELECT * FROM dim_product

WHERE source_product_name IN

...