It's threads like this that remind me on a regular basis how much I still need to learn about SQL Server :hehe:.

...

I...

You...

...

So how's Windows 98 holding up nowadays?

Can you confirm the version of SQL you're running?

This is usually referred to as a "Running Total". See the link in my signature for a wonderful article on how to solve this issue.

rajn.knit07 (5/5/2010)

---

Hello,

You have to write cursor here to update your lunchperiod data in class table from student table. First of all insert what ever data you have in class table....

Glad I could help.

If/When you do come back to it, it shouldn't be too hard to write some code that will script it all out for you. No real need to do...

Very nice. I'm...

Danny Sheridan (5/4/2010)

---

Thanks, Jeff! I appreciate the kind words and the welcome aboard.

Jeffrey Williams-493691 (4/30/2010)

---

I have to agree with the others, good start on posting. I did want...

There quite possibly is, but I'm still not quite clear on what you're doing.

What are your expected results from this:

DECLARE @test-2 TABLE

(

...

Here's an example that does parse the list instead of using dynamic SQL. Note the way that I supplied sample data and create table statements. In the future,...

CASE

ie.

SELECT CASE WHEN Yourvalue IN ('Yes','No','Maybe') THEN YourValue ELSE 'Invalid' END as Result

From YourTable

Depending on the answers to my above two questions, this might be able to be handled with a lookup table and some dynamic SQL.

IE:

1,2,3,4,5

and a lookup table such as:

Value ...

Is it really as simple as every table having CR and the number, or could you have a situation where say:

11 ties to CR34

or

12 ties to TM12

etc.

Also, are all your...

You could rownumber both tables and join on that. As others have hinted at though, there's not much sense in doing so. Please describe your goals with this.