That looks...

Thanks.I am with Howard on this.

Yes I think so. By setting the Permission level to...

I guess the values in the THEN clause should all be of same data type!

Here, first three case you are assigning integer values (1,2 and 3) and the last one...

Thats because you are mixing both of our suggestions!

try this in your where clause

where finalcalledpartynumber = ('386') OR callingPartyNumber = ('386')

AND dateTimeOrigination >= @StartInt

AND dateTimeOrigination<= @EndInt

GSquared (10/15/2009)

---

One reason I worked it the other direction is that it gets rid of the functions in the Where clause. That's usually a good idea for performance. ...

ohh sorry, dint see Gsquared's response!

Sorry if I've not understood ur requirement, but does this work?

drop table t1

Create table t1 (tim int, rem varchar(100))

select 86400

INSERT INTO t1 VALUES (1251781074, 'day1')

INSERT INTO t1 VALUES (1251781074...

and the error is?

BrainMan (10/14/2009)

---

I've probably answered my own question. Looks to me like it's due to the fact that SS 2005 is running under "LocalSystem", and LocalSystem really cannot see the outside...

Is it possible to paste your query here please?

Requirement is not clear as such.. but is this what you are looking for?

SELECT <Your coulmns....n>

INTO #tableB

FROM TableA

Sorry if I've not understood your requirement clearly, but is this what you are looking for?

SELECT * FROM

(SELECT *, ROW_NUMBER() OVER (PARTITION BY Customer_ID ORDER BY SEQUENCE_NO desc) AS...

I guess you are looking for this?

Select * from sysobjects

Where id in (Select id from

syscomments Where text like '%urcolumn%')

not sure if it works on 2000 as i dont...

your welcome 🙂