Hi, it seems that one of the operator is a numeric int type and not a string, thus collate cannot work, maybe an implicit conversion, can you please send the...

Hi, the data that you are inserting are coming from a query, I suppose, then you can check in the select clause, running it separately, for the aforementioned overflow error....

Hi, check if you have correctly set up the mail account in database mail, with all the parameters of the SMTP server, and check also if the database mail is...

Hi, you can use the same user that is db owner...

Hi, I assume that you are using the same connection also on the server, check the data source username and password, also where have you stored the password for accessing...

Check in the job step the run as option and see if the account is in the proxi used by the run as...

Hi just a question in order to clarify your problem: at which exact time you created this job schedule?

Second question: is there a job schedule with the same exact name...

Hi, I assume you are putting the date in yyyy-mm-dd format, am I right? Can you give me an example of the variable content, just to be sure that you...

'Steppenwolf' is 11 characters so having declared the table as

DECLARE @i TABLE( mychar VARCHAR(10));

the insert will return an error.

The right answer should be 0!!

I agree, I would use a COALESCE statement.

What is your question precisely? This is the standard solution in order to "pivot" a query in sql, without using the pivot statement. In this solution a Case is used...

Glad that it worked!

Hi, you can create a SQL Task with the script to identify the dates condition, resulting in a flag, put the result set in a variable and use a constraint...