Okay, so what you are looking for is the following based on a the...

awcrestview (4/8/2014)

---

Hi,

I need to find all records for all 3 shifts in 1 day and the datediff below does not include the 1 hour before midnight (missing 1 hour for...

Abu Dina (4/8/2014)

---

I'm using Sybase for this

Sample data:

CREATE TABLE #SampleData (ID INT, Tran_Date DATETIME, Ref VARCHAR(10) NULL)

INSERT INTO #SampleData(ID, Tran_Date, Ref)

SELECT 1, '2013-01-15', NULL UNION ALL

SELECT 1, '2012-04-10', 'Kames'...

May I ask, as it doesn't appear to be obvious to me at any rate, what exactly are you looking for as a final result set? Can you show...

ScottPletcher (4/8/2014)

---

Jeff Moden (4/7/2014)

---

ScottPletcher (4/7/2014)

---

If you really want to use a single table, you could use a single smallint or int column with a bit assigned to each newsletter. ...

In addition to what Gail said, you have been around long enough...

The only solutions I can think of are these:

1) Air gap the backup file. Copy the backup file to an external hard drive from the source system and restore...

Jeff Moden (4/7/2014)

---

Lynn Pettis (4/7/2014)

---

I know what it is and I also know if you take the time to do things correctly that tools like IronSpeed are just as good...

Since we can't see what you see, hard to say. However, since sp_exectuesql is a synchronous call, I would be curious to know how another one can start executing...

dhananjay.nagarkar (4/7/2014)

---

Thanks much Lynn that really cool ti works .

but just for my understanding sake wanted to learn what does this line do - GHRMSContingentID like N'[A-Za-z0-9][0-9][0-9][0-9][0-9][0-9][0-9]%'

? in simple...

I know what it is and I also know if you take the time to do things correctly that tools like IronSpeed are just as good for development as the...

Database using full recovery model, full backup + transaction log backups at scheduled intervals.

Almost a four year old thread.

Luis Cazares (4/7/2014)

---

Lynn Pettis (4/7/2014)

---

First, I have never used IronSpeed, but I take exception to you blaming the tool. It comes down to the person using the tool not...

First, I have never used IronSpeed, but I take exception to you blaming the tool. It comes down to the person using the tool not knowing how to protect...