Hey guys just a thought you've got '..NULL AND .....' er are you sure that is correct

Should it not be (.....NULL) AND (......)?

Have I missed the point?

Also in the previous...

prem:

Does you client code include the SQL commands for insert, update, select?

If this is the case you've got major issues.

Passing data parameters to Stored Procedures should have been the way...

premnathk.chn (5/16/2008)

---

Hi all,

Thanks for the interest you all have shown.

I have completed my requirement by doing identity insert off during the datamigration and then turning it...

premnathk:

Are your identity columns anything other than surrogate keys?

If no then why can you not scrap the current identities and start again because the actual values used only matter for...

:D:D:D:D:D:D:D

Another Mode 80 user!

:D:D:D:D:D:D:D

Mr Welcome,

Quick Question about the data;

1. Is it as others have 'assumed' that the data for a particular entity will be split into rows - 1 for each attribute?

or

2. Each...

Just read this thread! 😀

Its a fantastic idea! (as in the realms of fantasy) 😛

Some people never learn....we always propose this design first off as a laugh just to see...

Semper in chocolate, sumus solum profundum variat

Yum!

Q we've all seen TNG - Its really you and Picard isn't it that destroys creation? come on now fess up!

on a side note - bugger I though it was...

Derek Dongray (5/8/2008)

---

majorbloodnock (5/8/2008)

---

I've just realised. If someone reports a SQL Server bug to Microsoft, they can post it as a QOTD to see how much of a problem it...

Yeah and what would happen if it were Oracle?

Should that be a MS werewolf (mode80 or 90)? 😉

janine.rawnsley (5/7/2008)

---

Works fine in SQL2000.. you'd get the start date column twice (once at start, once wherever it naturally sits in the order of columns on the table.. and order...

Yeah no good shouting when your upto your eyeballs in it 😀

I totally agree - English question - English Answer

Does it work in Swahili, Spanish, French and German? Can I spell Swahili?

😀 'If...

Just googled this

http://www.irishdev.com/blogs/merrion/archive/2007/02/20/2962.aspx

The guy states that duplicate indexes are a drain on server cycles as each update, insert or delete has to be reflected in each index.

Definately a disadvantage in...