lisa.ogle (9/5/2013)

---

If you looked at my earlier post- I posted my query I posted the error message and i attached a sample of my data on my last post to...

Not a lot of details to work with here.

Maybe something like this?

select *

from SomeTable

where FreeField1 is not null

or FreeField2 is not null

...

I am not really sure what you are looking...

Give us the details to work with and we can help. I am glad David was...

Paresh MD (9/5/2013)

---

Hi,

I got a scenario where I am using Windows Application.

I want to create a SQL Server User satisfying the password policy. I have couple of questions related to...

meghna.bhargav (9/5/2013)

---

I have an issue where I need to count the cumulative total column wise effectively and could not get a thought of it, I have posted on SQL server...

Duplicate post. Direct replies here.

http://www.sqlservercentral.com/Forums/Topic1491850-391-1.aspx

Nope. It was in Access, FoxPro, VB but not in sql...

OK we need to take a step back here. I still don't have...

This thread has now moved to a new one...not sure why.

http://www.sqlservercentral.com/Forums/Topic1491832-1292-1.aspx

IIF is not valid syntax for SQL.

--begin edit--

IIF was added to SQL 2012 :angry:

--end edit--

The first statement would be something like this:

SELECT case Field1 when NULL then 'NULL' else 'NOT...

OK. So what is the question?

I can remember a couple of times fielding very bizarre questions. The first one was a small consulting company where I had been referred by a friend of mine who...

lisa.ogle (9/5/2013)

---

I still cannot get it to work I used this I put the ; after my select statement before your with statement and still get an error. I...

Thanks for trying to post ddl and sample data. It is generally preferred to post insert statements to make it easier. Also you should post all of the tables involved....

Hi and welcome to the forums. Don't worry I don't bite and usually gentle. 😉

Let me see if I understand what you are looking for. It sounds like what you...