😛

sys.indexes

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

Diving

WADRIAN68 (7/1/2014)

---

Hi

That is a really fantastic solution, it works perfectly and I've learnt that changes to a cte are cascaded to the source table, I will have to read up...

Perry Whittle (7/1/2014)

---

No, a secondary...

LoosinMaMind (7/1/2014)

---

In response to previous post....

unfortunately the numbers could be anywhere in the field and there could be up to a max of 5 numbers.

for example one field could...

Sorry having a dense moment. I finally understand what you are trying to do. I agree with Lowell. Not only are things like spacing a challenge you might have different...

etirem (6/30/2014)

---

I need to ALTER both the stored procs at the same time with below SQL.

Table2 t2 ON t2.CID = t1.CID

INNER JOIN Table3 t3 ON t3.CID = t1.CID

WHERE CustGroup =...

I must be missing something. What is the question or what do you need help with?

I understand the issue with the NOLOCK hint but what is wrong on the first line?

murrabp (6/30/2014)

---

I was hoping someone could help me with doing an APR calculation in SQL. I have Loan Amount, # of months(term), additional fees, and interest rate. Been...

mjd327 (6/30/2014)

---

Ok, I just had a talk with one of my bosses and got some more information on what he had in mind.

I didn't realize what he meant at first,...

mjd327 (6/30/2014)

---

I'm hoping Access is workable in some way as it seems like the easiest solution, but I want to again emphasize that some of the tables are VERY large....

Andrew Kernodle (6/30/2014)

---

Ah, gotcha! That changes things up a good bit :-).

Access may well be a more workable solution, then, provided the DBAs aren't overwhelmed presently. Pass-through queries...

Pretty sure you mean MDF unless you use your own extensions.

Can the .NDF be shrunk after all...