one more comment

as of today forums are SLLLLLOOOOOOWWWWW

if you dont want to write any code. Try to use 2 Fields ( one for the date an the other for the time) then on the front end make...

maybe I was not clear YOU DON'T HAVE TO USE RECURSION.

I am including Three examples of what I mean.

http://support.microsoft.com/default.aspx?scid=kb;en-us;q248915

http://www.yafla.com/papers/sqlhierarchies/sqlhierarchies.htm

http://www.sqlmag.com/Articles/Index.cfm?ArticleID=16123

and those are NOT all the choices

HTH

Can you define SAVE?

will it work? == Sure!

will it be supported in the next version ? == probably but Is not warratied

will it be a good idea for an application?...

When you use "(" in the FROM clause, you HAVE to ALIAS the inline view!!

in other words Select ,,,, FROM (...) ALIASNAME

your post is missing the alias

I haven't check...

you have two options here:

1 if you can limit the number of rows beforehand this is the easiest to maintain approach.

SELECT 

 Grade,

 TestID, 

Permnum,

QID,

CA,

SA,

QuestionNumber,

CASE...

sorry for the Delay (I was busy )

1.

sp_MSforeach... procedures are undocummented in BOL but you can always check their code in the master db!!

2 the '?' is...

Check your syntax

 

Update T Set intIndex = Q.rank

FROM

(

select   baseT.idsItem 

, baseT.idsParent 

, (select Count(*)    

   from T...

what I am talking about is that you can CREATE the FORMAT file not the DATA file every time before you import. The Format file tells bcp what are the...

If it works on QA without quotations and MSDTC is running remotely it has to work in QA with quotations!!

have you tried exec (@str)

instead of sp_executesql

 



select   

  baseT.idsItem 

, baseT.idsParent 

, (select Count(*) 

   from T T1 

   where 

baseT.idsParent = T1.idsParent...

recursion is limited to 32 levels if you need more than that do a quick search for handling hierarchies on sql mag and it should give you some pointers !!

...

try:

 



CREATE TABLE #T(Cat nvarchar(128))



INSERT INTO 

    #T

EXEC sp_MSForeachdb N'use ? 

SELECT  

     Table_Catalog 

FROM

   ...

are you sure MSDTC is running on 'CUSTOMERSQL' Server?