Viewing 15 posts - 316 through 330 (of 761 total)
anthony.green (6/11/2012)
Second please follow the second link in my signature on how to post code and data for...
June 11, 2012 at 4:53 am
Koen Verbeeck (6/11/2012)
If you find out the requirement, would you please post it here?I'm very very curious why one would want to do such a thing.
Sure thing Koen. 🙂
June 11, 2012 at 12:50 am
I haven't been told about the requirement yet. A Senior DBA just called me and asked me if there is a way. Asked me to figure out how to do...
June 11, 2012 at 12:46 am
Koen Verbeeck (6/11/2012)
It's a wizard. By defination a graphical user interface designed to guide a user through a certain process.Why would you ever want to call that from a trigger?
Thanks...
June 11, 2012 at 12:44 am
I can understand that you need a JOIN.
But the rest of the parts are not very clear.
You need to give us a little more sample data for all the three...
June 10, 2012 at 11:19 pm
ananda.murugesan (6/10/2012)
Hi,Total 3000 Records, executing query 2300 records only display, please tell me what could be reason?
thanks
ananda
Because Sql Server, after compiling your query, doesn't think that the rest of...
June 10, 2012 at 11:09 pm
You can use any of the following variations. The Dynamic Pivot would be my pick.
--Creating Tables
Create Table Ex
(DeptNo int,
DNAME varchar(20) )
--Inserting Sample Data
Insert Into Ex
Select 10,'ACCOUNTING'
Union ALL
Select 20,'RESEARCH'
Union ALL
Select...
June 10, 2012 at 11:00 pm
You could use unpivot in this case as follows:
--Creating Tables
Create Table A
(NAME varchar(3),
[201202] int,
[201203] int,
[201204] int )
Create Table B
(NAME varchar(3),
[201202] int,
[201203] int,
...
June 8, 2012 at 11:16 pm
You need to do some reading and I think you are smart enough to work the difference out at the end. These links will help you:
June 8, 2012 at 6:48 am
manzilkolur23 (6/7/2012)
Had done the same way but did not use "partition by" so was not able to get the exact output
Thanks for the reply... It helped me and solved it...
June 7, 2012 at 5:16 am
I got the same error yesterday while I was performing an insert on some table. Then I remembered that I had changed the Date Format From 'ymd' To 'mdy'.
So, I...
June 6, 2012 at 11:16 pm
What is the Error Generated When You Compile the Procedure??....Please post the DDL of all the atbles and some sample data from them.
June 6, 2012 at 11:02 pm
you're Welcome.:-)
June 6, 2012 at 10:45 pm
okbangas (6/6/2012)
vinu512 (6/6/2012)
You can do it like this:
Select a.year, a.week, SUM(a.total_savings) From
(Select * From Ex
union
Select * From Ex1) As a
Group By a.year, a.week
If so, you have to use union all,...
June 6, 2012 at 10:42 pm
Please post some sample data for the table.
June 6, 2012 at 5:21 am
Viewing 15 posts - 316 through 330 (of 761 total)