Are you referring to an SSRS report or do you need help to write a query that can filter rows between two dates?

agreed.

I would recommend 'developer edition'.

But I agree that there are a number of other factors that might affect this decision like number of licenses, price etc.

Most of times, you can replace a cursor/row-by-row processing with batch processing. Depending on the output you are expecting, and the structure of the source data, the apporach/code may be...

In this example, there may not be any performance differences. But if the query contains a number of other joins too, there will be differences.

JOIN clause is evaluated before WHERE...

You can download the books online from the location given below:

http://www.microsoft.com/downloads/details.aspx?familyid=a6f79cb1-a420-445f-8a4b-bd77a7da194b&displaylang=en

In SQL Server, the results of one or more integers is always an integer. SQL Server returns a value as a datatype having the highest prcedence among the data types...

May be it is a good idea to wait till we hear from John about his requirements. If he expects salaries to go down, lets write a query that handles...

if an insert operation inserts more than one row, the INSERT trigger will be fired only once. Your code inside the trigger should be written such that it can handle...

I agree. I had this in mind.

I see that most of the times the solutions given in the forums are not consumed entirely in its original form. People take...

Glad to know it helped 🙂

Franco,

This article shows an example using FOR XML path.

http://www.sqlserverandxml.com/2008/08/how-to-generate-delimited-string-using.html

does it help?

SET NOCOUNT ON;

DECLARE @t TABLE (st_no INT, year INT, month INT, sal MONEY)

INSERT INTO @t (st_no, year, month, sal) SELECT 1,2008,1,1000

INSERT INTO @t (st_no, year, month, sal) SELECT...

I think you can go ahead with what you suggested as long as all the procedures follow the same convention. We used to name report stored procedures with "RPT" (RPT_CustomerList)...

Could you explain what you are trying to achieve?

You could create a TRIGGER on the table and SQL Server will execute the trigger when data is modified (insert/update/delete). Add your...