Duplicate post, post answers here.

komal145 (6/22/2012)

---

Hi friends ,

I need to Delete from table with conditions :

Example of my query!!!

Delete from TAble A where Input_type like 'COLD%' and Input_type like 'ChartMover%'

when...

Sample data and expected results. I have nothing to run your code against to test or to determine what your problem(s) may be with regard to actual results.

What you...

I have to go with Sean's shot in the dark since you haven't provided sample data or expected results with a given example of the parameters that may be passed...

I have nothing against certifications, I'd like to get certified myself. My problem with them is more with those who have them and have demonstrated to me that the...

jerome.morris (6/22/2012)

---

this.PartsUsedTBTableAdapter.FillBy10(this.SLADBDataSet.PartsUsedTB, dateTimePicker1.Value.Date,

...

As I look at the code more, it would help if you posted the DDL (CREATE TABLE statement) for the table, some sample data for the table, and the expected...

Sorry, but your code is confusing. What are you trying to accomplish and what are the parameters being passed?

Sean Lange (6/22/2012)

---

I certainly hope you don't feel insulted!!! It...

Sean Lange (6/22/2012)

---

I certainly hope you don't feel insulted!!! It...

Sean Lange (6/22/2012)

---

That my friend is a might fine question. 😛 Sometimes the keyboard starts before the brain kicks in.

Not only is your solution...

jeff.mason (6/22/2012)

---

I still have seen nothing to convince me that regulatory requirements like HIPAA, SOX, FDA validation, et al can be safely supported in an external cloud. Internal, maybe,...

Also, my solution is based on your original post, If we were in june, I want to show June,July, August . This means the last record won't be...

Couple of minor issues with your code. I suggest you test your code in a sandbox database before posting.

Here is one solution:

CREATE TABLE #mytable

( ID INT PRIMARY KEY...

I'm trying to decide if I should be happy or insulted, I mean really, Lynndrome? 😉 :w00t: 😛