It appears you want to do the insert & update through a single query. You can't do that in SQL 2005. You will have to identify a logic to find...

It seems there should be a more efficient way to do this, but a crude form would be like:

declare @date datetime

declare @time datetime

set @date = getdate()

set @time = cast('01/01/2000 03:12:12.321'...

Just a suggestion. Each article at SSC has a link at the bottom saying "Join the discussion" where questions/views/suggestions specific to that article are discussed. I guess, it would be...

If you already have the C# library, why...

This variation to the question may have been a better teaser 🙂

I hate to admit, but I simply didn't know you can use HAVING without a Group By. 🙁

RAISERROR

http://msdn.microsoft.com/en-us/library/ms178592(SQL.90).aspx

Maybe there is a cleaner solution than I am proposing. From what I have you can base yours on below code to get rid of the nasty first empty value...

🙂

Yes, I tested it for DATETIME and it works.

asita (5/19/2010)

---

"," "CODE"," "," "," "," "," "," "," "," "," "," ","PAYABLE","UNITS"," "," " ;

"DMA","CY FOUN","AMERICANUN","AEN","ALF","ALF","FEB10","4","DRTV"," ",".00"," ","0.00","12.0","0.00","12.0" ;

"DMA","CY FOUN","AMERICANUN","APL","ALF","ALF","FEB10","4","DRTV"," ",".00"," ","0.00","10.0","0.00","10.0" ;

i got what i want for all...

Date lockoutFromDate = new GregorianCalendar(2010, (5-1)*3, 1).getTime()

Where are you getting these numbers from? Where are you going to write the SQL -- will it be an SP or a parameterized...

asita (5/18/2010)

---

...so now i have the whole cleaned data in a string variable how can i create a file with the string variable data

so that i can use that file...

Jeff Moden (5/18/2010)

---

Actually, ISDATE() is very sturdy. It wasn't designed to validate date formats... it was designed to determine if a string value COULD be converted to a DATE....

A twist on previous question agreed, but I do not agree with the choice of answers. It is a bit too vague to select that as an answer.

It appears what CozyRoc is suggesting is to modify the source file to make it a comma delimited file. I have never gone down that path so can't be much...