Error when using Aggregate function

Provides intelligent code completion for SQL Server editors.

Moderators: JonathanWatts, David Atkinson, Anu Deshpande, Paul Stephenson, Michelle Taylor, Mike Upton, justin.caldicott, Aaron Law

Error when using Aggregate function

Postby Hans Stuer » Fri Mar 22, 2013 10:47 am

Hi,

In SQL server 2012 when writing queries containing aggregate functions or functions using parantheses ( DATEADD, DATEDIFF, ...) following error is thrown:
Code: Select all
The type initializer for '<|' threw an exception.

whereas the < in the message is a full triangle, but i wasn't able to copy the character.
SQL Prompt tries to send te error report but isn't able to. I'm not able to save the error report either.

I'm running:
    SQL Prompt 5.3.6.28
    SSMS 11.0.3128.0
    .NET Framework 4.0.30319.269


Any idea what might be the problem?

Hans
Hans Stuer
 
Posts: 2
Joined: Fri Jan 11, 2013 3:10 pm

Postby Anu Deshpande » Mon Mar 25, 2013 11:38 am

Many thanks for your post and apologies for inconvenience caused.

Do you get an option to send an error report something similar to this?

If yes can you send the error report and make sure you enter your email address and let me know once you do it?

Also reply me the email address you used to send the report?
Anuradha Deshpande
Product Support
Redgate Software Ltd.
E-mail: support@red-gate.com
Anu Deshpande
 
Posts: 692
Joined: Mon Apr 20, 2009 3:53 pm
Location: Cambridge

Postby Hans Stuer » Mon Mar 25, 2013 1:19 pm

Anu,


I feel kind of silly, but i'm no longer able te reproduce the error. For the last 2 months i consistantly got this error when writing queries using functions containing parantheses and as of this morning it seems to work just fine.
I'm puzzled.

As for the Error report, it was similar to the dialogue you linked to, but i was never able te send the error (using the email address hans dot stuer at zna dot be). I couldn't save the error report either, so unfortunately i'm not able to send you any.

I'm kind of hoping the error will reappear because hate not being able to tell why this changed!

Kind regards,

Hans
Hans Stuer
 
Posts: 2
Joined: Fri Jan 11, 2013 3:10 pm

Postby Anu Deshpande » Mon Mar 25, 2013 1:52 pm

Not a problem.

Recently did you upgraded your SQL Compare?
Anuradha Deshpande
Product Support
Redgate Software Ltd.
E-mail: support@red-gate.com
Anu Deshpande
 
Posts: 692
Joined: Mon Apr 20, 2009 3:53 pm
Location: Cambridge


Return to SQL Prompt 5

Who is online

Users browsing this forum: Bing [Bot] and 0 guests