select t2.statename, count(*) as jobnames

from table2 as t2

left join table1 as t1 on t1.state = t2.stateabbrv

group by t2.statename

Blimey!

Since there are only 50 states and 1 district in the USA, it can't be that hard to set the ranges accordingly...

CREATE PARTITION FUNCTION States50_1

 (VARCHAR(20)) AS RANGE LEFT FOR VALUES...

Just for curiosity, I checked Books Online and found this

D. Creating a partition function on a char column

I use SSMS2008.

The fun thing is that if I copy and paste the code to MS Word first, copy the code from MS Word and paste here, I get single...

ALTER the table and use VARCHAR(MAX) as datatype instead of TEXT.

CREATE TABLE #TEMP (i VARCHAR(200))

INSERT #Temp

EXEC(@sql)

select @bfiyat = i from #temp

I haven't access to SQL Server 2005 right now, but what happens if you add

, ELEMENTS

at the end?

What is EXEC(@sql) returning?

A resultset (one row with one column) or a return value?

select upper(left('smith',1)) + lower(substring('smith',2,...

Why? I thought the MobileApplicationID was unique?

CREATE PROCEDURE dbo.uspMobileApplicationReportMenu

(

            @MobileApplicationID UNIQUEIDENTIFIER,

            @CustomerID UNIQUEIDENTIFIER

)

AS

SET NOCOUNT ON

;WITH peso ([@Id], [@Text], [Level])

AS

Asked and answered here

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=88129

Since all tables (t2..tn) join on the same columns, try to rewrite them as an UNION instead.

SELECT  <Col List Here>

FROM  t1

LEFT JOIN (

   SELECT f1, f2 FROM t2 UNION ALL

   SELECT f1, f2 FROM t3...

It would be nice to know if the information was helpful or not...

The output (based on the sample data you have provided) look like this

<SiteMap>

           <item LookId="DefaultItemLook" Id