This is more optimistic 🙂

http://www.sqlservercentral.com/Forums/Topic475278-338-1.aspx

piershogg (4/22/2008)

---

Although there are other alternatives, it would be useful if I could use USE database with a local variable in a user stored procedure held in the Master database....

Sorry, I just noticed the comments at the top of your code.

ENGINE=InnoDB DEFAULT CHARSET=latin1;

ENGINE might refer to the underlying database program (or connectivity to it) that this code is run...

Apoztel (4/16/2008)

---

Thanks. Could you also tell me why linkcat is set as an int and explain what foreign keys and constraints do? Also is the '1' after 'FK_tbl_links_ ' the...

When you say sub-view, what do you mean exactly? Do you mean to UNION 250 tables together, or JOIN them, or what?

Please give examples (a couple example table structures,...

My question was more about the table2 structure, and what you're expecting to see.

Either way, you're not talking about a PIVOT as much as a full transpose. There's probably some...

Can you provide more information (column names, etc.)?

Generally, you'll pivot over a key field value (for instance, how do you know that value 1 goes in column 1, not column...

[To me] the more DBA the position, the more specific syntax-type questions I ask, while the more Developer the position, the more conceptual the questions. (admittedly, I haven't interviewed many...

Basically, stats people do this sort of problem alot. You might hear about deciles or quartiles; that's when you take your range of data, and assign it to different groups...

You guys and your fancy SQL 2005 functions...:hehe:

That's a nice one. How's the performance vs. something like...

What, you want answers too? 🙂

Well, assuming you have an integer-ish rowid field on the table, MOD it by the...

blahknow (3/28/2008)

---

Hi jeff,

This is how it works

"myPhones" is a stored procedure to supply the telemarketing personnel phone numbers to make phone calls.

phone numbers are stored in various tables of various...

No prob, it'd be worse if we didn't :hehe:

Right, that's what I wrote 🙂

blahknow (3/25/2008)

---

Hi...