Forum Replies Created

Viewing 15 posts - 1 through 15 (of 21 total)

  • RE: Not seeing all databases in Maintenance Plan Wizard

    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

  • RE: #Temp Table

    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

  • RE: #Temp Table

    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...

  • RE: TSQL - Inner Join

    Perfect. Great man.

    Thanks. Take care

  • RE: TSQL - Inner Join

    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...

  • RE: TSQL - Inner Join

    '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...

  • RE: TSQL - Inner Join

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

    Thanks for your effort.

  • RE: Restore db from network location

    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'...

  • RE: How to divide two numbers when one has zero values

    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

  • RE: Alpha Numeric Sort Order

    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

  • RE: SQL Backup at Network Location

    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

  • RE: Transaction Log Full in Simple Recovery Model

    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...

  • RE: T-SQL for Generating Index script

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

    Amit

  • RE: DTS - IMPORTING DATA FROM VFP DATABASE TO SQL

    Hi

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

    Amit

  • RE: SQL Agent Uses Default User profile

    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

Viewing 15 posts - 1 through 15 (of 21 total)