Rock,

Ok, the problem is because the CAST function changes the format of the date from "01/01/2001" to "1 JAN 2001". Then when you try and use the value in...

Hi Rock,

CHAR(10) explanation

The CHAR(10) in the dynamic SQL is a carriage return. This creates a new line in the dynamic code so that when you print it, it is...

Hi,

Two steps required.

Firstly...

You need to cast the fromdate and todate parameters as varchar, using CAST(X AS VARCHAR) function. Reason being, when building dynamic code you are building up...

Hi,

I have a seperate database for all my "utility" scripts, stored as procedures.

I seperate the funtionality of each script with schemas.

It's good because you can automate the backups which are...

Use this for free for 14 days.... saves a whole lot of hassel

http://www.red-gate.com/products/SQL_Backup/index_v2.htm

Hi,

You could just add a WHERE condition to say:

WHERE country != 'null'

I've noticed that you are storing the null value as text, i.e. 'null'.

If you stored the null...

NP,

If you find that you need to use it again once the 14 day trial expires then you can type 'i need more time' in the text box which...

Hi,

I've seen this before, try the CINT() function.

Not 100% sure what the reason for it not working was now but I believe it's because Round function is not a valid...

Hi,

Can you give a llittle more info on exactly what it is you need a loop for?

For the time being have a look at the following article (SQL Server 2005,...

With regards to not having any test data, you can download this software for free for 14 days.... I used it recently and it works a treat...

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

Hi,

I've used triggers to perform this type of task.

Performance has not really been an issue in my case.

I guess you need to estimate how often you expect the...

Better solution, without cursors or temp tables

select distinct

...