Red Gate forums :: View topic - Error when using Aggregate function
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Prompt 5
SQL Prompt 5 forum

Error when using Aggregate function

Search in SQL Prompt 5 forum
Post new topic   Reply to topic
Jump to:  
Author Message
Hans Stuer



Joined: 11 Jan 2013
Posts: 2

PostPosted: Fri Mar 22, 2013 10:47 am    Post subject: Error when using Aggregate function Reply with quote

Hi,

In SQL server 2012 when writing queries containing aggregate functions or functions using parantheses ( DATEADD, DATEDIFF, ...) following error is thrown:
Code:

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
Back to top
View user's profile Send private message
Anu Deshpande



Joined: 20 Apr 2009
Posts: 692
Location: Cambridge

PostPosted: Mon Mar 25, 2013 11:38 am    Post subject: Reply with quote

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
Back to top
View user's profile Send private message Send e-mail
Hans Stuer



Joined: 11 Jan 2013
Posts: 2

PostPosted: Mon Mar 25, 2013 1:19 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
Anu Deshpande



Joined: 20 Apr 2009
Posts: 692
Location: Cambridge

PostPosted: Mon Mar 25, 2013 1:52 pm    Post subject: Reply with quote

Not a problem.

Recently did you upgraded your SQL Compare?
_________________
Anuradha Deshpande
Product Support
Redgate Software Ltd.
E-mail: support@red-gate.com
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group