Or maybe something like this:

ORDER BY ProjID, NULLIF(CategName, 'OWN STAFF TEAM')

According to Gail's last post, it won't.

Freakazoid!

Maybe something like this?

CREATE TABLE #Test(

ErrorString varchar(400)

);

INSERT INTO #Test VALUES('Login failed for user ''User1''. Reason: Failed to open the explicitly specified database. [CLIENT: 11.11.11.11]');

SELECT *,

...

sharonsql2013 (3/4/2016)

---

I am trying to get a substring of characters but need to go from right

Example 9.0.0832.1032 need to get the 32 (one after 08).

10.01.0832.1064 need to get...

Absolutely no variable declarations or multiple instructions. All variables should be defined before the query.

You can have queries inside queries. These are called subqueries and are a great tool. However,...

oneteabag (3/4/2016)

---

Nice Thoughts newbie, I got the logging part but wasn't sure if I stay away from SSIS how I would automate this process.? Right now it is just a...

What kind...

Gary Varga (3/4/2016)

---

Steve Jones - SSC Editor (3/4/2016)

---

Gary Varga (3/4/2016)

---

I have still yet to come across a requirement that would benefit from the use of a tally table. I read...

Jeff Moden (3/4/2016)

---

bismsit.29 (3/4/2016)

---

sure john i will let you know all in detail. i would look forward for your suggestion in this.

this is a new table which will get offer...

simon.jones.p (3/4/2016)

---

Hello, I know your post is a bit old so I'm working with a 'better late than never' approach to this.

Passwords can now be extracted. Anyone who arrives...

SmackMule (3/3/2016)

---

This is beautiful! Exactly what I wanted and so much to follow up on and learn. Thank you *very* much for the info and example. I implemented per your...

Hey, I used the Windows calculator. The beep indicated...

I've managed to solve the first 3 issues using format files. The fourth issue can be solved by cleaning the data in a staging table using T-SQL (REPLACE(ColumnName, '""', '"')).

For...

GeoGym (3/3/2016)

---

Lynn,

I read the article on the tally tables and also worked though all of the examples. I do understand how tally tables are much faster than creating loops. However,...