Comments by lovejeet0707

lovejeet0707 14-Aug-15 8:43am View

I guess we don't need to take the avg of multiplier....I can directly multiply with the multiplier....!
Thanks for the Help...Worked like a Magic :)

lovejeet0707 14-Jan-15 13:12pm View

Great. Thx....I do it !

lovejeet0707 14-Jan-15 13:08pm View

Yeah its looking simple, but didnt work.
Can you re-write the query how it will be done

lovejeet0707 14-Jan-15 13:03pm View

Sorry didnt get uhh ??

lovejeet0707 14-Jan-15 12:47pm View

You mean this :
Select * from ACCOUNT where 1 in ('UGEREA0000OB','UGEREA0000OE') or 2 in ('UGEREA0000OB','UGEREA0000OE') in (MODIFYUSER,CREATEUSER) ??

However this is not working.

lovejeet0707 12-Jan-15 3:53am View

as i have to check against whole table....so using top wont work....!

lovejeet0707 12-Jan-15 3:52am View

Worked for me...!
thx :)

lovejeet0707 20-Nov-14 7:24am View

Yeah for sure I will do it....!
I jst need to get Idea how u wrote the Query of joins !!

lovejeet0707 20-Nov-14 7:10am View

Sure but can you please for Once re-write your query showing joining of table
Table Name: Opp_Info
Column Name: Opp ID, Description,Status,Values
Please this help will be highly appreciated.

lovejeet0707 20-Nov-14 6:58am View

let it be table Opp_Info having Opportunity ID
than How can I join it...?

lovejeet0707 20-Nov-14 6:51am View

How can I write the additional join table,
for example Table Account - AccountName,AccountID
Contact- ContactName, ContactID.
Thanks in Advance :)

lovejeet0707 20-Nov-14 6:44am View

Actually Query is Working out for me.....!
Thanks

lovejeet0707 20-Nov-14 6:34am View

HiActually problem is this only, I have Same Opportunity ID and different rows.
I just need the most recently Updated row.

lovejeet0707 20-Nov-14 6:26am View

I have Hundred Thousands Record like this in my Table.Its not feasible for me to first sort the data and than select top 1.
So I dont think first approach works.

and I am still doubtful what the second query is doing....!

lovejeet0707 9-Sep-14 8:40am View

Not Working :(

lovejeet0707 9-Sep-14 8:38am View

I guess it will be OR.
bcz i need either of Optout or exception NOT both....i.e even if One succeed it will work.

lovejeet0707 9-Sep-14 5:39am View

Perfect...........Spot On...!!
Thanks Sir :)

lovejeet0707 8-Sep-14 10:28am View

Spot On.....!
Thanks :) :)

lovejeet0707 8-Sep-14 9:37am View

How can i Write the same SQL which I mentioned here in form of Parameterized Query.

lovejeet0707 8-Sep-14 6:29am View

I have a function in my .aspx page which will fetch the record as mentioned in query.
How do i write this sql query in my aspx page in C#.

Hope i made uhh Understand.

lovejeet0707 8-Sep-14 6:15am View

I m trying to pass it through sting as :

strSQL = "Select * from (Select A.ContactID, B.CASLOptIN,B.CASLOptOut,B.CASLException From Contact A " +
"inner Join GE_ContactInfo B on A.CONTACTID=B.CONTACTID" +
"Where A.Accountid ='" + entity.Id.ToString() + "') as Casl" +
"where(Casl.CASLOptOut ='F' or Casl.CASLEXCEPTION is null) or (Casl.CASLEXCEPTION ='F' or Casl.CASLEXCEPTION is null)+";

but it is throwing exception "Failed to parse"

lovejeet0707 11-Dec-13 6:08am View

Deleted

No comment

lovejeet0707 11-Dec-13 5:35am View

Hi Squiggs
SIngle Sign On Page authenticates user at its own level.Its their own authentication protocols.I am jst navigating users to my application after user logged in through sso login page.

lovejeet0707 9-Dec-13 3:27am View

He means IIS manger - SA.

lovejeet0707 9-Dec-13 2:51am View

Hi Squiggs
Well authentication is being managed by Single Sign On page.
The credentials of SSO is being used to login to application home page.
The Problem I am facing is that when user logoff it is unable to redirect to SSO login page rather it again comes to Application Welcome Page.

lovejeet0707 3-Oct-12 4:51am View

I want that only sound should be played on button click event....NO visualization of media player or something like that ...!!
please provide me a code for the same !!!

lovejeet0707 29-Jul-11 7:37am View

but i have not deployed my application using ftp.

lovejeet0707 29-Jul-11 5:00am View

No its Not Working Raja.
and i am not using ftp Server.
I Hope you can help more surely....

lovejeet0707 29-Jul-11 4:56am View

I am not using ftp Server.

lovejeet0707 29-Jul-11 3:59am View

Error: The SaveAs method is configured to require a rooted path, and the path 'www.tnp.somee.com/Uploads\Document.docx' is not rooted.

lovejeet0707 29-Jul-11 3:53am View

I have the Same Question......
Please Reply to me as soon as it is solved

lovejeet0707 16-Jul-11 7:29am View

Buddy sorry, that i was unable to Explain you....
Let me Update the Question.
Hope You can help.

lovejeet0707 15-Jul-11 4:48am View

Sorry SA :(
Its my fault that i was unable to explain my problem.
I just wanted to have the feedback form,might be based on smtp mail concept.
I just don't have more words to explain.

Sorry for what i gave you.I am just not able to get you and i think vice versa for you.

I just need feedback form like this : http://www.mikesdotnetting.com/Article/41/Send-form-content-by-email-in-ASP.NET

lovejeet0707 14-Jul-11 7:54am View

I Still did not get You Sir......
I Just want to know,how to get a simple feedback form......

lovejeet0707 14-Jul-11 3:20am View

What was that?????????

lovejeet0707 14-Jul-11 3:06am View

What do you mean by that Sir SAKryukov????

lovejeet0707 14-Jul-11 2:53am View

Be More Specific to help you.

lovejeet0707 12-Jul-11 4:48am View

any other source,
i am still not satisfied...

lovejeet0707 28-Jun-11 2:31am View

He is asking for sql connection but link of w3schools is based on oledb connection.......

lovejeet0707 23-Jun-11 6:29am View

All are learners Christian.......
You should always have helping hands towards others......
Atleast not criticising them......
thxxx

lovejeet0707 21-Jun-11 4:29am View

I want when person sign out he should not return to previous screen just by pressing "Back" or typing its "url address".......

lovejeet0707 21-Jun-11 4:29am View

Christian can u help me ...........
plzzzz......

lovejeet0707 21-Jun-11 4:28am View

I want when person sign out he should not return to previous screen just by pressing "Back" or typing its "url address".......

lovejeet0707 21-Jun-11 4:26am View

Christian what do uou Say ??????

lovejeet0707 21-Jun-11 3:52am View

No Error Message.........
Just Session is not Expiring......

lovejeet0707 21-Jun-11 3:49am View

No Session is just not Clearing.
It is Not Expiring........

Comments by lovejeet0707 (Top 46 by date)