I see you're using the templates.  Note that they are just samples, and there's plenty of room for you to modify them for your needs.  This stored procedure template sets...

Red Gate's SQL Data Compare can reduce that pain:

http://www.red-gate.com/products/SQL_Data_Compare/index.htm

(If you buy, tell them an MCT sent you )

As for any aspiring developers reading...

SQL Server has no hand in the management of connection pooling.

Connection pooling is similar to a bank of phones used by a research department.  One guy calls the library (dials...

This sounds like a homework problem.

What have you tried?

I'm guessing you're running this in Query Analyzer.

Your actual output is the full length, but QA is cutting it off.  From the menu, choose Tools -> Options and look for...

> then do I still need two SQL Server licences or just the one as I'm not going to need SQL Server installed on the box in the DMZ?

http://www.microsoft.com/sql/howtobuy/default.mspx

There's...

> is this the right way to implement the reporting services ?

Blocking anonymous access is the correct part, yes.

Remember there are three steps to running reports from an application:

1. ...

UNPIVOT is the key, here:

DECLARE @test table(id int, math int, bio  

Place parentheses around @n:

SELECT TOP (@n) notrans, NOTARJETA, NOCLIENTE

-Eddie

Robert:  the [1] is required, the Pragmatics would call it RTFM.

The xquery.value() function requires a singleton result.  Even though, in this case, leaving...

Japanese time does not have AM and PM; it's a 24-hour clock. 

Instead of 5:27pm, use 17:27.

12:00 am = 0:00

6:00 am = 6:00

12:00 pm = 12:00

6:00 pm = 18:00

-Eddie

For the second question, the CONVERT function can format dates.  See BOL for all the different options.

To format a date as yyyy/mm/dd, use CONVERT(char(10), DateToFormat, 111)

http://www.microsoft.com/sql/howtobuy/default.mspx

I posted some more info here:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=276890#bm277331

The client may be installed on anywhere that is licensed to access SQL Server, either because:

1. the SQL Server was licensed with the per-processor...

If you are properly versioning scripts (each object as a script file), then those scripts should be built using IF EXISTS...DROP / CREATE.

The object must be CREATEd before it can...

Here's something to consider:  Order the EntityAddress table by the order of the classification IDs you wish to check (ID = 2 first, ID = 4 second, etc.) and pull the TOP...