Try this one... select productname,sum(issueqty) QTY from issuance where issuedate >= '5/1/2010' and issuedate <= '5/31/2010' and productid in ('777' ,'778') group by productname order by productname

That's what i am doing dear! See the BACKUP DATABASE [Outbound_Vodafone] TO DISK = N'\\dataserver\Database\Outbound_VodafoneDifferential_9PM.bak' WITH DIFFERENTIAL , INIT but it's not working.

still not get any appropriate answer.. Kindly add some more solutions.

Please understand i want to take backup's on some other server, not on the local.

I am using SQL server2005!!

Hi All, This is the code i am running.. BACKUP DATABASE [Outbound_Vodafone] TO DISK = N'\\dataserver\Database\Outbound_VodafoneDifferential_9PM.bak' WITH DIFFERENTIAL , INIT This path is already shared to my domain user login. But I am getting this exception.. Msg 3201, Level 16, State 1, Line 1 Cannot open backup device '\\dataserver\Database\Outbound_VodafoneDifferential_9PM.bak'. Operating system error 5(Access is denied.). Msg 3013, Level 16, State 1, Line 1 BACKUP DATABASE is terminating abnormally. Please help!! Regards, Amandeep Singh

Hi, I would like to implement Stored procedure naming conventions on my databases? I don't want to mess up with developers for this. Is there any way with which my server automatically check whether the request coming for creation of stored procedure following naming conventions or not?? and if not then it pass error message to developer. Regards, Aman

Hi All, The project in which i am working needs to be multilingual. I need to insert and retrieve data in these languages : 1. Tamil 2. Telugu. 3. Malyalam. 4. Oriya. 5. Kannada. Actually we don't know which font to use for which language. Do I need to install fonts on the server or is there any patch need to install?? Please help me out of this!! Thx & Rgds Aman

Hi There, I have Configured my reporting server to integrate with sharepoint services using reporting services configuration Manager. now i want to publish my reporting server reports in sharepoint environment. Please help me out !!! Please let me know how to publish reporting serivces reports in sharepoint.!! thanks in advance ~Aman

hi , I am sending a mail using SQL server 2005 msdb.dbo.sp_send_dbmail , below written is my code:- I need to change the color of the data . depending upon the value , i want to change it's color. Kindly help me out. DECLARE @tableHTML NVARCHAR(MAX) ; SET @tableHTML = N'<H1>Cummalative Airtel Report generated every half hour</H1>' + N'<table width="100%" style="font-family:Arial; font-size:12px; color:#000066" border="1" cellspacing="0" cellpadding="0">' + N'<tr><td width="20%"><b>Circle</b></td><td width="11%"><b>OfferedCalls</b></td>' + N'<td width="11%"><b>AnsweredCalls</b></td><td width="11%"><b>AbandonedCalls</b></td>' + N'<td width="11%"><b>PCA</b></td><td width="11%"><b>ATT</b></td>' + N'<td width="11%"><b>FCR</b></td>' + N'<td width="11%"><b>CQ</b></td>' + N'</tr>' + CAST ( (Select td =t.circle, '' ,td = t.offd, '' ,td =t.answ, '' ,td =t.abnd, '' , --td =Convert(char,Round(t.[%abnd],2)), -- '' , td =Convert(char,Round(t.pca,2)), '' , td =Convert(char,round(tt.SumAtt/Answ,2)), '' ,--td =ttt.[login], '' , td =Convert(char,Round(ttttt.[CQScore],2)),'', td=Convert(char,Round(fcr.[fcr],2)) from FOR XML PATH('tr'), TYPE ) AS NVARCHAR(MAX) ) + N'</table>' ; EXEC msdb.dbo.sp_send_dbmail @profile_name='MailProfile', @recipients='abc@gmail.com', @subject = 'TestReport', @body = @tableHTML, @body_format = 'HTML' ; Regards, Aman

Hi, I have installed a SQL Server Express 2005 instance with default name SQLExpress on a machine running Windows 2003 Server. I have two databases on this instance with size 2GB and 1 GB(approximately) on this insance. These databases are accessed by a(Web based) .Net Application which is used by a maximum of 50 concurrent users.The application is a CRM for ticketing with Reports on the data punched by users. My problem is that some times the SQL Server Express stops giving any connections. If I go and check the Database Engine service status in SQL Server Surface Area Configuration tool it shows the serive as running. As a hack I stop the service and start it again and SQL Server starts givgig connections again. I have similar setup running in another location and that never gives such kind of problem. Please help me with this problem as any downtime on Database is questioned from us. thanks & regards, Aman

Use TCP/IP Provider instead of named pipes. Regards, Aman

Hi All, I am new to reporting services in SQL Server 2005. I have been able to create a report using Microsoft's SQL Server Bussiness Intelligent Development IDE. The problem is when I access the report from a web browser it asks me for Reposting server's username and password. I want to share these reports across my LAN creating limited users who can just view the reports and do nothing else. Please suggest how to go about it. Further more in my IIS when I go and browse the Report$Machinename it sometime does not load properly with all the components it should show. It behave correctly only randomly. Regards, Sandeep

Can any one tell me where the SSIS package saved in SQL server2005 Standard edition.??? I made one import package , but i don't know where it is saved in SQL2005. Thanks in Advance. Aman

go for password protected option.

Is this himanshu kashyap from amritsar??

SQL server 2005 Express edition tool kit.

Download SQL express 2005 tool kit from Microsoft.com and attach it with your running version as a external tools. regards, Aman

I am getting this error Msg 1084, Level 15, State 1, Procedure LOGIN_IP_RESTRICTION, Line 2 'LOGON' is an invalid event type. while executing under code:- CREATE TRIGGER [LOGIN_IP_RESTRICTION] ON ALL SERVER FOR LOGON AS BEGIN DECLARE @host NVARCHAR(255); SET @host = EVENTDATA().value('(/EVENT_INSTANCE/ClientHost)[1]', 'nvarchar(max)'); IF(EXISTS(SELECT * FROM master.dbo.IP_RESTRICTION WHERE UserName = SYSTEM_USER)) BEGIN IF(NOT EXISTS(SELECT * FROM master.dbo.IP_RESTRICTION WHERE UserName = SYSTEM_USER AND ValidIP = @host)) BEGIN ROLLBACK; END END END; i am running it on mAster database and i am using SQL server 2005 standard edition. thanks in advance Aman

WHEN I RAN INDEXDEFFRAG.. THEN WHAT THIS RESULT MEANS??? PAGE SCANNED PAGE MOVED 245 0