I'm currently trying something like this:

DECLARE @t TABLE (Id INT)

INSERT INTO @t

SELECT 108 UNION ALL

SELECT 102 UNION ALL

SELECT 103 UNION ALL

SELECT 101;

DECLARE @t2 TABLE (CategoryId INT, Id INT)

INSERT INTO @t2

SELECT...

Thanks for your help. On table @t2, Id however is not primary key so if I had a the following data set, the solution would not work:

DECLARE @t2 TABLE (CategoryId...

Thanks for your response.

The result sets returned for those data sets are different (number of columns returned / data types) so not sure if it's possible to do this in...

Thanks for the advice. I got two working solutions but I'm sure it could be improved so I though I would post and see what experts say. What I currently...

Hi Lynn,

Thanks for your response. You would need to add the following synonyms to your thesaurus file (tsenu.xml) to see some sample data (located at ...\MSSQL\FTData\)

<expansion>

...

Thank you.

I would also like to search for synonym words, however they should not be counted separately. Note, these synonyms could also be placed in a new table, they don't...

Jeff Moden (6/17/2014)

---

clayman (6/17/2014)

---

Thank you for your quick response. Table @t may store up to 25,000 rows (I used table variable just for demonstration purposes) and yes it is...

Thank you!

I have two follow up questions.

Is there a way to change the query so that it only counts the word(s) once per row?

Also, I would like to count...

Thank you for your quick response. Table @t may store up to 25,000 rows (I used table variable just for demonstration purposes) and yes it is a varchar(max).

Yes, I would...

Thank you for the heads up, I'll fix that! Any suggestions regarding the gap for the 25.00 - 49.00 range?

Hi,

Thank you for taking the time to respond!

Consider the following:

DECLARE @num AS TABLE (

ID INT IDENTITY(1, 1),

Price Money);

DECLARE @range AS TABLE (

ID INT IDENTITY(1,...

Jeff Moden (4/12/2014)

---

What type...

So I was asked to answer a bunch of nasty Xpath syntax questions, needless to say I didn't get the job (not that I mind).

Luis Cazares (1/31/2014)

---

I wouldn't expect technical questions from the CTO. I believe that it should be more on:

Why would they hire you?

Personal experiences on problems and how were they solved.

What...

Also, Express with advanced services has SSRS (no SSIS though).