Dwain.C,

I modified the grp=0, to a -1 and + 1, seperately, and the query got me the result expected, even though it wasn't in seperate columns, which is fine.

SELECT LP,...

Ok I read Jeff's article on http://www.sqlservercentral.com/articles/Tally+Table/72993/ and at first put the code in a seperate window and it didn't work, since i suppose the the #test table...

Hi Dwain,

I tried you're query but am getting the following error:

(2 row(s) affected)

Msg 208, Level 16, State 1, Line 4

Invalid object name 'DelimitedSplit8K'.

By the thanks for helping..its appreciate.

Thanks GilaMonster. So it's not possible as is for a query to answer this problem? As I will have many data sets, in rows, so not possible to split sentences...

Thanks ChrisM, this worked flawlessly. Now let me try to understand this.

Thank You Again.

Thank you for your help thomashoner.

In the output, the

lp should only one instance each of

/

/catpage

/dogpage

and the kw column should have the corresponding words associated with the page

for...

Thanks Lynn, you'res was the easiest solution for me. I'll have to look into the others more. Thanks All!

dlangschied, great question.

I ran into same problem when learning sql when importing from excel.

Do this.

Look at column sql is reporting the error when importing.

Then go into excel, create a temporary...

Thanks Jeff for englightening me on the benefit to the forum members of using create table / select/insert statements for readily consumable data. This is all new to me...

After spending some time dabbling with this, I finally figured it out 🙂

it required adding several self joins to the from line such as

select color.[colors] + ' ' + itm.[items]...

Thank you guys. Appreciate it!

Hi Pirrot,

Excellent Question. I had exact same problem and recieved same error message. I spent about 3 hrs researching to finding the right resource to find the fix.

What you need...

Ok here's my attempt...

select [Colors] + ' ' + [Items] +' ' + [Size] as 'Combined KW'

from [dbo].[MYDB] as KW

cross join [Colors] cross join [Items] cross join [Size]

i'm trying to...

Hi John,

Yes I agree something wrong with that. I'm working with large data set, didn't even notice.

Anyways, I did read the link you posted on forum etiqutte so hopefully...

Thanks for you're help Brian. That worked. I am now trying to show which IP's are used more than once, so I tried

select LEFT(127.0.0.1,len(127.0.0.1)-charindex('.',reverse(([Ip]))))

from tablename

group by 127.0.0.1

having count (127.0.0.1)>1

order...