Lynn Pettis (2/19/2009)

---

Nor what version of SQL Server, heck, it could be SQL Server 6.5 and there aren't many around that still use it (I can think of one who...

David Webb (2/19/2009)

---

Dear SQL Experts,

I am having problem with machinery controlled by SQL database. Rest of staff ran from room and supervisor shouted "You're in charge" as he shut...

[font="Verdana"]Should we add that to our list of DBA interview questions?

"What is the name of the master database?"

[/font]

[font="Verdana"]Have you had a look at the UNPIVOT command on SQL Server Books Online? I suspect that would do what you want.[/font]

[font="Verdana"]

Now we...

[font="Verdana"]Milla, you love your row_number()! 😀

Another possibility is to use a group by and use max(), sum(), etc.

[/font]

lk (2/19/2009)

---

Hello, all:

Unfortunately I'm an idiot and I realized through trying and failing to use your suggestions that I need to write this in VBA, not in SQL. I'm really...

[font="Verdana"]Wait, isn't it Jack? Then he can ring Microsoft and say "I don't know Jack, and I can't find Jack."[/font]

paul.starr (2/19/2009)

---

can you give examples of :

3. Get the last assigned customer prefix

4. Insert (as a set) the new customers, along with the correct customer prefix based on...

paul.starr (2/19/2009)

---

i have an insert proc that runs nightly to check for new customers, and if it finds them it inserts them so the entity sequence table should be updated...

paul.starr (2/19/2009)

---

two tables

Customers and EntitySequenceTest

Customers gets updated daily, and when new customerID's are added

the Entity sequence table column CurrentValue is set and when the new CustomerID is...

[font="Verdana"]Yeah,...

[font="Verdana"]We get this scenario in the staging tables of our data warehouse.

The solution we use is to drop all of the indexes except for the clustered index, do the insert,...

[font="verdana"]It's almost tempting to go into an interview with a harried expression, saying something like "I'm sorry, I'll have to reschedule the interview, one of our databases has gone down...

paul.starr (2/19/2009)

---

ok what if five records are inserted, and i have another table customer value that reads this customertest table for the new records in the (custid) field and increments...