From what I gather reading all of the posts here, you are putting the info into a DB just for record keeping, correct?

If that is the case, is there a...

Wow, total flub on my part! :blush:

Thanks for the catch KB.

Edit: Removed my first short sighted response.

I am very cautious about the implementation of Full Text Indexing. I have even more doubts when implementing it for such a narrow column, where a normal index could...

VERY glad that I refreshed your post before responding. Your edit really cleared up what you were missing! 😀

Here is an example of how to solve it:

DECLARE @tmpDate...

Chad --

Lynn has given you some options, but let's follow that with some explanation...

In the second line of your code above, you set your DATETIME variable to a day,...

Well, that's better than the other way around, Matt! 😀

Not being 100% what you were looking for, I am going to assume two things. First, that you are looking for any name that has multiple upper case characters...

Thanks for posting that Daniel.

I had tried several different nested queries and couldn't get any of them to return in the desired format. Now I get to...

First, to observe the rounding that occurs when working with DATETIME values, run the following:

SET NOCOUNT ON

DECLARE @Tb TABLE (Dt DATETIME)

DECLARE @dt DATETIME, @Cnt INT, @I INT

SET @Cnt...

I am not 100% on what result you are looking for, but here are a couple of options.

If you are looking to join multiple result sets as a...

The USE statement cannot be used to change servers. It is simply for changing the database context, which occurs after the connection to the server.

If you need to access...

Performance might prove interesting, but this is an option:

SELECT R.Relative

FROM Relatives R, RelativeGroup RG

WHERE RG.Nodes LIKE '%ALOHA%'

AND R.Relative LIKE ('%' + RG.[Name] + '%')

I can't make a good performance test...

Art, if you run just your Anchor Member Definition with the same variable values do you get multiple rows? My first thought is that the GROUPing you are using...

Thanks for the clarification Larry.

And based on that info, your solution looks just like what I would have suggested. 🙂

Cheers!

I totally agree Antonio.

Great example of why we tend to look for plenty of DDL around here! 🙂