In order to help we will need a few things:

1. Sample DDL in the form of CREATE TABLE statements

2. Sample data in the form of INSERT INTO statements

3. Expected results...

What about this?

This will likely throw the same error

select *

from

where column1 = 1

How about:

select *

from

where IsNumeric(Column1) = 0

duplicate post. direct replies here. http://www.sqlservercentral.com/Forums/Topic1465263-391-1.aspx

tschary (6/18/2013)

---

Hi,

i need to work on integration of key management.As per my knowledge we need use EKM and need to manage keys.for that we need additional hardware or appliance.

please help...

What does this mean?

What is transport encoding? Are you talking about encrypting your datastream as it travels...

Karan Shah (6/19/2013)

---

Hi All,

I need to write a code in SQL Server 2008 in which I have 4 columns(First Name (2 columns) and Last Name (2 columns)).I have a 5th...

realvilla (6/19/2013)

---

I so appreciate your help and you have already gone way above and beyond the call of duty. I'll try the left joins and guy more experienced in...

realvilla (6/19/2013)

---

OK, I am set up now with rights on the database which is 2008. I run the following code and get 0 records. Notice the "select...

It was pretty much exactly the same as Cadavre's. He posted his while I was still typing. 😀

Pretty sparse on the details but I think that something like this should work:

((ROW_NUMBER() OVER (ORDER BY oddpages.id_num) - 1) / 8) + 1

SQLTestUser (6/18/2013)

---

THe select statement

Select C.CausativeID,F.Description,M.OverallPlan,S.Title, ST.Status

from Statement S left join Cause C on C.ID = S.ID

...

shashi_1409 (6/18/2013)

---

I would like to pass a column to a function, and have it unioned together with my other data in it's own row... for example given the data:

CommaColumn ...

Yes that is correct. Instead of getting the top we just...

The issue hear seems to be a language barrier....