Hi

Try installing latest SP2 available on the net. Initial version of SP2 is having lot of problem related to sql jobs. New SP2 will patch all the issues.

Amit

ELSE

u can use only select statement:

Select distinct property_id,sellprice,bedrooms,sub_loc_name,cat_id,landlord_id

INTO #TempTable From [mktest].[dbo].[Table]

Select * from dbo.#TempTable

Drop Table dbo.#TempTable

Amit

Hi

The error is: First you are creating #TempTable with Create Table statement, then again you are calling one select statement to create #TempTable.

If u want to insert data in #TempTable...

Perfect. Great man.

Thanks. Take care

Hi

Works fine but i need the same in a single query as what u did for 2K5. If it can be done like that, will be highly appreciable. Actually i...

'O' sorry. Normally i worked in SQL 2005 so wrongly i put in the 2K5 forum. For this query, i need for SQL 2000.

I need two row order by company name. Your last...

Hi, I'm using SQL 2000. I want any two row for each Primary key.

Thanks for your effort.

Hi

By default SQL do not detect network location. U can use below command to restore DB from the network location:

DBCC TRACEON (1807)

RESTORE DATABASE MyDb

FROM Disk = '\\server\f\SQL Backup\ABCD.bak'

WITH RECOVERY,REPLACE,

MOVE 'Test_Data'...

Hi

For your purpose, ISNULL & NULLIF is enough. If you want to use function like IIF(x,y,z) in SQL, you can use (CASE WHEN ..... THEN ..... END). See BOL for this.

Amit

Hi

Plz check the result set. Its not like that. It should arrange numeric part first and then character part. e.g. 10,20,45,100,200,abc

Row_number() is not a SQL function. Plz check it again.

Amit

Hi

Got the solution. The SQL service should be started with the domain account or specified account. Assign permission to the network location. It's working fine now.

Amit

Mohammed is right. Also, check with the free disk space. The free disk space ratio should match with DB size. For all the big transactions, free space is required for...

Excellent. It works. I've customized it according to my requirement. Thanks a lot.

Amit

Hi

Use a query option when u select table name for import the data. Write your own query to mention conditions.

Amit

Hi

You need to change MSSQLSERVER Agent service logon in windows control panel. Instead of default user, mention domain or workgroup user and password and then re-start agent service.

Amit