Here is an example using the DelimitedSplit8K function that you can find at the link provided, or you can follow the link in my signature for splitting strings.

;with cte (Col1)...

As Scott said learning the dynamic sql technique is a good one. And he is correct that sp_msforeachdb has a bit of overhead. I would however say that with 700...

aha!!! I had a feeling this was a loop through all the databases on my server and do something kind of situation. In general cursors are to be absolutely avoided....

I think I just found my next kindle title. 😀

zilla (12/17/2012)

---

I have a sub query within my IF statement that evaluates to one single number that I am using for a comparison operator. I am thinking there is something...

asita (12/17/2012)

---

Hi Sean,

yeah you are correct.

but the thing is, we can take any assumption but the out put need to match

just require to get that outcome, it is really a...

If that is all you did I...

ColA looks like just a ROW_NUMBER for each Territory.

select *, ROW_NUMBER() over(Partition by Territory order by Name) as ColA

from TestTask1

for col2 it will be based on sales_amount (duplicate value consideration)

same...

You need to enable and utilize distributed transactions. http://msdn.microsoft.com/en-us/library/ms188386%28v=sql.105%29.aspx

justfillingtime (12/17/2012)

---

Hi All,

I have a quick question. My code below shows the data I'm pulling from my temp table

select

[year],[date],[dayofweek],[daynum],

cast(count(CASE WHEN area = 'City & County' THEN 1 END)...

Andre Ranieri (12/17/2012)

---

if the left side of the equal sign is a calculation, then the WHERE clause is "non sargeable", meaning that the optimizer can't use simple search arguments and...

Lisa Liel (12/15/2012)

---

Sean Lange (12/14/2012)

---

I will second Phil on the NOLOCK. That query hint is by no means a go fast pill. It is a get your data quick as...

That could be...didn't even think about being a case-sensitive collation.

There seems to be something a little odd going on. I agree that from what you have posted creating a temp table as a copy seems like complete overkill. Have...

I will second Phil on the NOLOCK. That query hint is by no means a go fast pill. It is a get your data quick as long as you don't...