rocky_498 (10/29/2013)

---

Hi Guys,

Need help.. Here is my sample data

LAT|BOX|5290113661|BP9744524|PHY|JAI|GREWAL|1|BI|Vacc Bill|MED|191.2||SHI||20131015|50242006001|||||6|116820411||

LAT|BARDI|TAMMY|20020 44th|PHY|MARK|MORADI|BI|Vacc Bill|MED|183.0||SHI||20131016|50242006001|||||6|116899590||

LAT|ARRE|SONIA|344 RICH|PHY|IAN|HANT|1|BI|Vacc Bill|MED|153||SHI||20131016|50242006|||||3|116786607|

AND I want to be my out put in Flat file like this.

LAT|BOX|5290113661|BP9744524|

PHY|JAI|GREWAL|1|

BI|Vaccine Bill|

MED|191.2||

SHI||20131015|50242006001|||||6|116820411||

LAT|BARDI|TAMMY|20020 44th Ave|

PHY|MARK|MORADI|

BI|Vaccine...

Hi and welcome to the forums. In order to help we will need a few things:

1. Sample DDL in the form of CREATE TABLE statements

2. Sample data in the form...

shornick (10/29/2013)

---

"from a given field in a table i want to retrieve only those rows doesnt contain any upper case letter in any position."

Why not just do something simple like:

select...

Ed Wagner (10/29/2013)

---

Sean Lange (10/29/2013)

---

Chad Crawford (10/29/2013)

---

We use the scale of 1-10 to help give us an idea of how tough to start the interview questions, but we usually...

Chad Crawford (10/29/2013)

---

We use the scale of 1-10 to help give us an idea of how tough to start the interview questions, but we usually give the scaling factor...

Yeah that sounds like they need some serious help. You are absolutely right that adding NOLOCK to every query is dealing with the symptom not the cause. The real issue...

I agree with Keith. Crosstabs are generally more efficient than PIVOT. Take a look in my signature at the two articles about cross tabs.

You're welcome. Glad that worked for you and thanks for letting me know.

So this is DB2? I have no idea how this would work. I worked with DB2 once about 15 years ago. I think that timestamp is the same as datetime....

dndaughtery (10/28/2013)

---

what I want to do is based on the value from ProjectedTimeTill100PercentSellThrough, in each record I want to update the bit fields.

For example if I have the following row:

ProjectedTimeTill100PercentSellThrough...

In order to help we will need a few things:

1. Sample DDL in the form of CREATE TABLE statements

2. Sample data in the form of INSERT INTO statements

3. Expected results...

itsjustme (10/28/2013)

---

Thank you all for the reply,

My problem is that

1) tableA.IP1 has Nulls

2) TableA has more data that's hard for me to compare based on just one column...

Meanwhile I would recommend that you use ANSI-92 style joins instead of the older ANSI-89 style. The end result is exactly the same thing but it is a bit easier...

When you execute dynamic sql the scope is only for the current commands. The context of the executing code does not change. In other words, your statements are executing but...

dndaughtery (10/28/2013)

---

I have the following update statement where based on the value for the column in the case statement check per record to update the columns acoringly. I think you...