Viewing 15 posts - 91 through 105 (of 1,113 total)
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.
September 8, 2011 at 6:47 am
In future, if there is any security added with 01/31/1998 date, i have to display from jan/1998 to till date.
September 8, 2011 at 1:51 am
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...
August 29, 2011 at 3:41 am
procedural capability is a beauty of T-SQL which makes it very powerfull tool to manipulate with data in SQL Server.
I got confused...could you pls refer the below link?
Joe Celko has...
August 24, 2011 at 3:38 am
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...
August 24, 2011 at 12:20 am
Jeff,
I always learn something new from your reply(for my thread). I learnt something new from this post too. Thanks a lot. 🙂
August 22, 2011 at 4:21 am
Eugene,
My hearty thanks to you for teaching me some good things 🙂 Thanks a lot..will meet you again in some other interesting thread...
August 22, 2011 at 4:19 am
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...
August 22, 2011 at 12:56 am
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...
August 19, 2011 at 7:59 am
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...
August 19, 2011 at 7:42 am
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
...
August 19, 2011 at 5:02 am
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 =...
August 19, 2011 at 4:18 am
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...
August 19, 2011 at 1:23 am
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...
August 19, 2011 at 1:18 am
Viewing 15 posts - 91 through 105 (of 1,113 total)