thanks Jeff for your reply it worked.

i try to do other way with case statement and group by without success 😉

lets see if any one come up with...

this is a legacy system i am working , trying to mask all the credit card data that is in plain text. But the challenge itself is the way data...

thanks luis for your reply i was testing your solution and found there are more scenarios in my bad data. the system i am working on SQL 2005 so change...

Hey thanks for your reply, another issue i have is i dont want to transaction ID which is not a credit card number it has more than 16 numbers.

i have store data and requirement for monthly promotions is show promotions in a random order

not leaning towards one brand 🙂

Thanks it worked let me work on first set of data in the file.

Thanks again for your time.

thanks for your response. looks like you removed first set of data and loaded. when i try to load with first row as 9 table is not getting populated.

BULK...

O/p should be in comma separated

job-title

Admin, approve_perm

I have received file from other team,i will check with them, how it was generated.

About duplicate columns names, even though column name is repeated value is unique and it...

Thanks everyone for your response. I dont know much about c#, will try solutions provided by Phil and Wagner.

thanks

thanks but optional parameters are choose by user we need to build where clause based on user selection for each report

sorry i put question wrong way i need as below. when user chooses a field and condition i need to build string dynamically

drop table #temp

create table #temp

(

Col1 char(10) ...

thanks for your reply Jeff. Data is correct,

Ex: BOFA has multiple share holders and it can hold shares on its own account.

If BOFA has a child as bank A,B

Bank B...

Thanks for all your suggestions.

this is a temporary solution we are going to have external service which is going to call stored procedure whenever these is a new record.

thanks i will schedule a job to run every 10 minutes in that way it will run continuously