so if any of the string is '' then I do not want semicolon for it the problem im facing , will this be resolved ?

thanks

DJ

New in the sense for Date related stuff never worked with DATES in SQL much no worries i fgured out the solution.

thanks

Dhananjay

one more help- I just started as a SQL Server 2008 /SSRS report programmer, wanted help to define next steps in this field to grow and learn, any tips welcome...

Thanks for the help on this jonysuise .

You are a genius 🙂

it is working as desired now.

no worries I figured it out BTW I come from Java world and always teach and preach also that's why I'm successful 🙂 I did not ask you to...

Hi John,

I was confused between CAST and CONVERT which one to use finally I ended up using CAST.

If you can explain in simple words the difference to me would be...

Thanks so much it worked.

Dear friends,

I wrote a query to get the last approver as below- will this help me to get the lastapprover in the chain before a null:

---

SELECT [Requisition NO] ...

Hi Erland,

this is giving me error:

-------

Msg 8117, Level 16, State 1, Line 11

Operand data type nvarchar is invalid for subtract operator.

--------

since I see that the 2 fields "Monthly Revenue,...

basically I get requests in an excel with the fields that go on the report- as of todate I amnually create a Transpose of those fields in excel then use...

thanks all for this awesome help the code worked for me

So Gail this code should work to get me Orders Before June 3rd - 12.00 AM Midnight-

[WorkForce_JobPosting].[Job Posting Create Date_JP] < '2013-06-03'

correct?

Hi Gail

Midnight 12.00 AM not Mid Noon since Noon is 12.00 PM

thanks

Dhanajay

Dear Gail,

I want it before 12.00 AM GMT on June 3rd.

so can I use - [WorkForce_JobPosting].[Job Posting Create Date_JP] < '2013-06-03'? or if not what do you suggest please?

thanks

Dhananjay

Dear Gail,

I want it before 12.00 AM GMT on June 3rd.

so can I use - [WorkForce_JobPosting].[Job Posting Create Date_JP] < '2013-06-03'? or if not what do you suggest please?

thanks

Dhananjay