I tried below expression.

But it's not working.

While Importing data from Input file to the derived column , if input file contain any empty value it's not...

Thank you so much Luis Cazares,

You are Awesome!!!.

I learned cross Apply now how to use...

Thanks,

Thanks for your reply Jeff,

I used the below script , but it's not working like my ouput:

DECLARE @DynamicPivotQuery AS NVARCHAR(MAX)

DECLARE @ColumnName AS NVARCHAR(MAX)

--Get distinct values of the PIVOT Column...

Hi,

Thanks for your reply,

I Need show Column names as End dates with concatenation like below.

January 1st has Occured on Thursday so it should be Last Week of December.

01/09/2015 is...

Hi,

I need to run this Job On every week on Friday.

If i run the Job On Middle of Feb on Friday, it needs to calculate From Jan-Feb of Current Friday.

How...

Hi,

I got the Solution.

Below is the Solution.

DECLARE @STR VARCHAR(400)

--Add your specialcharacters here

DECLARE @specialchars VARCHAR(50) = '%[~,@,#,$,%,&,*,(,),.,!^?:]%'

SET @STR = 'KRA!NTHI@#KUMAR, KU%^?MAR GO~()$U.:D'

WHILE PATINDEX( @specialchars,

Hi,

Sorry some mistake.

It need to calculate between Week Begin Date and End Date.

If i run the Job on January 9th.

January 1st week we have only 2 Dates Jan 1st and...

Hi,

Thanks for your reply.

We need to run Friday at the End of the Day.

Thanks,

My problem is solved.

I changed the Collation of Database.

It's working Perfectly.

Thanks

One More Small Issue can you help...

create table #table (id int, cid int , startdate datetime)

insert #table

select 1, 100, '02/23/2014'

union select 1, 100, '06/25/2013'

union select 1, 100, '06/04/2013'

union select 1,...

One More Small Issue can you help...

create table #table (id int, cid int , startdate datetime)

insert #table

select 1, 100, '02/23/2014'

union select 1, 100, '06/25/2013'

union select 1, 100, '06/04/2013'

union select 1,...

Thank you so much...it help me lot....

Big thankful to all the members....

Thanks,

Thanks for your reply,

But there is no end date....I need to calculate the End date based on Start Date.

Example I am calculating the 2013 year Data.

If Start date date 2014...

Hi Ivan Mohapatra,

I tried in Where Condition It self..

Thanks,

Hi,

i am using your code to search word in sql server table.

I have one table candidates , i have lakhs of records in a Table.

...