The problem with joining you might need to join more than once, or even more than twice. You need to create an alternate method.

For reference you should google "Trees in...

Create table #T1 ( [USER_ID] int,  MAILBOX_TYPE smallint)

insert into #t1 ([User_ID], Mailbox_Type)

select 1090,2 union

select 1092,2 union

select 1093,2 union

select 1094,2 union

select 1095,1 union

select 1097,2 union

select 1098,2 union

select 1099,2 union

select 1100,2 union

select...

Eerrr...

I better check it. I may not be running sp1,

Thanks for posting what you found out.

Which field(s) is the primary key defined?

Your issue is want sql to use a "Sequencing" value. But your inserting it set based, which does not provide this functionality.

The only column...

We need more information.

This part of the query indicates to me your only pulling a single team.

where t.ClubId in (select ClubID from Squad Where...

Without having your tables, Data, and Desired result it is impossible to look at your query and identify what could be wrong with it.

perhaps you could try

count(distinct INVOICE.SB_INVOICE_ID) AS REMINDERS

Good...

The short answer is No, not an easy way.

But what are your requirements for Backup?

Just to keep a copy of the data as it is today?

You could bcp, or dts...

Hmm..

Looks like there is more than 1 record per student for SCHLYEAR, GRADE, TERM, SCHOOLATTN. So going back to your initial request

you simply want a list of stulink ids where...

Not knowing yoru data I had to make an assumption that Stulink was the reference to the student.

Anyway here's a table and example and you can see what I did.

Create...

You don't need to post your question across multiple boards, everyone people usually check all boards.

Follow Thread here

http://www.sqlservercentral.com/forums/post.aspx?forumid=146&messageid=254504

The Chart control is embedded and is not editiable.

In Visual Studio

If you right click on chart, and select properties.

A window pops up. You can change the Palette.

But that is the...

question is which record if many are found do you want to insert?

Distinct won't work, because any one of these fields could be different.

STATUS, TERM, SCHOOLNUM, STULINK, [SEQUENCE], USERFIELD1, USERFIELD2,...

Sorry it took so long.

Couldn't decide how I wanted to do it.

I created a function that takes the field to parse, and the segment you want.

IF EXISTS (SELECT *

   ...

Pinky, I have a question.

Will there always be 4 "-" dashes in your string between the "()" parenthesis?

or does that vary?

Its Okay, usually everyone checks all boards

I attached some infor in your original post

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=254203