pwalter83 (10/16/2012)

---

I have a requirement to create a CASE statement for the following condition:

SUM of NCV_BL.TEU where NCV_BL.POL_LOCATION_CD or NCV_BL.POD_LOCATION_CD is not present in MG_VSLVOY_SCHEDULE.PORT_CD for the SAISAN_VESSEL_CD, SAISAN_VOYAGE_CD and...

In the Expression editor, under the Common Functions in the Category window look at the Date & Time functions. Use the DateAdd() function.

=DateAdd("d", 15, Fields!payment_date)

HTH,

Rob

Could you do something like:

;WITH CTE_Numerator (DivisionGroup, NumCnt) AS

(

SELECT IR.DivisionGroup, COUNT(PatientKey)as Count

FROM [Quality].[dbo].[InpatientReadmissions] IR

WHERE (IR.ReAdmission30Days = '1')

AND (IR.DischargeDateTime >'2011-10-01' and IR.DischargeDateTime<'2012-08-01')

AND (IR.PlannedReadmission = '0')

...

Jon-538504 (10/13/2012)

---

Is SQL Server 2005 still supported? I was trying to install SQL Server 2005 Express and SP3 on a Windows Server 2008, however, there seems to be issues...

Kasinathan (10/13/2012)

---

AutoidEmpidTimeIn ...

COALESCE merely returns back the first non-Null item...

bpowers (10/12/2012)

---

I am creating a manufacturing report that will allow users to run it by part number, range of part numbers, or all part numbers. However, I am running into...

You'll need to install the PowerPivot add-in into your Excel.

http://www.microsoft.com/en-us/bi/powerpivot.aspx

Rob

yogi123 (10/12/2012)

---

Hi,

I have a requirement delete some old records and reindex the single table,how can we reindex a table?

If we delete some records from table,is it necessary to reindex the...

lmd999 (10/11/2012)

---

Hope someone here can help me out. I am new to Report Builder and Expressions.

I was able to calculate the percentage of the correct questions answered for each...

ByronOne (10/12/2012)

---

Hi everyone

I have a table in sql called dbo.Contracts that contains a number of columns but in respect to this query the following: LicenceNumber, StartDate, EndDate, LengthWeeks

I have recently...

robm1391 (10/11/2012)

---

Is there a way to run a SQl statement to auto RE RUN if the results are greater than 0?

Essentially it is checking to see if employees are all...

Looks like homework, but tell us what approach you've taken. What didn't work? What have you tried? How far are you?

Rob

bhushan_juare (10/11/2012)

---

[font="Times New Roman"]

I am in dilema for selection of a BI Reporting Tool. After spending few hours I just came to knew there are following open source BI Tools...

See if this works for your situation: http://weblogs.sqlteam.com/joew/archive/2008/11/12/60755.aspx

HTH,

Rob