i found installing from the script file was the easiest for me. i had to go and remove any full text stuff as i dont have full text indexing...

SQLKnowItAll (9/10/2012)

---

capn.hector (9/10/2012)

---

SQLKnowItAll (9/10/2012)

---

I suppose I don't understand the point. We know that when records do not exist in the RIGHT table that NULLs are returned. So why...

LoosinMaMind (9/10/2012)

---

Hi

how do i easilty convert days into weeks (obviously Days/7 will give me weeks as decimal)

Problem i have is I only want to count completed weeks:

ie: 20...

SQLKnowItAll (9/10/2012)

---

I suppose I don't understand the point. We know that when records do not exist in the RIGHT table that NULLs are returned. So why would we...

In my shop we store the 10 digit us number as a VARCHAR(16) (to allow for international numbers) but do not store any country code information or formating with the...

Take a look at HAVING. from your description i think that is what you are going to want.

http://msdn.microsoft.com/en-us/library/ms180199.aspx

Im going to be at #sqlsat154 in St Louis and am...

Here is one with a rCTE. to put it back together you can use FOR XML PATH or SELECT @Var = @Var + part. i have done one...

Well here is my solution. since we can order by when we take our substring we can just put the FOR XML PATH ('') in that query and not...

Chrissy321 (8/2/2012)

---

I'm fascinated.....I am working with Lynn's code.

Say I wanted certain clients those whose ClientID was < than 3.

Clearly I can add any conditions to the final SELECT statement but...

diamondgm (8/3/2012)

---

@Capn; Sorry I missed your question in the...

Sean Lange (8/2/2012)

---

morepainot (8/2/2012)

---

Sean Lange (8/2/2012)

---

morepainot (8/2/2012)

---

Sean Lange (8/2/2012)

---

Well the code certainly looks a lot better. But it doesn't help me identify why you are getting an invalid object name....

LOL :w00t::w00t:

i posted what i had figuring on working on it and actually expecting some one to beat me to...

Here using a full join where both sides are null we can get all our new or old clients and depending on where the nulls are can assign whether they...

i like the cross apply however you can turn it into an Inline Scalar Function (an iTVF that returns 1 value, Thanks Jeff http://www.sqlservercentral.com/articles/T-SQL/91724/) by using the following function.

CREATE...