So, does it work as expected? 😉

Are you using a Data Conversion task? It seems as if you're trying to cast character data to a numeric data type, and there illegal values in the source.

Did you post the entire expression? The inequality test at the end does not seem to fit.

Anyway, here's an example you could try:

case

when[StudentStatus] <> 'Active'

then

case

when[EnrollmentLDA] Is Null

then'N'

else''

else''

end

What has changed on your machine? What account is the SQL Server service running under?

I'm not sure what you mean with "adding" a database. Attaching, on the other hand, is...

I think you'd be much better off asking this question in english. 🙂

Is the workbook already open? Also, check Task Manager for excel.exe if you've closed the application but you still get the error.

Does the SQL Server service account have appropriate permissions...

Please, explain the mapping between the XML nodes and the destination table columns.

Also take a look at this simple example:

declare@xxml

set@x = N'<persons>

<person>

<name>Phil</name>

<age>45</age>

</person>

<person>

<name>Jim</name>

<age>47</age>

</person>

<person>

<name>Verne</name>

<age>34</age>

</person>

</persons>'

selectPersons.Person.query('name').value('.', 'varchar(32)') as PersonName

,Persons.Person.query('age').value('.', 'int') as PersonAge

from@x.nodes

('

/persons/person

') Persons (Person)

Why? Can't you do that in the client application?

Have you tried googling "cross-tab query"?

So, are remote connections allowed on the instance? You should check that in SQL Server Surface Area Configuration: under Database Engine/Remote Connections. If you're connecting remotely (e.g. through TCP/IP) you...

No, "ARG" does not represent any of those expressions.

But what are your actual business requirements?

Glen (8/28/2008)

---

CurrentLevelXID is of the varchar type. You have to use single quotes in WHERE condition. Otherwise, something like (CurrentLevelXID = 70 AND 1=0) will return TRUE.

Try to debug...

Please, explain your actual business requirements in more detail. At least show us the expected result.

I suggest you read these two articles on dynamic SQL by Erland Sommarskog:

http://www.sommarskog.se/dynamic_sql.html

http://www.sommarskog.se/dyn-search.html

In fact, I think you should read all of Erland's articles, but you should...

Look up the BCP utility in Books Online.

However, IMHO a much better option would be to design a client application to save the data to a file. This would give...

Please, post the entire query.

From what I could understand from your post you could use a subquery or a derived table.

E.g.:

selectC = derived_table_B.B + derived_table_B.A

from(

selectB = derived_table_A.A + 1

,derived_table_A.A as...