But the user has permission for select, insert and update on the table?. Is that not enough to get the default values?

Anyway, I need to know a way for a...

The file is a fixed width fields. Each field is of length "1". For example, one line of the data file is like this:

A CDE

Notice the space between the values...

Thanks, Jeff!. You got it exactly right. The logic was to get the running total.

I was wondering how CTE's (Common Tabl expressions) in SQL Server 2005 will be of more...

The URL itself is the data provider. When you open the URL in Internet Explorer, you get an XML data.

If I have to do it manually, I will opening...

Is there a TSQL way to find out why a permission is denied??..

For example, how to find out why the user is deined the "CREATE TABLE" permission.. the source...

No.. I even tried with a NEW login and it does the same.. Please help!!

Thanks, I tried this earlier but I get this error:

Msg 4623, Level 16, State 1, Line 1

The all permission has been deprecated and is not available for this class of...

Found it, here it is:

select distinct

p.[object_id],

TbName = OBJECT_NAME(p.[object_id]),

index_name = i.[name],

index_type_desc = i.type_desc,

partition_scheme =...

I was just providing you a hint.. You may want to :

CASE WHEN (SUM(CONVERT(NUMERIC,CRC.Contact))))*100),0) <> 0.0 THENISNULL(CONVERT(DECIMAL(5,2),(SUM(CONVERT(NUMERIC,CRC.Success))/(SUM(CONVERT(NUMERIC,CRC.Contact))))*100),0) ELSE 0.0 END As SPC

An auto generated number something like the node "position()" is what I am looking for to uniquely idenitfy the node value..

The reason I need is, after getting the node...

TRY PROBABLY THIS:?

CASE WHEN (SUM(CONVERT(NUMERIC,CRC.Contact))))*100),0) > 0.0 THENISNULL(CONVERT(DECIMAL(5,2),(SUM(CONVERT(NUMERIC,CRC.Success))/(SUM(CONVERT(NUMERIC,CRC.Contact))))*100),0) ELSE 0.0 END As SPC

Any way to get the attribute values also in the same way.. This is my XML

<ROWS Suspended="false" ID="2" Platform_Id="7" >

<COL1>1</COL1>

<COL2>2</COL2>

<COL3>3</COL3>

</ROWS>

and

Select r.value('local-name(.)','varchar(20)') as Name,

r.value('(text())[1]','varchar(100)')...

Found it, here you go:

Select r.value('local-name(.)','varchar(20)') as Name,

r.value('(text())[1]','varchar(100)') as Value

From @doc2.nodes('//*') as x(r)

Thanks,

Ganesh

The nodes function appears to return the data only as a single row with Col1, Col2 as column names as below.

For example,

declare @doc2 xml

SET @doc2 = '

<ROWS>

<COL1>1</COL1>

<COL2>2</COL2>

<COL3>3</COL3>

</ROWS>'

SELECT

tab.col.value('COL1[1]','VARCHAR(20)')AS...

Hello,

Thanks for the reply. I guess you are suggesting to look for the "x64" string in the @@version results. Is there a better way other than this to determine...