MSSQLTips

Hi. I need some tips on how to display the records in a report according to the below format in the SQL Server Reporting Services: Ex: If the query returns the following records: Complaint# Complaint_Type License# License_Type 2005BNC09 Violation XV12345 law 2005BNC09 Violation HJK1239 law 2005BNC09...

I am facing a problem in MSSQL: - I have a table in MSSQL, which has 10 rows & 5 columns. In this table I am maintaining a numeric range in 2 columns. First one has starting number & second column has end number. All rows have unique values in these 2 columns. For Ex.: - In first row the value...

How to write stored procedures in SQL Server? Please Send the Description with examples of stored procedures. How many types of stored procedures are there in SQL Server for INSERT,UPDATE,DELETE? How to call procedures?

Hi, I’m looking for a table ore stored procedure which gives me al the information about the Maintenance Plans on a SQL Server. For example Backup Folder, witch databases are selected and so. I did find a quite a lot store Procedures and some views whit information about Maintenance Plans and Jobs, bud...

Hi, Urgent,Urgent Can you tell me that how to remove the Dos printing using SSRS If some one can help me about it ple tell me the solucation on following email address ajaykumarrp@hotmail.com ajaykumarrp@yahoo.com Waiting for a valuable Response Ajaykumar

what is the diffrence in DBMS and RDBMS?

Good day all. I have about 25 SQL boxes that are 2000 and 2005. I have all the maintenance plans running successfully nightly now. What I would like to accomplish is to have all the history reports go to one location and email a report on the failed jobs. SQL 2005 doesn't have the option to add a...