I guess it is because VB is still considered an easy-to-learn language.

There are countless sites with free code around, but I agree that when you need to solve a specific...

11 mails as of now with the last one received at 1:38 my time.

Frank

http://www.insidesql.de

http://www.familienzirkus.de

quote:

---

Very nice article. We should all know these rules, but more importantly the database vendors should keep them in mind whenever they...

How many rows should your search return?

Can you provide more information?

Frank

http://www.insidesql.de

http://www.familienzirkus.de

You mean you have duplicates in your tables?

If so, search this site, there are scripts for this around.

Frank

http://www.insidesql.de

http://www.familienzirkus.de

Yup,

SELECT LEFT(your_field,CHARINDEX(' ', your_field,1)-1)

is better

Frank

http://www.insidesql.de

http://www.familienzirkus.de

I bet Jonathan will post PARSENAME stuff.

In the meantime try

SELECT LEFT(your_field,CHARINDEX(' ', your_field))

this assumes that you always have a blank as separator and no leading blanks.

Frank

http://www.insidesql.de

http://www.familienzirkus.de

Sorry, might work better with providing this link

http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=19009&FORUM_ID=9&CAT_ID=1&Topic_Title=SQL+Index+Tables+Out+Of+Sych+%2D+How%3F&Forum_Title=General

Frank

http://www.insidesql.de

http://www.familienzirkus.de

I think this is the wrong category for this thread. What about using the existing other thread on this topic?

Frank

http://www.insidesql.de

http://www.familienzirkus.de

What do you mean by 'out of synch'?

Frank

http://www.insidesql.de

http://www.familienzirkus.de

Sorry, but it is happening again

Frank

http://www.insidesql.de

http://www.familienzirkus.de

Is this a double post?

Frank

http://www.insidesql.de

http://www.familienzirkus.de

I'll second racosta.

Without having some sample data and further explanation on what you want, it will be difficult to help

Frank

http://www.insidesql.de

http://www.familienzirkus.de

http://www.microsoft.com/technet/treeview/default.asp?url=/technet/prodtechnol/sql/reskit/sql2000/part3/c1161.asp explains things a bit.

I for myself do store BLOBs in a db. That is a separate db that serve no other purpose than this. BLOBs are only stored, not...

quote:

---

Yes.

You can also create an aggregate column(s) in a table. This is good for reporting purposes as theres no need to...