Maybe just add a DateSent column to your table? Then you can update that when you send the notification (good for historical purposes) and then your main logic only gets...

Try looking at the upgrade advisor. http://www.microsoft.com/en-us/download/details.aspx?id=11455

And no you can't have part of the database in 80 and others in 100. It is set at the database level.

Try this.

http://www.sqlservercentral.com/Forums/Topic415829-338-1.aspx

I just can't seem to figure out what it is you want. I have called for reinforcements. We will get you some help on this. 😀

Can somebody help here. http://www.sqlservercentral.com/Forums/Topic1437758-391-1.aspx

I know it isn't too difficult I just can't seem to figure out what they want.

timotech (4/2/2013)

---

Good Day,

Please i need to speed up the runtime execution of queries on my online server, this database has over a million records in separate tables, and i've already...

Here is another way of doing this.

declare @dt nvarchar(6)

set @dt = '022500'

select stuff(stuff(@dt, 3, 0, '/'), 6, 0, '/' + case when cast(right(@dt,2) as int) >= 70 then '19' else...

Nagaram (4/2/2013)

---

I edited the main post .

Sean Lange let me know till if it not clear .. My english is not so good

Here is the logic:

select '11003291001-----NOB30000','0V003','A00A00',269,285,305,1 union all

select...

Great job posting ddl and sample data. After that though whatever you are trying to do is totally unclear. Can you try explaining again what it is you are looking...

I would agree with Phil that this is not the best way to split a string. I would go one step further and suggest that you have a function called...

Lynn Pettis (4/2/2013)

---

Sean Lange (4/2/2013)

---

Jeff Moden (4/1/2013)

---

Sean Lange (4/1/2013)

---

Your data is not normalized and your results are not normalized. The reason this is difficult is because your structures make this...

Jeff Moden (4/1/2013)

---

Heh... I can't help...

First of all...

Lynn Pettis (4/1/2013)

---

Please explain what you mean by format is...

ccmret (4/1/2013)

---

Is there any easier way to do this sum/divide without having to put results of sum in a temp table first? Trying to do it all in one...