CoolingPipe(Scott) (9/8/2011)

declare @sql varchar(max)

set @sql = 'select Sec_Id'

select @sql = @sql + ',

max(case perf_dt when cast(''' + convert(varchar(10),perf_dt,101)

+ ''' as datetime)...

When we use PIVOT we have to mention the date in the IN clause. Right?

But in our case we don't know the available dates. It may vary every month.

In future, if there is any security added with 01/31/1998 date, i have to display from jan/1998 to till date.

sorry..since i read that article, i just got confused. Thats why i brought the same here for reference...

I have gone through that post. I have to go back and read...

I got confused...could you pls refer the below link?

http://www.simple-talk.com/sql/t-sql-programming/procedural,-semi-procedural-and-declarative-programming-in-sql/

Joe Celko has...

Procedural program - some series of computational steps to be carried to solve a problem.

Declare @id int

select @id = id from emp where eno = 5

can we say it as...

Jeff,

I always learn something new from your reply(for my thread). I learnt something new from this post too. Thanks a lot. 🙂

Eugene,

My hearty thanks to you for teaching me some good things 🙂 Thanks a lot..will meet you again in some other interesting thread...

Incase if 6 values comes with the delimeter, I have no choice apart from ROW_NUMBER() PARTITION BY or SELECT INTO WITH IDENTITY , UPDATE WITH MODULO DIVISION ( UPDATE...

EE,

I am sorry..how should i call you? Eugene? thats why i used EE...

we will come out from this requirement and see something related to sequence number generation....

create table acc

(

id...

EE,

Really you opened my eyes broadly...Thanks a lot...

do you mean if we have only 1 i.e

(only single '1')

10

100

1000

10000

(all '1')

1

11

111

1111

I feel little bit hard to grasp all your points.

what...

ok. i got it...

it apply the AND logic not the binary addition logic.

0 0 0

0 1 0

1 0 0

1 1 1

1 --> 01

3 --> 11

...

why you used "3" ?

If I use any other number, it is not working as expected. what is the reason behind the usage of 3?

select 1 & 3 =...

It seems like decimal to binary conversion and binary to decimal happening internally..but i am not still that much clear behind this UPDATE statement.

is it something the equivalent binary number...

It shows zero only 4,8,12,16 etc., (4 and its multiplication 4*1, 4*2, 4*3 etc.,)

how?

select 5 &3 = 1

when it comes to 5, againt the sequence reset to 1. how?

select 6...