So how do I check my index type ? ( ie I have a combo field primary key), if its not there, how do I cluster this index ???

REMOVED

Thanks..

I thought a primary key was a clustered index ??

Is it not ??

if not whats the code for that type of index on a field combo ??

Thanks for your helpm, bye!

Lynn,

I have found what I need here:

http://www.markerstudio.com/miscellaneous/2007/12/using-clr-to-access-net-functions-in-sql-server-example-to-execute-aspx-pages-from-asp/

How could you be possible be confused.

My first post.

I wish to put data into a table I defined.

Then I wish to read data out of the table.

I wish to store...

Lynn,

Can you do this in TSQL

Copy this URL into browser address bar:

http://ichart.finance.yahoo.com/table.csv?s=MSFT&a=01&b=01&c=2010&d=ignore&e=&ignore&f=ignore&g=d&ignore=.csv

The result is a CSV file with: Date, O,H,L,C,V,AdjC records.

I read this into a vb.net asp.net...

Thanks Lynn, I should be ok now. Will work on it tomorrow.:-):-):-)

WOW thanks, I have the function split.

HOW can I get this result.

DECLARE @Symbol VARCHAR(20)

DECLARE @CreatedON DATETIME

SET @Symbol ='MSFT'

SET @CreatedON = getutcdate()

So I get a final result set like this...

Well its one table function that can handle one string at a time, no matter the number of records in the string

NOTE: This is one record..and it has one...

The data is not imported or anything like that, it will be passed down from the client via store procedure parameter.

So if you can work with the @str1 and @str2...

More errors in code ..

My orginal table was like this:

CREATE TABLE [dbo].[DIM_OHLC_Xml](

[Symbol] [varchar](50) NOT NULL,

...

I get error with this code..Invalid object name 'record'.

Its part of the insert code that was provided. The where clause is important to ensure a record is not load...

I wish to hold a data dump

for 1000 symbols with 1000's of records

In one table row.

.."Is the symbol column supposed to be IN the xml snippet, or - outside of the XMl, in the outer table that holds the XML column? It changes how you...