Reo (11/18/2010)

---

Respective All,

Everybody is taking my question in native way. But I am putting this question very gentle that how to interact with non-DBA manger? It is my gentile question...

You're welcome.

Most "security breaches" are still insider work. People who have legitimate access to data, who misuse that, or who are duped into giving it away. That's not really...

I'll "third" that. While you could do something like this in the database, it's going to be overly complex. Presentation in the presentation layer.

Is the CD for Dev Edition, or for Eval/Enterprise?

Take a look at pivot and unpivot, see if they'll do what you need.

Jack: I'd get with a lawyer and an accountant and talk to them about options. It'll cost a little bit, but it'll be worth it. Most likely,...

Sounds to me like you have your logical design already. Houses and Time Periods. That should translate into tables (physical implementation) pretty easily. How familiar are you...

Most of the time when dates are stored that way, the number before the decimal is the number of days from a starting date, and the number after the decimal...

You'd have run into an error message if you tried to create a synonym with the same name and schema as a table anyway, so it would have sorted out...

Here's a sample calendar table, with some queries against it.

IF OBJECT_ID('dbo.Calendar', 'U') IS NOT NULL

DROP TABLE dbo.Calendar ;

GO

CREATE TABLE dbo.Calendar (

Date...

Adam Gardner (11/15/2010)

---

grahamc (11/15/2010)

---

Adam Gardner (11/12/2010)

---

Where are the flying cars I was...

If they're on the same server, only keep one copy of the tables. The other database should have synonyms that point at the master copy of the table, not...

Is your copy of Windows up to date? All patches?

jagadeeps (11/17/2010)

---

i am converting the date fileds and concatinating them. as i had converted to varchar i am getting error while i am trying to update the staus_id(bigint) column with...