Shiva,

Try the Microsoft website... I'm sure they have oodles of SSIS propaganda there...

Ok... was just making sure. You should have no problems with the temp tables.

No... you don't need anything that complicated. Looky here...

[font="Courier New"]SELECT CAST('Jan 2008' AS DATETIME)

------------------------------------------------------

2008-01-01 00:00:00.000[/font]

So, the only thing you need to do is change the backslash to a...

Ummmm..... heh... What's that highlighted in red????

SELECT

ph.ProductId

,ph.CLientID

, ph.PolicyType

FROM

PolicyHeaders ph

INNER JOIN Products pr

ON...

Ken... the OP actually wants to know what the algorithym is for the CheckSum function.

Jacob Luebbers (3/6/2008)

---

Interesting Jeff - just compared your test query (1m rows) with slightly modified version that CREATEs #MyHead first and INSERTs into it (both running in TempDB). This is...

Nisha, 2000 rows is nothing. Use Select/Into. Look at my previous post with the test code. Select/Into will load 2000 rows in less than 15 milliseconds. ...

Why would you want to create, compile, register, and attach a CLR to do the same thing that was just done in T-SQL?

I agree.... the Dynamic SQL will frequently perform better because it snuffs any chance of parameter sniffing and forces a recompile so you're always using a good execution plan... For...

Yes, but it will take longer... you can do it with a Tally table and a join on the backslashes using SUBSTRING. I've already tried it (damn... should have...

Heh... I can tell you which one is the only one that works 100% of the time...

http://blog.pengoworks.com/index.cfm/2008/2/15/The-only-valid-measurement-of-code-quality-WTFsminute

:hehe::P:D:);)

Heh... Hour or so? Like I said previously, I've used this method to do 5.1 million rows in about 3 minutes. I'm sure there's a faster method, but...

Heh... Daniel, unless you're wearing a porkchop around your neck, everyone is welcome in the "lions pit". Nice code...

Sharon Matyk (1/3/2008)

---

I needed to get a cumulative running balance column in a table. So I used a cursor. I'm not very advanced but it seemed like the...

CRUD... for some reason, this thread will no longer allow me to add a reply... in fact, it keeps overwritting THIS message when I try and the previous message has...