-- To calculate myvar:

SELECT SUM(CASE OfferPriceUnit

...

If you use the GUI installer, you will be able to specify custom paths after the registration information page, on the page where the various components can be selected. Just...

Just a further note, do make sure that you reseed to the current max value in the table. Otherwise, if you do not have a unique constraint, you may easily...

DBCC CHECKIDENT ('dbo.mytable', RESEED, 1)

Regards,

Andras

put brackets around the name, like:

[Order Details]

Regards,

Andras

This is posted and hopefully answered on http://www.sqlservercentral.com/Forums/Topic416002-145-1.aspx.

Andras

On the above page in the top right corner click on "All Releases", and then on the next page in the same location click on "SQL Server 2005 SP2a"

A direct...

Is this what you have in mind:

DECLARE @table1 TABLE (

category nvarchar(50),

startdatedatetime,

enddatedatetime

...

http://support.microsoft.com/default.aspx?scid=kb%3ben-us%3b305977&Product=sql2k also contrasts the advantages/disadvantages of table variables and temp tables.

Regards,

Andras

Date is stored on pages, each page has an id. The pageid also contains the file id (you can map these based on the query I've sent you). So once...

Fulltext search is what you are looking for. You can find more on http://technet.microsoft.com/library/ms142545.aspx

Regards,

Andras

If you do not need this on a per row group basis (so you do not need to use "group by"), for one group you can use coalesce, and self-updating...

I do not think anything else is available in SQL Server; triggers, while they should not be overused, are however exactly for this purpose. But maybe it is worth to...

Have a look at http://www.sqlservercentral.com/Forums/Topic391111-338-1.aspx

You can find here answers in forms of a user defined function (good for 2000), or a nice trick with xml path for 2005.

Regards,

Andras

Have a look at triggers:

http://msdn2.microsoft.com/en-us/library/ms189799.aspx

Regards,

Andras