Comments by _Kapil - CodeProject

_Kapil 5-Aug-15 3:13am View

thank you very much. ;)

_Kapil 5-Aug-15 3:02am View

Than i think its better to use LIKE.
no performance issue.
What u think?

_Kapil 5-Aug-15 2:59am View

Hey* Los.
There is another way except install.

_Kapil 5-Aug-15 2:58am View

Okay sorry my mistake....

_Kapil 5-Aug-15 2:57am View

sorry I m not getting you.
Thanks.

_Kapil 5-Aug-15 2:53am View

I am using table [Dispatch send message] and column name [Meassage].
Create a SQL query using function "contains" not working fine, generate message:
Cannot use a CONTAINS or FREETEXT predicate on table or indexed view 'table name' because it is not full-text indexed.
so what setting i have made to run this query.

_Kapil 20-Jan-15 2:47am View

double timeZoneOffset = (double)0;
#region To get either dept timezone in minutes
timeZoneOffset = StationRemoteController.GetDepartmentTimeZoneOffsetByDeptID(Convert.ToInt32(uad.Dep_id));
#endregion

DateTime localTime = DateTime.Now.ToUniversalTime().AddMinutes(timeZoneOffset);

and finally it saving into database.

_Kapil 20-Jan-15 2:13am View

Please give me syntax convert local time format in utc format or into 'z' or 'o' fomat

my question is?
it may be new setting for datetime in vs2013....

_Kapil 20-Jan-15 2:11am View

I am getting issues when running code on my system.

_Kapil 26-Sep-14 6:47am View

@BillWoodruff.........
You are right,I think we to talk with our client to provide us some format so that we can identify the address.

thanks for yours valuable time.

_Kapil 26-Sep-14 6:46am View

Deleted

@BillWoodruff.........
You are right,I think we to talk with our client to provide us some format so that we can identify the address.

thanks for yours valuable time.

_Kapil 26-Sep-14 5:24am View

Can you clarify me that there is any solution for the problem that, You have a message text with any format and you have to fatch address from this text message.

eg.
11:08 Thu 25/09/14 >NOTIFICATION MFS: *CFSRES INC0001 25/09/14 11:08 RESPOND RESCUE ANIMAL P2 9/4 MERLOT CT WYNN VALE MAP:ADL 84 H 1,CALLER:JACKIE KNOX 0439300697 == CAT STUCK IN DRAIN. :GGV311 SNOTIFY C TTG20 P :

address: P2 9/4 MERLOT CT

_Kapil 26-Sep-14 2:01am View

i am not able to get form where i start to get address because if i hit google map("https://www.google.co.in/maps/preview") with any address keyword ,getting response from google map search.
Not able to identify its correct address or not.

_Kapil 25-Sep-14 8:05am View

Deleted

[Comment repeating the question removed — SA]

_Kapil 17-Apr-14 4:28am View

eg. we have a salary table with employee salary details.

Q. Get employee details heaving 5th highest salary.
Q.Get employee details heaving 3rd highest salary.
Q.Get employee details heaving 10th highest salary.

I have required a query only enter the what number(eg. 1,4,7 etc.) employee details we want
and get details.

is it clear.

_Kapil 17-Apr-14 4:22am View

Records

_Kapil 20-Sep-12 2:16am View

i am agree with you , but i am looking to send bulk eamils in BCC so please suggest me...
Thanks

_Kapil 20-Sep-12 2:05am View

Have an idea how to send bulk mails in BCC..................

Thanks

_Kapil 20-Sep-12 2:05am View

i want to send Bulk Mails in BCC but not to send it only send mail at first address...

_Kapil 20-Sep-12 1:57am View

Thanks for this solution,but i am looking for send mails in bulk so that other recipients don't have information to whom i send this emails.

I hope you understand what i am looking for..........

Comments by _Kapil (Top 20 by date)