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

Yes Possible using DTS.

For a good resource on DTS Stuff.

Go to DTS.com and there's a few tutorials you can look at.

http://www.sqldts.com/?1

Oh, just put in your where clause

select substring(Field,patindex('%[0-9][0-9][0-9]%', Field),3)

from #t1

where patindex('%[0-9][0-9][0-9]%', Field) > 0

cheers