pwalter83 (7/31/2013)

---

Sean Lange (7/29/2013)

---

Since you started a new thread and Chris pointed me back to this one I will post here.

I would agree that trying to keep this data in...

pwalter83 (7/24/2013)

---

ChrisM@Work (7/24/2013)

---

pwalter83 (7/24/2013)

---

ChrisM@Work (7/24/2013)

---

pwalter83 (7/24/2013)

---

ChrisM@Work (7/24/2013)

---

pwalter83 (7/24/2013)

---

ChrisM@Work (7/24/2013)

---

Lowell has already asked but the question remains unanswered: why do you want to hold the same data in two places at...

No, the dateadd function takes care of that. October wraps around to January of the next year, then...

NineIron (7/26/2013)

---

I need a function that would return the fiscal month number from a date. Our fiscal year starts in October.

Something like...

declare @Date datetime

if month(@Date)>9 then month(@Date) -9 else month(@Date)...

Elliott Whitlow (7/25/2013)

---

LightVader (7/25/2013)

---

Elliott Whitlow (7/24/2013)

---

...

2. I have an article in the works that discusses NEVER using 3 part names in code and using synonyms to point to objects external...

Elliott Whitlow (7/24/2013)

---

...

2. I have an article in the works that discusses NEVER using 3 part names in code and using synonyms to point to objects external to the local...

jbalbo (6/5/2013)

---

Thanks for the quick reply

But how do I assign one a value and one a label ?

I have it setup to get avalable values from a query via dataset2...

For recreational reading, I love my kindle. For technical/learning, I prefer a physical book, much easier to search for certain information or reading the book non-sequentially.

Have you checked permissions on the table? I ran into this error yesterday and it was due to the fact that the SQL user we use to connect to...

Copying the same report...

alex_martinez (5/11/2013)

---

Hello,

We are using SSRS 2005 and I have a report I want to give access to 5 different managers the report will be in a separate folders by department...

drew.georgopulos (5/9/2013)

---

Hi

my instinct is Access would be best, but iirc, you can create parametrized stored procedures in SSMS & invoke them from Excel...i guess it depends on how robust the...

I've taken the same week vacation almost all my life. Before I go, I'll take the time to document some of my regular responsibilities, the status of my projects,...

I have a similar "job killer" task. I used sysjobs, sysjobactivity, and sysjobhistory (all in MSDB) to get the information about currently executing jobs. I also have a...

george-975422 (10/27/2012)

---

I had a similiar experience.

A little explaination. In some states there are regulated electric suppliers (big utilities) where energy rates are set by the a state commission (not...