And the error message also please...?

In Enterprise Manager, expand the relevant server and get to the appropriate login under the Security folder. Right-click on the login and get the properties. Under the General tab select...

As far as I know you cannot create any system stored procedures in SQL Server, though you can create your own stored procedures and name them with a 'sp_' prefix....

It should, shouldn't it, if you just modify it a little to:

UPDATE Emp

SET [Level] = REPLACE(SPACE([Star])),' ','*')

Well, you could use some sort of looping using cursors or CLR functions made using C# or so, but I do not see any advantage in not using REPLICATE.

Hi,

Would you be able to submit the error message in full?

Regards

Hi, you could use the REPLICATE function.

E.g.:

UPDATE [Emp]

SET [Stars] = REPLICATE('*', [Level])

Regards

Try these steps out:

1. Create a temporary table, with the following fields: Employee_No, Date and Shift.

2. Add the Employee_No, StartDate and Shift from the Holiday table, as a record into...

You could try using the DTS Import/Export Wizard in SQL Server 2000, which would be the easiest way to transfer the data from your table to the Excel file

http://www.sqlservercentral.com/Forums/Topic435101-149-1.aspx?Update=1

Yes, you could do this, by using the PIVOT statement. For syntax and usage of this keyword refer Books Online.

Cheers.

Hi,

You could also use the Slowly Changing Dimension task for this purpose.

Cheers

Yeah, I too feel that the second options is better.

From the time I got into databases, it had always been SQL Server for me. And from the time I got into SQL Server, it had always been SQLServerCentral all...

Hi,

Could you be more specific about your question? You could certainly use the system variable System::MachineName. But I would need to know where (i.e. what task(s)) you need to pass...