GrassHopper (1/30/2012)

---

How can i get my table to show the results i want below? Pivot table? I've never used pivot before.

Table:

tocidprop_idstr_valnum_val

1059786104USDNULL

1059786105Pricing Null

1059786108NULL1539.17

results:

tocid str_val str_val...

Kal Penn (1/23/2012)

---

We have database in our company comprising of about 800+ tables. Reason being, we try to use same database for variety of our customers sharing about 75% of...

THE-FHA (1/30/2012)

---

i need a script that can connect to multiple sql server instances and collect Mantanance plans status. I want to be able to generat a report daily for successful...

markd 82708 (1/30/2012)

---

Hi,

I am looking for a way of upgrading a our customers sql databases to the latest schema without the need to directly compare the database to a...

As already pointed out in this thread there is not such a thing as cross-database referential integrity therefore you cannot have a real FK pointing to a PK in a...

azhar.iqbal499 (1/30/2012)

---

Thanks

One more Question in my mind. When new Database backup would be restored then, would this create problem for Indexed view or not? Because Indexed views would be...

Well... both result sets show you two different views of reality and cannot be used to validate each other.

Depending on business requirements and...

SQL_Surfer (1/28/2012)

---

Here is the query that is thrwoing me off....If I comment the ReportDate portion out, I get aCount as 728 and bCount as 716 which is the right count....

Do not forget about "Books On Line" a.k.a. BOL which comes free with your SQL Server...

azhar.iqbal499 (1/24/2012)

---

We want to use Materialized views on our Live DB with excesive updates and deletes. But I have read from forum that its not recomended on busy database. So...

Elliott Whitlow (1/26/2012)

---

I don't know if I agree Paul, my policy is that ALL databases are owned by sa and that no one should have the sa password. I...

Database owner defaults to database creator.

I prefer not to have "sa" as the owner of the databases but what I call a "operational account" for such database meaning that different...

select DATEADD(second, @ORA_Create_Date, {d '1970-01-01})

Ulysses_Infinity (1/26/2012)

---

Hi, I'm a BI Analyst by profession - SAS, SPSS, Statistics etc. but about a year ago decided to teach myself SQL so that I wasn't dependent on developers...

As a DBA talking to DBAs better to get technical - data modeling language is...