er.sivaganesh (3/8/2012)

---

here iam having two table in one table the values are placed pre defined depend on that ...

Confused I am what you are asking.

Alexander Suprun (3/8/2012)

---

Lynn Pettis (3/8/2012)

---

Looks like you may...

Looks like you may have a different default...

Have to ask, but why the restriction on the number of records in each file? Personally, I can't think of a good business case for this.

junkid1376 (3/8/2012)

---

Here is what I have done, I am sure there is much better way of doing it. Since I am used to matlab I wrote is similar style.

CREATE...

Or you could do it this way. Notice the slight changes in the code:

SELECT

name,

SUM(CASE WHEN date_column >= DATEADD(YY,...

To take this a little further, what do you think the steps will be? I can backups and restores being a part of the process.

Will this work?

WHERE modify_timestamp > DATEADD(ss, 1, create_timestamp)

Elliott Whitlow (3/8/2012)

---

DBA_SQL (3/8/2012)

---

In order to protect against external threats. As you know it contains most of the PII data, I would like to apply some kind of encryption technique...

Since we can't see what you see, you are going to have to provide us with DDL for the tables, sample data for each of the tables, and expected results...

IIRC, SQL Server installation sets up some groups. Find out what groups and check those permissions.

I got mine at 1:35 this...

I provided SQL Server support to a PeopleSoft development/support staff for 5 years. The PeopleSoft tools generate...

Edward.Polley 76944 (3/8/2012)

---

Please read Jeff Moden's comments on pg 5 of this thread. Seems there is a difference of opinion on where in, exists and inner join. I will...