^^ Thanks. I'll start chewing through that and seeing if it fits. At first glance I have no idea what it's doing. Like I mentioned I've never had to deal...

Craig Farrell (10/6/2010)

---

craig-404139 (10/6/2010)

---

Craig Farrell (10/6/2010)

---

Craig,

Is it safe to assume that this field will alway end in numerics? If so, I may have a simple solution for you regarding...

Craig Farrell (10/6/2010)

---

Craig,

Is it safe to assume that this field will alway end in numerics? If so, I may have a simple solution for you regarding the variable front...

So far this works using the substring statement. But has alot of hard coding. Although this solves my current problem, it doesn't help with other future needs.

select 'PPCI' +...

That makes sense. So the SA account for the odbc connection is just for the application to connect, then all permissions are assigned by it(me)?

I wish it were as...

To add I understand that the application is setting database level security. My confusion is how that database security is tied to the sa account used in the odbc connection....

Are you backing up your transaction logs at your DR environment?

GSquared (9/28/2009)

---

I just tried this and got the right results:

create table #T (

ID int identity primary key,

Dim int,

Val int);

insert into #T (Dim, Val)

select 1, 1 union all

select 1, 2 union...

Makes sense. I just figured since the join clause is evaluated before the where clause it would be a good idea to do as much filtering as possible on it.

Chris Harshman (10/30/2008)

---

yes, if I'm understanding you right. To be more specific:

select

from (select top 1 column1, column2, column3, column4

...

Something like this?

select *

from (select TOP 1 column list

from tablename

order by datecolumn DESC, timecolumn DESC) as derived table

Chris Harshman (10/30/2008)

---

could you take a different approach and do something like this:

select TOP 1 column list

from tablename

order by datecolumn DESC, timecolumn DESC

I suppose it depends on how this query...

Time is in a different column. Thats why I cant figure out how to do it.

bhovious (10/3/2008)

---

My bad. I didn't catch that the middle post was also from you. I see how using "AA" without a term qualification got you...

bhovious (10/3/2008)

---

Hey Craig:

By definition, in your joins, "A" only produces a set of rows for Fall 2008, just as "A2" can only return Summer 2008. ...