Hi Naked Ape,

Well that is my issue here. It's one thing to view real time data adapted to your time zone, it's one thing to query it that way. and...

Yep,

There are a number of articles to explain how to "simulate" arrays and other similar data structures that we wish we could use online. I don't have any favorites on...

That's what I'm thinking too. It's more work on the client side but it helps spreading the load of converting the data and it also makes the server completely independent...

hi,

Nevermind my second solution, it's not possible in sp... my bad.

Maybe something like this: http://www.sqlservercentral.com/articles/News/3182/ would do? But I'm not sure it's a great idea neither. If you...

Hi there,

Two solutions that I can quickly see for your problem:

1- Keep the varchar parameter and in your code, split it into integer using a separator and for each of...

Ahhh... I see. I wish I could specify a table name but this is not bad at all actually, thanks a lot!

Jeff Moden (12/13/2007)

---

Ummm... actually, Scope_IDENTITY() is exactly what you...

Thanks a lot, i was hoping for a nicer way to do it, but this could do for simple queries

Hi,

The COUNT() was one of the subqueries we use. We basically want to do something like this: SELECT COUNT(*) FROM table WHERE DELETED=0 AND ...

I mean that's of course not...

Hi,

thanks for the answer. I've run some preliminary tests since we're trying to figure out if we're better off partitioning or using separate tables with triggers to move the data...

Interesting idea actually thanks! 🙂

I was wondering though. Let's assume I create my partition on this bit column. I first insert a new row with the deleted value to 0....

Thanks a lot for the help and the amazingly quick response 🙂

I am trying to plan ahead. When we first picked this way to do this it made sense because the database activity was mostly due to user interaction. However, with...

Hi,

That's actually the way it's currently setup. We take the minimum date and compare it to @MaxDate and do a WHILE loop that contains a WHILE for the list of...

That is exactly my point. I hardly ever know what column headers I explicitely want. I know I want a certain value to become the column header, but how many...

Hello,

Thanks for the reply. I managed to get the dynamic columns working using the stored procedure with a cursor as I have mentioned before, but doing the pivot myself basically....