Easy enough! 🙂 Use the wizard to script what you want, or script the entire database and then remove what you don't need. You may want to add in sp_change_users_login...

SELECT HeaderID, SerialNumber, DateTested, OperatorID, StationID,

CASE

WHEN CONVERT(VARCHAR(8),DateTested,108) >= '07:01:00' AND CONVERT(VARCHAR(8),DateTested,108) < '16:31:00' THEN '1st Shift'

WHEN CONVERT(VARCHAR(8),DateTested,108) >= '01:11:00' AND CONVERT(VARCHAR(8),DateTested,108) < '07:01:00' THEN '3rd Shift'

ELSE '2nd Shift'

END AS Shift

FROM...

ChrisM@home (10/17/2011)

---

ekant_alone (10/17/2011)

---

I have a table enployee and a column gender.

The possible values in the table are 'm' or 'f'

In this puzzle i need to swap m with f and...

ekant_alone (10/17/2011)

---

I have a table enployee and a column gender.

The possible values in the table are 'm' or 'f'

In this puzzle i need to swap m with f and f...

I do not recommend...

We use transactional replication with updateable subscriptions. Fundamentally, it is a bi-directional replication.

Thanks,

Jared

Mirroring is not bi-directional, it is only 1 way.

Thanks,

Jared

You say that there will not be many changes... Why not use transactional replication?

Jared

What you are asking for is called pseudocode. Here is one link, but if you google it you will find many examples and theory.

http://www.unf.edu/~broggio/cop2221/2221pseu.htm

Thanks,

Jared

How exactly are you accessing and parsing this data? Are you using a query, and if so can you post it please? In the meantime, you could try running a...

I love this one 🙂

Jared

I would just delete them from your article and then reinitialize, if you can.

Jared

jcrawf02 (10/17/2011)

---

jared-709193 (10/17/2011)

---

Keep in mind that this will still not get you what you are looking for, I think. The procedure will still compile and will be created, THEN you...

Lynn Pettis (10/17/2011)

---

Select COUNT(SerialNumber),

CASE WHEN DATEPART(hour,(DateTested)) between 7 AND 16 THEN '1st SHIFT'

WHEN DATEPART(hour,(DateTested)) between 16 AND 1 THEN '2nd SHIFT'

WHEN DATEPART(hour,(DateTested)) between 1 AND 7 THEN '3rd SHIFT'

END

FROM...

Keep in mind that this will still not get you what you are looking for, I think. The procedure will still compile and will be created, THEN you will execute...