Ok thanks you answered 1,2,4 for me,thanks.:-D

But you missed 3..

Once I have the @XML data in my XML field of my table.

I need to pull the data out so I...

Sure whatever works..

So I just do

INSERT INTO dbo.DIM_OHLC_Xml (Symbol,CreatedOn,OHLC_XML)

SELECT

@symbol AS Symbol,

@CurrDate AS Currdate,

...

Thanks..just what I need.

There is a method to my madness...:-)

So is this the best method...after all the chatter..:cool:

DECLARE @iDate DATETIME,

@val INT

SET @iDate = '12/31/2010 01:25:35'

...

Whats with the ';' in the SQL statement

'2000-01-01');

???

I dont use ';' in SQL 2005, should I ??

Thanks

You sent me on correct highway thanks...:-)

This is the code the will work for me..

DECLARE @iDate DATETIME,

@val INT

SET @iDate =...

Thanks

Wow.. I better retreat.:w00t:

Ok so I think I will change the field to DATETIME.

So how can i get this DATETIME field into a VARCHAR that looks like MM/dd/yyy

With out the...

SSCrazy,

Yes I have now found how to run a .bak

BUt I had three questions, could you answer the three for me, thanks

Ok I just wanted to see how to change it to SEEK but true, it may not be required for practical use.

Are you pulling my legg...???

Sure I have one record of TEST data in the table.

But imaging 1000 records in the table and I want to get the top 120...

I am after a execution performance that uses all SEEK scans for this stored procedure ( with test code post on this thread)..

ALTER PROCEDURE [dbo].[procTEST]

AS

BEGIN

SELECT TOP 120 A.[Page]

...

.."And maintain a clustered index seek? "..

What does this mean??? Doesnt help me !:-)

thanks..

Interesting...

HOW do I a SELECT TOP 120 * FROM <table> records on the BlogUserID auto field

????