at this point i dont have bol, i know i can download it,its good to look at it ocassionaly, it has only information not answers to questions.

still some of my...

u mean u had some stored procedures to trace worst performing queries, now u dont have them.

if we found out worst performing queries then how to work on that.

pls iam...

if there are 1000,s queries then do i need to check each query in a profiler, there is another dude

and he also asked me which hardware do u recomend as...

great,

thank u for ur information, it was short and sweet

was my suggest useful, was it wrong, please advice me

use a function instead, write that query in a function, by function u will be retrive the value

Yo!

we have a seperate tool, which creates tables automatically when we create asp page.

we are limited only to design forms, data tables are created automatically.

we are working on asp and...

Yo!

we have a seperate tool, which creates tables automatically when we create asp page.

we are limited only to design forms, data tables are created automatically.

we are working on asp and...

Yo!

we have a seperate tool, which creates tables automatically when we create asp page.

we are limited only to design forms, data tables are created automatically.

we are working on asp and...

u mean key indexes ?

clustered,non clustered index ?, how come, when u use where clause, role of indexes comes into play is in't it?

well i did a search using charindex in google.

and i found some use of it.

but that solution was simple it is

using

txtpolicycode like '%/%'

uff.

it was simple i just couldn't think it in...

well *Sigh*, thats the problem dood, there is no bol installed in my pc.

we dont have sqlserver or client installed, we are having winsql as sqlserver client as it...

no dude,

iam extracting data from an xml file, which has a format in the above mentioned format.

after extracting data from it , iam goind to create an xml string.

with those...

its possible using dynamic cross tab query, its possible

when i do it i will paste the code here

i think u gave example for sql server,

but iam using ms-access2002

thanks anyway