I also don't have any experience in this part of sql but like I Tom I kind of guesses it would be 1 or 3. However answer #4 was just...

gsavitha (3/2/2012)

---

Dera Hall of Fame

Thanks for your reply

I am planning to retervie a 3 result set from a table.1st set contaning all record in the row 1,4,7,10 and so on

2...

Henk Schreij (3/2/2012)

---

Sorry Eugine,

I looked at the article you mentioned. An article from Jeff Moden is always a good reference. But this article is beyond my skills. 🙁

I have some...

You posted this query in two forums about jobs???

I will attempt to respond to your question.

In the below coding no compilation error but using this quary i am not getting...

ashwiniranju14 (3/2/2012)

---

select ProductID,Name,

NameResults.Rank as NameRank,

DescriptionResults.Rank as DescriptionRank

from Product

left outer join

containstable(Product,Name,

'Formsof(INFLECTIONAL,red)and FORMSOF(INFLECTIONAL,blue)',

...

I don't think the performance would be a big deal but there are a number of factors that can come into play.

Have you looked at replication as another option?...

You simply are going to...

I agree Jeff. I certainly wasn't concerned at all about receiving thanks. I also just read it as thanks to all who posted, which included me. 😀 Sheesh pretty soon...

Well what J Livingston wants to know is what version of SQL server are you connecting to. It doesn't matter what version of SSMS you have. What matters is the...

What is the result of this query?

select @@version

sabercats (3/1/2012)

---

Sorry, i am newbie and really don't understand what you mean "Please provide some ddl and sample data along with a clear explanation of what you are looking...

You have two major segments that are not sargable. The subquery join and your final where clause. Both of those will cause a index scan. If you have a lot...

Yes much like your other post, there just simply is not any information for anybody to begin helping. Give us some details and you will be rewarded with some results.

gsavitha (3/1/2012)

---

Dear All,

How can i set flag 1,2 and 3 for every rows using sql query? By ordering date field either des/asc

Your help is highly appreciated.

For eg:

Id Name...

ralu_k_17 (3/1/2012)

---

Basically I need to find all the characters that are between one word and another.

So every character that is different from [a-z].

For example in a text like:

"4 filets de...