Viewing 11 posts - 541 through 551 (of 551 total)
Hello Gail!
Thanks a lot again. Definitely going to get one.
You have any book recommendation or any tips to follow on?
🙂 RMudugal
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
March 2, 2010 at 4:26 am
Hello Gail
Thanks a lot.
I just gone through the link... in the "skill measured" tab.. is all that can be achieved by learning through the sql 2k5 express edition or with...
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
March 2, 2010 at 2:12 am
Hi Sri;
From the EmpID = 1 it tells that the startdate is the min of all and the enddate us the max of all, is that it?
just inner join that...
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
February 18, 2010 at 9:30 pm
Hi;
From the query what you have posted, the SQL is doing a great job in fetching the data to this level. If you look in to the data what the...
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
February 17, 2010 at 11:52 pm
Hi If you want the output in the pivot format itself in the database, then its kinda difficult... but if you can create pivot report in the Excel then populating...
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
February 17, 2010 at 11:11 pm
Hi
Not any much of help... but the below link, is on the same wave.
http://qa.sqlservercentral.com/Forums/Topic866779-392-1.aspx
and in between
the example was given to me by "Dave Ballantyne" might help you......
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
February 17, 2010 at 6:54 am
Hi
Actually the script is a SQL batch, i execute it and copy the output to the Excel and create pivot table.
But if you convert this batch to SP, then you...
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
February 17, 2010 at 6:38 am
The front-end is a 3rd party app basically used for logging incidents and a lot more, and it has its own database in 2k5. I don't think SSRS is installed...
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
February 17, 2010 at 4:01 am
Sorry Dave, just to make it clear to myself....
from the link you mentioned, (currently I am focusing on the first example), there he has shown the month in vertical manner...
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
February 17, 2010 at 3:17 am
Hi, the attached excel file is the format, hope that can be achieved by using pivot in sql2k8 and below sql script fills the table variable with dates, which only...
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
February 17, 2010 at 2:48 am
Hi, thanks for the reply
I have seen that.... not much help from that. I am not sure how you take time out of the date and create a pivot and...
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
February 17, 2010 at 12:22 am
Viewing 11 posts - 541 through 551 (of 551 total)