I am confused by this. You say you know this will always be 10 rows, yet you have 11 rows in your sample data. Am I missing something?

Sounds like a homework problem, but just join the table to itself on emp_id from the first table to manager_id on the second and pick the columns you need.

Well, as Steve mentioned, can you be a little more clear on your problem? Why didn't my solution work? It did give back the resulting table you were...

Did the solution I posted for you a couple of days ago not work?

http://www.sqlservercentral.com/Forums/FindPost1244577.aspx

Is this what you are looking for?

declare @i table

(

grp_nbr varchar(1),

sect_nbr varchar(3),

indicat varchar(1)

)

declare @g table

(

grp_id varchar(3),

grp_nbr varchar(1),

sect_nbr varchar(3),

indicat varchar(1)

)

declare @o table

(

order_id varchar(4),

grp_id varchar(3)

)

insert into @i values

('1', '100', 'p'),

('2', '101', 's')

insert into...

I don't know about any settings, but is there a reason you can't just do a left(yourColumn, 245) on whatever you are inserting?

I have been getting my email notifications to subscribed threads just fine, both yesterday and today.

Edit: I will say though that since yesterday afternoon up through now the site has...

I prefer this site for that sort of thing. 😉

http://www.lmgtfy.com/?q=script+database+roles+and+permissions

Now maybe my Cubbies can actually do something this year since the pitching staff won't have to face either Pujols or Fielder 30 some...

Assuming your column has just dates, you will have to convert the result from the dateadd function to just a date, since by default it also includes the time.

where member_time.date...

I am aware of that. I was a little unclear on...

You might have to post some sample data. Using getdate() will also include the system time down to milliseconds, which I highly doubt any of your rows will match....

Use dateadd instead.

select DATEADD(d, -1, GETDATE())

Without anymore description or sample data than that, it would just be:

select *

from tableA

where (orgid = 2 and parentid = 3) or (orgid = 3 and parentid = 2)

But I...

Ya, what John said.

declare @t table (

ssn varchar(10),

[contract] int,

edate date,

tdate date

)

insert into @t values

('111-11-111', 1, '1-01-2012', '4-01-2012'),

('111-11-111', 2, '5-01-2012', '8-01-2012'),

('111-11-111', 3, '8-02-2012', '11-02-2012'),

('222-22-222', 1, '2-23-2012', '5-23-2012'),

('222-22-222', 2, '10-01-2012', '1-01-2013')

select t1.ssn,...