i want to show sales details by daily basis and sum of Qty.

14,15 means Date like 14-03-2013,15-03-2013....etc.

sir , i want to use '0' instead of null.here i couldn't use isNull().why?

pls see the attachment image and query result.

GO

/****** Object: Table [dbo].[sales] Script Date: 02/07/2013 17:20:15 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[sales](

[salesid] [int] IDENTITY(1,1) NOT NULL,

[product_id] [int] NULL,

[Quanity] [int] NULL,

[HeadID] [int] NULL,

PRIMARY KEY...

while login,try with your old domain name as server name..it may help you

Here i got some kind of error..all columns filled with Null...why?.I couldn't find what..please help me sir,,,

/****** Object: Table [dbo].[paymentHistory] Script Date: 02/06/2013 13:56:10 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING...

Here i got some kind of error..all columns filled with Null...why?.I couldn't find what..please help me sir,,,

/****** Object: Table [dbo].[paymentHistory] Script Date: 02/06/2013 13:56:10 ******/

SET...

can i create dynamic headers....:-)

SELECT paymentID, [ASD], [BG],[SD]

FROM (SELECT paymentID,

CASE receivedType WHEN 'Dr'...

CREATE TABLE Payment

(

PaymentHistoryID INT,

paymentID INT,

Amount ...

thank you sir,,,i got result...i want to improve my knowledge in sql server..can you suggest me..

i am also finally got result by using sub query...whether it is wrong way

select...

send me ur stored procedure..then only i can vieww ur problems