No reason to be desappointed. In SSMS click on View then  Solution Explorer. Then Add your other solutions.

No reason to be scared. What you are seeing and posted is just the the CREATE script for the view. The main part of it is the SELECT TOP 100...GROUP...ORDER...

Can you insert into a temp table first with that field being 80 chars and then truncate field width in another insert to LIVE data. I know it sucks, but...

Francis, lets assume

1) Import table is tbl_IMPORT which is a cross-reference table containing information on products and one of the fields is ProdID, and NewProdName is the new name

2) The...

Lets see if this will help.

use the SUBSTRING(input_str,12,len(input_string)) function to return the rest of the input string. The put the result string in a WHILE loop to find, count, parse...

You are out of luck using the EXCEPT which works beautifully in SQL2005 for your case. However, T-SQL suggested above also works for SQL-2000.

Guys, I really don't know what the final type of the result should be but this is what I do:

select

convert(varchar

If you have access to the Oracle Server, meaning credentials and at least SELECT rights, create a Linked Server to the Oracle database and you will be able to query...

You may want to play with the EXCEPT AND INTERSECT

select

* from table_1

select

*

Here is another similar approach. By the way, you are not alone on this journey to CROSSTAB queries in MS T-SQL.

http://www.sqlteam.com/item.asp?ItemID=2955

Here is a sample SP someone wrote on this forum a couple of weeks ago, probably more. I think it works out of the Northwind Sample Db.

I hope you can...

This is what I have. Am I right?.

SELECT

a.data_date

,count(case when serv1 = 'N' and serv2 = 'Y' then cust_id else null end) as from1to2

,count(case when serv1 = 'N' and serv3 =...

go ahead and buy the off the shelf e-commerce solution and make sure you can see all the objects, like SPs code and views and so on.

Then create your app...

Try this:

select

distinct(obj.name) as tableName

,obj.type_desc

,

http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=453930&SiteID=17