Hi Niall,

   R u looking for the sql query with case else end clause?

Nivedita

I am able to. I tried joing the sql server to the webserver domain as well. Still it is not connecting to sql server.

Nivedita

Hi Sivaprasad,

   Thanks for your prompt reply.

   I tried these options but I am not able to connect. I am in total mess now. Please help me out

Thank you

Nivedita Thomas

Hi,

  Please check the sql statement given below.

SELECT table1.field1, table1.field1, table2.field2

FROM table1 , table2 

WHERE table1.field1 *= table2.field1

AND table2.field2 = (case when table2.field2 is null then null else 2004 end)

Hope this helps.

Nivedita...

Hi Jeff,

What is the error the you are getting? I have never encountered such a scenario. Ofcourse using xml will reduce the performance when the hit rate is very high.

Nivedita...

Hi,

 Do u mean sp_MShasdbaccess? I doubt there is any system sp named sp_MSdbuseraccess. Can u pls tell me which version of SQL you are using?

Nivedita Sundar.N

Hi Florenzano,

   You can disable the logshipping job by disabling the job entry in the primary server.

Hope this answers ur query.

Nivedita Sundar.N

Hi David,

  Do you really need all these headaches? The query given below will give you desired output if you replace getdate() function with the date you want.

Hi,

Try the code given below.

DECLARE @filterCriteria varchar

DECLARE @filterCMD varchar

declare @sql1 nvarchar(200)

set @filterCriteria = 'w'

IF @filterCriteria LIKE 'W'

set @filterCMD=' DESCRIP LIKE ''%closed%'' or DESCRIP LIKE ''%deny%'' or DESCRIP like ''%withdrawn%''...

Hi Ravi,

The truncate option wont work for columns with dependencies. The DBCC CHECKIDENT will work.

Nivedita Sundar.N

Hello,

Hope this is the solution that u r looking for

SELECT DISTINCT SO.name

FROM  sysobjects SO

JOIN  syscomments SC

ON  SO.id = SC.id

WHERE  SC.text LIKE '%SHIPPING_TOTAL%' and so.xtype='P'

ORDER BY SO.name

Nivedita Sundar.N

Hi Ravi,

  You can change the seed value of identity column by using the statement

DBCC CHECKIDENT ('table_name', RESEED, new_reseed_value)

By using the truncate command the identity column is reset to...

Dear Mr.Raj,

The below solution is not the best solution available. But it certainly produces the desired results when the max source values for each item is 4.

insert into destination_table(item, source1,...

U can automate the backup using the maintenance plan wizard in which u can schedule at what interval a backup has to be taken. The backup files wont be overwritten or replaced....

Will this work?

SELECT     MTFOptionID,  MTFOption,

                          (SELECT     b. MTFOption

                            FROM          table1 b

                            WHERE      b.MTFOptionID = a.MTFOptionID +

                                                       ((SELECT     MAX(MTFOptionID)

                                                           FROM         table1) / 2)) AS fld4

FROM         dbo.Table1 a

WHERE     (MTFOptionID <=

                          (SELECT     MAX(MTFOptionID)

                           ...