Using OPENROWSET is a bad idea when combined with an update (if at all possible). You should import the values from the text file into a table. To do that,...

Does this article work for you?

http://www.sqlservercentral.com/articles/set-based+loop/127670/

I could give you an answer, but I already wrote the whole explanation in there. 😀

donstarter (2/24/2016)

---

Hi all,

I am having an issue with using distinct on one single column in a table and getting multiple result rows for a string "looking" the same. When I...

Check the following articles to learn how to use cross tabs, which will get you exactly what you need.

http://www.sqlservercentral.com/articles/T-SQL/63681/

This is SQL Server based code and it's not guaranteed to work...

Is using IE Tab an option?

http://www.ietab.net/

It allows to run Internet Explorer inside Chrome.

Us defaults, so collation is case insensitive.

Sergiy,

Could you share the details of the version you're using? On my laptop with 2012 SP1, I get 3 rows when running the entire script at once.

Unless you used...

You didn't format the first row. Format will convert the values into strings.

I don't remember if it's possible to assign a format to the parameter available values, to use a...

Use a numbers table or build one on the fly or adjust as necessary.

SELECT DATEADD(s,-1,DATEADD(mm, DATEDIFF(m,0,GETDATE())-n,0))...

Try to understand how this routines work and you'll get the correct formula for your problem.

http://www.sqlservercentral.com/blogs/lynnpettis/2009/03/25/some-common-date-routines/

I'll explain the first one and you can get the rest.

select dateadd(dd, datediff(dd, 0, @ThisDate),...

Alan.B (2/23/2016)

---

I don't know if anyone is aware of this but I noticed Dwain Camps hadn't posted anything in awhile so I checked his blog (dwaincsql.com), simple-talk, twitter, linkedin... then...

As long as you use the certification as a way to learn, it could help you. However, most people won't hire you just by having a certification, you need to...

jbrown414 (2/23/2016)

---

Thanks for your response Grant. At what point do you feel experience outweighs the need for a certification? I'm coming up on 7 years as being a...

Sean Lange (2/23/2016)

---

Ed Wagner (2/23/2016)

---

That is interesting,...

The error seems to be the CAST() functions. Use TRUNC() as you did on your column list.

For SQL Server, you can't use UNIQUE or TRUNC(), for Oracle your can't use...