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...

I got the solution for this guys.. 😉 😀

Thanks

Ram

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...

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...

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

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)

...

hi..

You can use PIVOT for this need..

Just try that.. if not i ll post an example for you..

you please send the whole Query which you got tried to execute..

Ram

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...

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...

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...

Hi Rose..

You try this...

select distinct * from (

SELECT mid(reg_year,3,2)

FROM tbl_dept) a;

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...

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...

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...