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
Separate names with a comma.