Normally, that would solve my problem, but I can't create a function. Only temp objects. DBAs have the system locked down pretty tight, still arguing with them over whether they...

rbarryyoung (9/24/2008)

---

I think that you may have confused Sisyphus (eternally condemned to push a boulder up a hill) for Prometheus (bringer of fire/light/enlightenment to humanity). Mind you, I think...

thanks Lynn, I knew there had to be a better way. 🙂

Why does that make a difference though? converting from datetime to varchar is implicit; converting from varchar to datetime...

worth a shot, if we try to parse a string that doesn't exist, it's likely to give us trouble. Any chance you know how to populate those fields?

If not,...

I think your

UPDATE temp_ameriflex_detail

SET emp_doh = convert(char,emp_doh,112)

completes successfully because it's not changing to a date, just formatting varchar as char, which isn't really changing anything.

Try this and see...

ok, quick example -

'9/1/2008' has two slashes, and you know now that you can find the first slash by doing charindex('/',emp_doh,1) telling the Charindex() function to start at 1.

If...

Look up CHARINDEX in BOL, and replace the number in the Substring function with the position of your '/' plus one.

see http://www.sqlservercentral.com/articles/String+Manipulation/63604/ for some recent article/discussion on this.

😀

Right, if it's already datatype of varchar, you'll have to convert to a string to put anything in it.

I would suggest you add a column with a datatype...

I'm assuming...

themissnlink (9/24/2008)

---

I am having a similar issue with my date formats. I have an excel file I am importing from that is MM/DD/YYYY format and I import into the database...

Shah (9/23/2008)

---

hi,

i faced the same problem in past, when the ' (single quote) appear in a string...

vaioks (9/17/2008)

---

Hi,

I am trying to Import a flat file (delimited) into a SQL server table. the was created from a unility which is not too flexible. I have the date...

We just came across this question at work. While the USPS would be the 'authority' on US zip codes, whether it is correct for your business depends on how...

I'm not quite sure how you could assign a 'per row' cost, unless you were ignoring litigation costs associated with data loss (http://www.sqlservercentral.com/articles/Editorial/64241/). In the healthcare industry, we'd also have...

Agree with Quatrei.X, sample data would be better, but check this out too and see if it helps -

http://www.sqlservercentral.com/articles/Advanced+Querying/calculatingworkdays/1660/

Lots of questions when you start looking at workdays/hours/such, since holidays...