It is not allowed that you can used a column alias in the Where clause.

Let us know why you need this or the requirement so that we can suggest you a...

I would recmend you that apply the converstion on the date value parameter and used equel (=) rather then like operator and it will slove your problem. even you can remove...

Here is your required query. Any field you need you can put in the select list and if you have used the group by then you should also need...

Hi,

Yeh, it is not the matter of length of stored procedure. It is the problem with the query. You should need to check the specific line mentioned in the error...

I think you should passed only mwltmw.mwl.dbo.

If the value of this is mwltmw.mwl.dbo.RM20201, then why you are using in your query the table name once again.

SET @sql = @sql +...

what is the value of @gpdb...

SELECT count(a.DOCNUMBR) from  gpdb PM20501 a

here you see that this variable should have no meaning for the query.. can you post the extact value...

Hi,

I think that you have recently change the SA password. Tried this solution and I hope that it will slove your problem.

Right click on SQL Agent from SQL Enterprise Manager and...

Yes you can do with the inner join, but if you want that all projects list even though they have no bugs then you should need the LEFT OUTER JOIN inplace of INNER JOIN.

Lynn is right, but you need the cuation, because DATEFIRST setting change is permanent. so make sure it would not affect anywhere in your database. 

Use @@DATEFIRST to get the old setting...

Can you explain, what you assume should be export.

I think if you can used the simple query without the cursor then it will be good.

I don't know what you want to...

Hi,

Then you can make the query like this

SELECT DISTINCT Email , (

    select  TOP 1 ContactName from Suppliers S

    WHERE Suppliers.EMAIL = S.EMAIL

    GROUP BY ContactName,EMAIL

    having DATALENGTH(EMAIL)=MIN(DATALENGTH(EMAIL))

   &nbsp

Hi,

This Warning is generate but the index is created on the View and it can be used in the Execution plan as well.

What happen if the contact name would be same?

It is the data entry problem, you know that same mail address on any mail server is not allowed. In that senerio...

Mohammed Uddin is right, you should also need to change the ALIAS in a single name as he mentioned.

There is another error in...

The Order of User and Database is wrong in your statement.

ServerName.DatabaseName.OwnerName.ObjectName

It should be CertifiedObservers.dbo rather than dbo.CertifiedObservers. After this change the query will be like this and hopefully...