Personally I found multiple communication tools distracting. I like organisation, so if I could do everything with one tool, it would be nice. If I could just reply...

We use a naming standard that prevent the "gotchas" in synonyms: s_<objectname>

That obviously means that we do not simplify the names and we only use it when we are pointing...

How about special training for x number of people. Lets say for 4 weeks. It could be at home or close to home. You already have the...

I would just change one thing on Jeff's suggestion: Use a wheel clamp instead of towing. In our country it is a cheaper option and if it is...

I have determined that the "out of context" connections in the clr is causing the problem. Does that mean that I cannot connect to 2 different databases when I...

Test 1 proves that my code works when you just view it. It is the INSERT INTO that is causing something to change on the clr side, as if...

With that out of the way, my original problem did not disappear.

TEST 1:

SELECT CONVERT(INT, nsFramework.dbo.fncFormulaCalculation(5, 1, tYear, tMonth, 0))

FROM dbo.tblTallyTable_Periods

WHERE tYear = 2014

-----------

26746

23014

27048

26326

27356

25219

27667

27823

25650

28139

27386

26956

TEST 2: (fail)

CREATE TABLE #Temp (

Result INT)

INSERT INTO...

I have removed all my try catches in the clr and I just found that I have casting issues. I will reply when that is solved.

It does not even allow an insert into a temp table. The clr returns a single value, thus:

CREATE TABLE #Temp (

tValue NUMERIC(18,4))

INSERT INTO #Temp

SELECT fncFormula(5, 2014, 6, 28)

or

SELECT fncFormula(5,...

Your link "10 uses for a message queue" should have read: "10 reasons to use message queues". I also would have liked a few examples.

I will vote for tabs. Why? Just because I am lazy and using the arrow key to jump 4 spaces makes me smile. Our standards include the...

Its never that easy. Till now I never needed the Enterprise Edition. What changed? Moving a number of instances on one physical server and then realising that I...

Yes, that is why 1...

We have 2 x SQL2000 servers and 5 x SQL2008R2 servers. I have an ongoing project to migrate all databases to our new servers (SQL2008R2), but I do it...

I am blessed by having the best of both worlds. Ok, I know I am bragging, but it’s nice. I have a 27inch wide aspect for apps like management...