Saujib (7/2/2013)

---

hi

Here a requirement that I am trying to implement

One table Address is used by many tables. like member, provider and sales representative.

While creating Sales Order, User would entry information...

f9c882q 61644 (7/2/2013)

---

How I create a function to get all policies that expire a 120 days from now.

Eg If the policy effectivedate is November 1 2012 and expiration date is...

mcopa (7/2/2013)

---

We have a db with 388 tables/5,950 fields. I was just asked if I could find any fields (in the entire freaking db) that have never had any...

ulisseslourenco (7/2/2013)

---

Thanks for respond me.

I have a question: Is allowed use exec statement into a function? I ask that because I have to return a select into...

I don't really understand the details as it pertains to your situation but it sounds like you need to look at the ROW_NUMBER partition and adjust it to fit your...

adonetok (7/2/2013)

---

It is working great.

One more question, I want to insert the result into a temp table but code below did not work.

Something wrong with my code?

select * into #myinvoice...

valeryk2000 (7/2/2013)

---

It did indeed (see attached)!

I added another join to the query - it runs now 3 sec (we started with 2 min 25 sec).

I'm excited and proud (as if...

realvilla (7/2/2013)

---

Sean,

I'm realizing something. Let's say that you have three records in the ReturnsPros table that have the same data in six columns:

ProgYear = '13'

RiskNonRiskFlag = 'N'

Region = 'Central'

ModelName...

Take a look at the execution plan on the...

Indexes...

SQLWannabe (7/2/2013)

---

Sean,

Thanks for your Reply.

Can you picture me doing a face plant? I don't know how I didn't think of that within about 15 nanoseconds.

Sometimes I have that moment...

engstevo (7/2/2013)

---

Write an SQL statement that will perform a daily sum aggregation on the field cost. It must only use costs that are associated with the follow items: Z001, Z002....

Homework? We can't see the paper...

Check out this article that explains what is happening and some great example to help you understand ordering.

http://blogs.msdn.com/b/conor_cunningham_msft/archive/2008/08/27/no-seatbelt-expecting-order-without-order-by.aspx

dwain.c (7/2/2013)

---

Sean Lange (6/27/2013)

---

DataAnalyst011 (6/27/2013)

---

From time to time I need to check if a column is completely numeric (or usually, check for the row contain something other than numeric). I've...