Viewing 15 posts - 1 through 15 (of 22 total)
Hi,
Do u want the result set in the reports (SSRS)?
If yes, you can use the below query to bring the result and by placing the columns with appropriate groupings in...
Ramkumar . K
Senior Developer
######################
No Surrender... No Give Up....
######################
February 13, 2012 at 5:45 am
I got the solution for this guys.. 😉 😀
Thanks
Ram
Ramkumar . K
Senior Developer
######################
No Surrender... No Give Up....
######################
December 22, 2011 at 2:42 am
Hi williams..
I agree with u..
But whats my friend's requirement is to change the settings which attained by sql server 2005..
by default it is coming like
SET DATEFORMAT mdy;
select getdate()
Result:
2008-07-28 10:26:25.920
Can...
Ramkumar . K
Senior Developer
######################
No Surrender... No Give Up....
######################
July 27, 2008 at 10:59 pm
Hi Steve..
Can you suggest any link regarding the BOL..
Because i have no idea Regarding that.. If i get a bit i ll proceed the next..
Thanks in Advance...
Ramkumar . K
Senior Developer
######################
No Surrender... No Give Up....
######################
June 22, 2008 at 11:04 pm
Hi...
Just try the below..
Select Sum(OrderDetails.TotalPrice)
from OrderDetails ,orders
where OrderDetails.Mtype='M1' and OrderDetails.OrderID = Orders.OrderID Group BY OrderDetails.OrderID
Ramkumar . K
Senior Developer
######################
No Surrender... No Give Up....
######################
June 7, 2008 at 12:36 am
Hi..
Just try like below example..
This is working fine..
-- Suppress data loading messages
SET NOCOUNT ON
-- Create Sample Data using a Table Varable
DECLARE @OrderDetail TABLE
(orderid int,
productname varchar(30),
productqty int)
...
Ramkumar . K
Senior Developer
######################
No Surrender... No Give Up....
######################
June 7, 2008 at 12:23 am
hi..
You can use PIVOT for this need..
Just try that.. if not i ll post an example for you..
Ramkumar . K
Senior Developer
######################
No Surrender... No Give Up....
######################
June 7, 2008 at 12:19 am
you please send the whole Query which you got tried to execute..
Ram
Ramkumar . K
Senior Developer
######################
No Surrender... No Give Up....
######################
June 7, 2008 at 12:04 am
Hi Sarfaraj..
What u want as output from the order table???
If you want to get the Bill information as per menu wise means, then you can use group by to compute...
Ramkumar . K
Senior Developer
######################
No Surrender... No Give Up....
######################
June 6, 2008 at 11:59 pm
Hi All..
[Code]
declare @C varchar(8000)
set @C = N'hello'
[/Code]
In the above statement there is the "N" mentioned in the beginning of the string.. what does it mean exactly???
Is...
Ramkumar . K
Senior Developer
######################
No Surrender... No Give Up....
######################
May 27, 2008 at 12:03 am
Hi Rose..
I have given the sample code for your reference..
That is in Vb.net 2005..
Dim Con As New OleDbConnection(My.Settings.AccConStr)
Dim...
Ramkumar . K
Senior Developer
######################
No Surrender... No Give Up....
######################
May 12, 2008 at 8:32 am
Hi Rose..
You try this...
select distinct * from (
SELECT mid(reg_year,3,2)
FROM tbl_dept) a;
Ramkumar . K
Senior Developer
######################
No Surrender... No Give Up....
######################
May 11, 2008 at 10:17 pm
Hi bledu..
Here i suppose to export lacks of data.. Each table contains more than 80,000 records..
While i query and export the data into Excel it consumes more than 5 min...
Ramkumar . K
Senior Developer
######################
No Surrender... No Give Up....
######################
April 24, 2008 at 10:57 pm
hi..
I am trying to Back up a database in SQL Server 2005.
Back up Type : Full
Recovery Model : Simple
In the Backup taking wizard in sql server 2005, i chose options...
Ramkumar . K
Senior Developer
######################
No Surrender... No Give Up....
######################
April 21, 2008 at 10:38 pm
Hi..
While we are taking Full Backup on a DB, I hope the Log files also be got backed up. Then How it is possible to run a full back up...
Ramkumar . K
Senior Developer
######################
No Surrender... No Give Up....
######################
April 21, 2008 at 12:07 am
Viewing 15 posts - 1 through 15 (of 22 total)