HashBytes isn't guaranteed to be unique, so it's LIKELY they're the same (as in really likely). But you'd still want to double-check anyway (some byte by byte compare once...

Sounds to me like a straight application of a running total... It is just that you keep the running total in the variable, and update some different column.

Take a...

Corollary to rule #1: Try not to be that operator....:D

I've done something like that with DTS a few times. For better or worse - I found it easier to have DTS handle the importing of a single file,...

Michael Earl (6/17/2008)

---

You could write a CLR stored procedure.

If you do this, I think you may need to enable unsafe assemblies - I don't think the system IO namespace is...

jeffrey yao (6/17/2008)

---

I think we should not under-estimate the value of a well-designed test. IMHO, these days, lots of questions in a MCP test are scenario-based, it is not about...

Jason - have you considered a CLR function? You could run a split on BOTH ^ and (space), and then put it back together from there, or a regex...

You should definitely look at parameter sniffing like has been suggested. The other suggestions are also excellent for overall tuning, but parameter sniffing helps explain why the SP makes...

You may find that it simply has to do with certain columns not automatically lining up with the "correct" destination. Without specifying the column names, you're gambling a little...

Easy - put the Tally table in another database not so tightly managed. you don't HAVE to put it in the database that changes all of the time. ...

Tell it you want to put it in tempdb...should do the trick. Then you can figure out where to put the stuff.

The other option might just be the import/export...

This should get you there.

declare @amt decimal(18,4)

set @amt=1.277;

select @amt-

(cast(@amt*10000 as int)%500*1.0/10000)

...

If you have the data in Access, why not just load it into SQL Server from there? It seems to me to take a rather large step backwards to...

bitbucket (6/17/2008)

---

Developer edition available from Amazon.com

http://www.amazon.com/s/ref=nb_ss_gw?url=search-alias%3Daps&field-keywords=sQL+Server+developer+edition&x=18&y=18

for 44.95 and will ship next day if you elect to do so.

Did same and found it easy to install, once installed go to...

I know. It also doesn't help that the OP really did have 2005. I was already started...