Comments by Photon_ - CodeProject

Photon_ 5-Dec-12 1:26am View

on local server machine

Photon_ 5-Dec-12 1:26am View

Deleted

see update

Photon_ 5-Dec-12 1:16am View

The query is executed on server(locally) no other process were executed during execution of first one although with the other one execution of other were on process.

There is the difference of join and only joining all the conditions and fields taken are same no difference there.

Photon_ 5-Dec-12 1:08am View

yes, if i repeat the query it show different time not even less but also more too,

but my question is why so big different i think you didn't visualize the question see the second one shows time in minues that is > 41 but the second one shows result within half minutes this is my question and also the domain of query , condition and even output is also same and ya there is one and only difference is type of join but how much it is different this is the question ?

Photon_ 16-Apr-12 10:38am View

Sorry i'll update it 2 Amar this time i'm from mobile and I think you can make some changes to get exact what you want

Photon_ 16-Apr-12 8:11am View

if it solve your problem please upvote

Photon_ 16-Apr-12 8:05am View

in union rows are joined and in join columns are joined do you still think the same its easy to do with union or intersection

Photon_ 5-Apr-12 0:52am View

it will crop the radio button

Photon_ 15-Mar-12 7:20am View

Create Trigger

Photon_ 10-Mar-12 0:52am View

You should check your system date
this ssl error may be caused if you are using very fresh copy of sql 2005

Photon_ 6-Mar-12 5:32am View

Please upvote if it helps

Photon_ 4-Mar-12 23:52pm View

but don't you think it will consume a lot memory space

Photon_ 3-Mar-12 8:43am View

i think session will occupy a lot cache mem space i am to store table it could be too large

Photon_ 3-Mar-12 7:36am View

IS THERE ANY

Photon_ 3-Mar-12 4:08am View

Deleted

its have with

Photon_ 3-Mar-12 4:07am View

have with

Photon_ 3-Mar-12 4:06am View

Plese give you table structure

Photon_ 3-Mar-12 1:38am View

What you actually want to do Explain are you counting days

Photon_ 1-Mar-12 23:41pm View

listen you can't do any think in php which will execute in client site
php is server side language all code are first converted into simple html then comes to client as html js page not php

read php first

Photon_ 1-Mar-12 23:39pm View

you want to do in php or with js

Photon_ 1-Mar-12 5:13am View

thanks

Photon_ 1-Mar-12 3:21am View

Deleted

From which you want to delete tab 1 or 2

Photon_ 1-Mar-12 2:13am View

you were right but the main mistake was
delete 'l'

i was not adding this 'l' thanks

Photon_ 1-Mar-12 2:10am View

Great good work

Photon_ 1-Mar-12 2:09am View

both are connected to party.id

Photon_ 1-Mar-12 0:22am View

gives error
Incorrect syntax near 'l'. Severity 15

Photon_ 29-Feb-12 7:51am View

gives error Incorrect syntax near the keyword 'LEFT'. Severity 15

Photon_ 29-Feb-12 5:54am View

i got error
Incorrect syntax near 'l'. Severity 15

Photon_ 29-Feb-12 5:45am View

see improved question error comes near 'l'

Photon_ 27-Feb-12 8:29am View

i have some big images and i want to see the real performance as it will be on web

Photon_ 27-Feb-12 8:28am View

its not 404 its just simple like internet not connected error page but other sites are being opened

Photon_ 27-Feb-12 5:33am View

i knew the solution but not working currently for firefox understood

A web browser plugin throttle i got to know to control bandwidth but not working for firefox currently

Photon_ 27-Feb-12 5:32am View

I've asked an appropriate question if you don't know don't comment let others answer

Photon_ 27-Feb-12 3:46am View

I said i've given this example but i am to do some large manipulations in my program

Photon_ 24-Feb-12 23:35pm View

i'm showing an example but it have a large domain

Photon_ 20-Feb-12 7:42am View

@ sanjeev :: actually its also easy to get back to the original css just apply any class and just remove that
as we can do with jquery
$('#id').addClass(".class");

so we can use to get back the default css
$('#id').removeClass(".class");

Photon_ 17-Feb-12 7:27am View

right

Photon_ 17-Feb-12 7:27am View

a long work but just think about hundred rows

Photon_ 17-Feb-12 7:02am View

this should be right query

SELECT DISTINCT prl.description ,
convert(varchar,prl.effective_date,103) effective_date,
b.description brand ,
pc.description cat
FROM ProductRateList prl,Products pro,ProductCatg pc, Brands b
WHERE pro.Id = prl.Product_Id AND pc.Id = pro.ProdCatg_Id AND B.Id = pro.Brand_id AND pro.Active = 'Y'

Comments by Photon_ (Top 39 by date)