activity is high that is for sure, is it necesary to post 3 times <img src='/community/emoticons/emotion-5.gif' alt=';-)' />. im not pointng finger...
Are you using with schemabinding option.
Check in BOL section Creating an Indexed View.
parsename returns the specified part, but to extracte you need substring function anyway.
we have a requirement in sql server to write a script in extracting numbers from alphanumeric string. I have looked at char-index and patindex but...
thanks madhivan as satya referred i m not a learner in sql server.
thanks that is correcte direction. i got that
i remember till last year your site encouraged users with prizes. i dont see that here for a long time, what is the reason?
i feel that is good to...
oh great one, you helped me previously and every time i come here you are higher than sky.
bienvenue to here see how good people in this website.
no worry we are able to transmit sql here success.
i missed a good chance in march, oh no.
fÃ©licitations to all winners, any chance i get the left over or if im in 102 in list.
adrian thanks for the suggstion. im new to joins is it possible to write query by you.
i have a query that returns successful results getting the distinct id from a enquireies table as follows:
select DISTINCT enq.enqid, enq.empid
i have been enjoying this forum with some cool and funny posts over here, what happened no one seems to be posting any more here.
try the same on the machine that is installed with SQL 2005SP1.
there is a good article by brad in this site about audit performance tuning that will help you a lot.
still most of the bpa items in sql 2000 are applicable to 2005.
dont give such default such as . or [local], run select @@servername and see whether it returns correct value.
It may be problem with running SQL 2000 and 2005 in active/active scenario, its better to have them seperately, tools & other components in SQL.
well said and canadadba you need to be clear about problem with current sql tools you have.
Separate names with a comma.