It can be max 50 values i can pass these values

I need a query without split function

I don't want to use static values

for example i had given two values in the query

so it can two values or more than two values

Please find the enclosed script for the code

Need to resolve this issue without using UDFS.

thanks and the following string will not work for yours solution

Declare @Sname Varchar(255)

set @Sname='SQL SERVER,ORACLE,MYSQL'

Need query urgent

Can you please give me examples on

a) Non-Updateable Views

b) Updateable Views

I had taken excel source and sql server destination in data flow task in ssis 2008

when im transfering the data excel source to sql server destination it is giving above...

Hi,

It should display 6 records only

my excel file contains only two columns