Here is a link to a pretty good primer article about CTEs and what they can be...

If you don't want to do any work I would suggest you hire a consultant.

You haven't...

Just to make sure you understand ... if you are getting a value from an XML column in a SQL Server table, your application is going to need to handle...

If you provide data in the correct format (see the link in my signature) I could show you how to write the query to do that, but based on how...

It's still not exactly clear what you want (and you didn't follow the instruction in the link in my signature.) I don't see what the "Choice" has to do...

An "XML File" does not equal a "SQL table" so I'm not sure what you mean. Your application can retrieve a list of values from a SQL Server and...

Alvin Ramard (8/4/2010)

---

The US hasn't adopted the Metric system yet, so there's very little chance we'll see the date/time system go metric, well, any further than it already is.

Decade, century,...

It's much easier to help you if you provide table definitions, sample data and expected output. See the link in my signature below.

changbluesky (8/3/2010)

---

i use the LEN() function to calculate a string length in sql server 2008 management studio.

select LEN('ESPRINET IBÉRICA S.L.U.')

the result : 23

But actually,the length of the string is 24...

In the very first post the OP said

First Scenario, BAN = 1, here there is no Change...

You're not entirely clear about what you're wanting to be dynamic, but if you want to set tables that you're going to query or columns you're going to return based...

Take a look at this article[/url] (or many others out there) that describe how to use FOR XML PATH to concatenate values in a single column.

This is slow but it works ...

select sasm.*

from sys.all_sql_modules sasm

JOIN sys.objects so

ON so.object_id = sasm.object_id

where (replace(sasm.definition, ' ', '') like '%exec(%'

or replace(sasm.definition, ' ', '') like '%execute(%')

and so.is_ms_shipped = 0

pommguest4 (8/3/2010)

---

when I tried to explain to my other fellow workers, they cant seem to get it at all. They think that this cant be achieved through Sql at all...

Ron,

I was thinking about this method too, but if the issue is on the app side it's quite possible that either the parameters' datatypes cannot be changed (because they're set...