Does this add MyProc to the MyRole as well ???

MyRole is an existing role and not a new role !

I be going with logic like this,

- It only runs once a day via a JOB

- Let me know if you can make run faster

DECLARE @CurrTime DATETIME

DECLARE @ExpireDate DATETIME

DECLARE...

Thanks for viewing..

BUT how do I take the OUTPUT ( data in the jpeg) by row and execute the two aspnetdb stored proceedures for each row.

How does Cross Apply work...

Thanks:-)

So what does one do to manage a database size.

Back ups sure..

Doesnt a SQL server need maintenance after records have been deleted ?

I think I got it right...

.."As we've seen on dozens of posts, an XML splitter would not have performed so well."..

Jeff you have seen the yahoo .csv link I posted in this thread.

I too investigated...

Cheers, that did it !:-)

jeff or anyone another question

SQL Server Execution Times: CPU time = 0 ms, elapsed time = 3 ms.

SQL Server Execution Times: CPU time = 437...

Jeff,

All works fine: And Fast !

I will keep your name on my list when I need to spend $$$ on my project .

Minutes have gone down to seconds !!:-):-D:-P;-):w00t::cool::hehe:

Wow that took 21 sec on my machine.

Thanks Jeff. Will study this code!

I cant use BULK Insert as the client is asp.net site hosted on a shared server and dont allow CLR and it a pain to do a webclient pull then...

Thanks for taking the time to look at this.

But I dont understand your advice.

What code changes do I make to fnDelimitedSplit to make it work ( hopefully in a few...

Thanks Jeff, Speed much improved !!

:-):-D:-):-D

Jeff,

Thanks

Yes this table could be 300,000 records, and I need speed to read.

So you say

1) have identity field like ID with Auto Identity: clustered

2) Make Symbol and Date a...