You can overwrite an existing differential backup.  Restoring a database using a combination of Full, differential, and transaction log backups is a viable solution.  You only need the most current...

Currently you can't debug a stored procedure using SSMS.  At this time you have to have Visual Studio Professional or better to accomplish this very useful feat.  Personally, if you...

Not disputing that using the order by in a view defined with a select top 100 percent doesn't work in SQL Server 2005.  I am simply stating that it isn't...

Hemant,

Not having your table layouts or test data makes it a little hard to help you with your problem, however, based on your posts I have tried to come up...

And ultimately it is the application that dictates what needs to be done.  If a calendar table is not required, why build it.  No where in the posts is there...

I have the same issue.  All you can do at this time is keep the SQL 2000 client tools available for thos times you need to modify the UDF's you...

Why not just add the case statement to you select statement?

select

    a.SomeDate, -- a date field

    case

        when (datepart(dw, a.SomeDate) in (1,7)) then 'Discount'

        when '2002-01-01' + ' ' +...

If you are selecting less than 100 percent of the records returned in the select, the order by in a view works.  SQL 2005 ignores (as it is written in...

Windows 98 doesn't support the service architecture even though you can use the personal edition of SQL on Windows 98.

I would suggest looking at upgrading to at least Windows 2000...

Try this query:

SELECT

    tblSOP_Type.Id,

    tblSOPS.tblEquipment_id,

    tblSOPS.tblSOPType_id

FROM

    tblSOP_Type

    LEFT OUTER JOIN tblSOPS

        ON (tblSOPS.tblSOPType_id = tblSOP_Type.id

            tblEquipment_ID = 1)

hth!

Hemant,

I was looking at your code and to me it is somewhat confusing.

Your original query contains 2 derived tables, both based on the same table dbo.tblCustomerAddress.

Both queries also restrict the...

Try this query in your production environment:

select

    *

from

    dbo.TD_TASK_STEP a

where

    exists (    select

                    1

                from

                    dbo.TD_TASK_STEP b

                where

                    b.in_StepID <> a.in_StepID

                    and b.in_TaskID = a.in_TaskID)

hth

True enough on personal taste.  I find it easier partly due to how I also use tabs (converted to spaces) to indent code.  I am partially anal when it comes...

You can also try this:

select

    t.ticket_id,

    t.created_date

from

    TICKET t

where

    exists (    select

                    1

                from

                    AUDIT a

                where

                    a.ticket_id = t.ticket_id

                    and a.status in ('PENDING','UNACCEPTED')

                    and a.last_updated_date = ( select

                                                    max(b.last_updated_date)

                                               ...

Karma,

You may be right on the set statement in the case expression, but that is the only change I'd make.

Thanks,

Lynn