If you are inserting into a table and creating on the fly then I assume you are already using dynamic sql or have an if statement for each merchant.

I agree with...

I do not know PHP but if you need a sql query then

select c.isnullable

from sysobjects o

inner join syscolumns c

on c.[id] = o.[id]

and c.[name] = 'column'

where...

Still thinking about this but all I could up with so far is to put all the dates in order (start & end), work out the date segments and then match...

Use

ISNUMERIC(ITEMNO)  =  1

to test for numbers only

use

PATINDEX('%[A-Z]%',ITEMNO)

to determine the location of alpha

if the alpha is always at the end then

SELECT CAST(CASE WHEN ISNUMERIC(ITEMNO) = 1

THEN ITEMNO

ELSE LEFT(ITEMNO,LEN(ITEMNO)-1)

END...

Do you mean this

CREATE TABLE #temp (col1 int, col2 int, ...)

INSERT INTO #temp

EXECUTE procname

INSERT INTO #temp

EXECUTE anotherproc

INSERT INTO [maintable]

SELECT col1, col2, ...

FROM #temp...

Steve,

It certainly was not meant as an insult and I would never intentionally post such things on a forum. If my attempt at humour did upset you then I apologise.

I must...

A lot will depend on what indexes you have (if any) and also what is missing in the 'select id from...'. What I do is to break down your query...

Sorry that it did not help, since you query used whole hours for duration I continued that in my solution

Did not realise...

I did read somewhere in all that Microsoft bumph online that Microsoft's solution for this type of problem is to split the table into smaller tables and join using a...

You could EM to script all the tables for each SQL2K database which will give you column collations which you can then analyze.

Try this

Select * from myTable WHERE CHARINDEX(',' + m_NAME + ',' , ',' + @codeList + ',') > 0

as I said before your query

Select col_a

from some_table

where Date_col = isnull((select date from tableA where id=host_id()),getdate())

will always invoke a table or index scan

If [tableA] has [id] as a...

Eagles may soar in the clouds, but weasels never get sucked into jet engines.

And Steve,

It is difficult to...

Jeff's answer should work, eg

bcp "select 'abcd'+CHAR(13)+CHAR(10)+'efgh'" queryout test.txt -S servername -T -c

will produce a text file with

abcd

efgh