A quick Question in SQL 2008 doesnt the OPTION(RECOMPILE) on a query force that query to recompile its plan based on the values thus eliminating the need for Parameter Sniffing?

Is...

Binary checksums are ok but they have thier limitations, asan Example if a Decimal number changes by a factor of 10m, eg 100.00 to 10.00 you will get the same...

I'm not a Reg ex specialist either, and normally only resort to using them when the need is desperate.

It is possbible but needs to use a regular expresion, so you could code the the select as follows

select #temp.alunos_id, #groups.ID

from #temp

left join...

Looking at the Data you have a Leading Space infront of all numbers but that isnt replicated on the Select.

so when looking for 565, you are trying to match ',565,'...

kramaswamy (1/23/2012)

---

One thing to be careful about whenever you're using dynamic SQL in SSIS - if you're ever thinking of putting that data into a destination table or file through...

sixthzenz (1/23/2012)

---

Do these dynamically built sql statements get stored in the execution plan? My understanding is that such statements do not, in which case optimal performance isn't attained. I guess...

A very nice article, though isnt there a better way of building the Column lists than using an XML?

Could you not just do this

Declare @var varchar(2000) = ''

Select @var=@var+','+COLUMN_NAME

from...

Sorry its my fault I type things as I'm thinking, and a common fault of mine is during table creation scripts where I think the word AS and then type...

This should work

CREATE TABLE #temp (

Item As...

Any chance you could provide the code for the temp table method you're suggestion as I'm always looking for alternatives to existing methods.

Performace Guard (Shehap) (10/7/2011)

---

For such types of query , it could be proceeded like below ..

However if the DIffs table contain quite much data entity ,then just we would dispense...

I agree, though I dont think you can do that as its not just the rows that have values against them, you have to sum up all the previous ones.

Edit...

The code sample in this link should help. http://www.codeproject.com/KB/database/splitparameterstring.aspx

The only difference is that instead of using a comma seperated list you use a # delimiter.

One minor tweak could be...

something like this should work, it may need some twekaing for large data sets.

CREATE Table #vals (dt DateTime, val int)

Create table #diff (dt DateTime, diff Int)

Insert into #vals

VALUES ('1-JAN-2012', 2)

Insert...