+100000000000000

There are VERY few absolutes when it comes to sql server but "NEVER store related data as char data"...

raghuveer126 (10/24/2012)

---

Hi I have something like this and the tables have no foreign keys. I am using date in where clause and i am not able to use id because...

????

SELECT

ROW_NUMBER() OVER(PARTITION BY x.cStudentId ORDER BY dtEnrollmentDate desc ) AS DaySeq,

x.*

from #x1 x

where cAbsenceCode <> 'u'

order by dtEnrollmentDate

nitinuniyal (10/23/2012)

---

Hi Sean,

We are using nolock only in select statement as recommended by our Application vendor, Our OLTP is too high and any lock even for milisecond can cause major...

Since you didn't answer...

Can you do the pivot in the front end? That would release the pressure from sql and put it in a system...

sdhanpaul (10/23/2012)

---

what the quirky query is doing is that it is update a column in the table called running total...suppose two users hit previewing the a running total report out...

managed to get both methods working...10006 rows later, update was faster..by 11 seconds!

means I can do away with the cursor for now...I will still keep it though as it might...

NOW THAT IS FUNNY!!!!

A cte is a common table expression. They were introduced in sql 2005. They are basically an inline view.

http://msdn.microsoft.com/en-us/library/ms190766%28v=sql.105%29.aspx

ksharpe (10/22/2012)

---

Hi Sean

I do apologize, I did think that I had copied the whole thing, not just the inserts, I certainly intended to post it all. and also thought that...

True that it depends. If the parameters can be declared inside or something then it...

I posted that to show you what you had missed. I would HIGHLY recommend you NOT use the cursor approach for...

sdhanpaul (10/22/2012)

---

Thanks for the reply...I went, took a shower n couldnt sleep till i got this thing figured...so i worked with the quirky update thing...got this:

/*************************************************************************************

Pseduo-cursor Running Total update...

You still never posted the last table, only the inserts for it. So I had to make some more assumptions about your tables.

Then what you posted as sample data did...

sdhanpaul (10/22/2012)

---

no inserts.

no ddls

sample data:

rawtrxid forcount emppin RunningTotal

----------- ----------- ----------- ------------

7 ...