susmitha117 (6/27/2014)

---

Hi,

I have a table 'ABC' and a stored procedure which updates 'ABC'. I update the table 'ABC' every week some times monthly. So i have a task that...

So the order within a period doesn't matter?

What is the output you...

You might be able to do it from this table but you need something to use as an ordering column. There is nothing in your current table to know what...

WADRIAN68 (6/27/2014)

---

thanks but that's not an option, the base tables just show payments, positive or negative, what I'm trying to do is create a statement style table. Which I've...

Switch you char(13) to char(10). 😉

WADRIAN68 (6/27/2014)

---

Hi

It's a simplified example and i do have more detailed data i.e. the transactions and payments. Nevertheless I need the data in this format, as it is supposed...

GilaMonster (6/27/2014)

---

How? Top without an order by I can see, MIN (the minimum value)...

Is it possible to restructure your table? The reason you are really struggling with this is because your data is not properly normalized. You are trying to store totals on...

SQLRNNR (6/27/2014)

---

Sean Lange (6/27/2014)

---

Loner (6/27/2014)

---

I just had an interview. Someone gave me 3 tables and asked me to write a query.

I struggled it and could not come up with the...

Loner (6/27/2014)

---

I just had an interview. Someone gave me 3 tables and asked me to write a query.

I struggled it and could not come up with the answer. I...

mickyT (6/26/2014)

---

I'd vote for Lynn's personally. His will return all the rows for Markers that have multiple rows all have Val 'Y'. This would become important if there...

Why have NO CACHE on your sequence? It does a good job of keeping the values sequential but all it really does is prevent gaps like you might find in...

Zippers

Here is another way to do this. This method prevents accessing the table a second time. Not sure it is more efficient in your real world situation. It does however...

carrieathomer (6/26/2014)

---

do you see the url of this page, the id used inthe URL.

jumping 10000 everytime for server restart (happens in shared hosting environment) creates 7 digit or 8 digit...