Is this what you are looking for?

declare @Temp  table (pk int, v varchar(20))

insert into @temp

select 1, 'joe'

union all

select 2, 'jim'

union all

select 3, 'betty'

union all

select 4, 'zack'

union all

select 5, 'tim'

union...

Here is an old post

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=113390

I use the free yessoft program and it works great.

I used the scripts found here

http://support.microsoft.com/kb/246133

under the heading  -- A complete resolution to transfer logins and passwords between different versions of SQL Server.

select e.enid, name, lastname

from en_entity e

inner join cn_contact c on c.enid = e.enid

where e.name like '%'+c.lastname+'%'

But you will have the problem of...

I think there may be a zero in the data.  You could do this:

SELECT G6_ACT_DD

= case when G6_ACT_DD

select

g.[group], avg(s.score)

from

#groups g

left

...

This should work (I assumed no times are involved)

select distinct

 t1.*

from #temp t1

inner join #temp t2 on t1.machine = t2.machine and t1.value < 0 and t2.value < 0

 and t1.dte...

I learned that you can use the sp_executeSql a couple of months ago:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=199866#bm199953

In the last post from Ray M (Thanks Ray!)

Example:

Use Northwind

Declare @result int

declare @queryString nvarchar(1000)

Set @queryString = 'Select @result...

This will work too:

create table #temptime (pk int identity, dt datetime)

insert into #temptime (dt)

values (getDate())

insert into #temptime (dt)

values (dateadd(ss,-100000,getDate()))

insert into #temptime (dt)

values (dateadd(ss,100000,getDate()))

insert into #temptime (dt)

values (dateadd(dd,-1,getDate()))

insert into #temptime (dt)

values...

If @ACCOUNTTIME is NULL set @ACCOUNTTIME=0

Will this work:

select

 Ad_Desc,

 Descr = case when Ad_Switch_Id = 1 then Ca_Desc else Ty_Desc end

from #tblAds

left join #tblCategory on Ad_Keyword_Id = Ca_Id

left join #tblType on Ad_Keyword_Id = Ty_Id

What about:

select t1.*

from @Tab1 t1

left join @Tab2 t2 on t1.Tab1ID = t2.Tab1ID

where t2.Tab2ID is null

I think this will work.  I am giving the data that I tested it with.

create table #messageTemp (PK int, parentPK int, message varchar(50), messageDatetime datetime)

insert into #messageTemp (PK, parentPK, message, messageDateTime)

values (2,...

When I have this problem it is usually because my body + margins are larger than the report size.  Just size your columns so they will fit in less than...

I've never been able to set a value in a paramater in a dynamic string (I don't no if you can or not) but you can insert it into a...