MSDN States 50 and 16: http://msdn.microsoft.com/en-us/library/cc645993.aspx

Hit CTRL + T that then run it again. That will put you in text mode so the result and messages are on one screen. CTRL + D...

Yes,

That is what I was thinking and the blog from David does a good job of demonstrating the web service call. Another option would be an SSIS package...

Is CLR an option in your environment? if so, check out: http://davidhayden.com/blog/dave/archive/2006/04/25/2924.aspx and see if that helps.

What are you trying to accomplish? You can create DDL Triggers (SQL 2008: http://msdn.microsoft.com/en-us/library/ms186406.aspx and SQL 2005: http://msdn.microsoft.com/en-us/library/ms186406(SQL.90).aspx).

My pleasure, glad to hear it work for you.

Have a great day,

Gary

Try the Following:

Test code:

declare @t as Varchar(25) = 'E8800'

declare @s-2 as Varchar(25) = 'E8489'

select 'YES' where

(@t between 'E8800' and 'E8889' )

AND NOT (@S between 'E8490' and...

I am assuming that this will be corrected in a while, with No being set to the correct answer?

Wouldn't using Top 25 WITH TIES accomplish the same thing, rather than using the CTE (assuming they are using the group by and order by clauses without the SalesCategory...

I agree with the previous comment that even with a group by, top 25, and order by, you are not going to get what the question asked for as the...

Per http://www.mydatabasesupport.com/forums/ms-sqlserver/329497-reporting-services-error-rsinvalidreportserverdatabase.html :

"You need to apply/re-apply SP2 to your reporting services installation

since the ReportServer database you are pointing to is at an SP2 level

(C.0.8.54) whereas the Reporting...

The link provided in the answer states, "When SQL Server clients request SQL Server resources, the client network library sends a UDP message to the server using port 1434. SQL...