Hi,

Thanks for your tip 🙂

I will take into consideration what you suggested.

Thanks a lot,

Oana.

Hi there,

Maybe this is what you are looking for:

/*****************************************************************************************************************************************

* Purpose This procedure deletes all records from all tables in the specified database

* ...

Hey,

I don't know how to fix that problem 🙁

I am very curios also.. maybe someone will figure it out 😉

Regards,

Oana.

Hi there,

Maybe this link will help:

http://www.mssqltips.com/tip.asp?tip=1206

Kind regards,

Oana Schuster.

Hi Kavita,

select '$' + convert(varchar,(convert(money,1234567.666666)),1)

and the result is: $1,234,567.67

That's all i could came up with till now.

Maybe it will help.

Kind regards,

Oana Schuster

Hi there,

I think that using the COUNT function is not very good .. because it will not return the sum of the values, it will only count the number of...

Hi there,

you can create 2 scalar functions which calculate separately the sum of positive values and the sum of negative values:

First function dbo.Function1 will return this:

SELECT @sumPositive = sum(value) FROM...

Hi Ellis,

Thank you very much for your quick reply.

Regards,

Oana.

Hi,

SELECT

AD_NAME,

AD_Image AS AD_HH_IMAGE

FROM

TBL_AD_MASTER

INNER JOIN

(

SELECT

ADM.AD_NAME

FROM

TBL_AD_MASTER AS ADM

INNER JOIN

TBL_WORK_ORDER_DETAIL AS WODTL ON WODTL.Ad_Key=ADM.Ad_Key

INNER JOIN

TBL_WORK_ORDER_HEADER AS WOHDR ON WOHDR.WO_Hdr_Key=WODTL.WO_Hdr_Key

WHERE

WODTL.TASK_SURR_KEY =1

...

Hi,

If I add that part the script is taking forever to run 🙁 from 2 seconds without it ... to 50 seconds ...

:crying:

Regards,

Oana.

Thanks for your replies.

Regards,

Oana.

I see ...

But then why the Modify option is enabled in SQL Server 2005? Is there a reason?

Regards,

Oana.

Hi,

I hope this is what you are looking for:

CASE

WHEN PlannedDR5Duration = 0 THEN [ActualDR5Date]

WHEN PlannedRFSDuration = 0 THEN [ActualRFSDate]

WHEN PlannedRFADuration = 0 THEN [ActualRFADate]

WHEN PlanneDR4Duration = 0 THEN [ActualDR4Date]

WHEN...

Hi,

As far as i know you cannot have the IDENTITY property on a columns which is UNIQUEIDENTIFIER and also PRIMARY KEY.

when inserting the data into the table , first declare...

Hi,

I have a question : the @return_value parameter is it an OUTPUT parameter ? and what data type does it have?

When passing the value for the @app_id paramter you have...