u mean i need to write a function in msaccess.?

iam using asp, but doing that will slow down the process, i want to do it in a elite way.

its a...

pls reply to my question,

nobody knows ans to my such a simple question ??.

anybody home

well i mean such a simple query i wrote and it doesn't work on ms-access.

see

select a.col1,b.col1,a.col2,b.col2 from table1 a join table2 b on

a.col1=b.col1

what about left joins, and right joins, i...

i have a  problem,

i had registerd my site http://www.jobdhundo.com

to http://domain-registration-mumbai-india.skywebindia.com/

i stay in india/mumbai thats why registerd with them, but now i want to change the domain hosting to

i guess u r very new to sql server, there is icon in the system tray, click on that

run the agent services.

mark it...

use it with the column name

like

select charindex(rmlist,'|',1)

use it this way and see

it gives value 0, it always give value 0, it is deterministic function

how do i get this, i want it for free any resource ?

first try to send a test mail using an enterprise, there is 1 option to send an email, if u get an email, then there is somethign wrong with your...

paste the query and schema, we are not understanding anything what u r saying,

if u could clarify the other way that u need

it based on product id it would have been simpler to understand

productid buylistingid selllistingid

becoz u say other way problem looks confused

ur answer is great i never thought of union query throwing a resultset and then grouping it

simply great

do non-clustered index on carrier name it should work

how are buyinglisting and selllisting dependant on each other ?

pls give schema and some records so that we can make out what ur asking for