double post;

continued with suggestions Here:

http://www.sqlservercentral.com/Forums/Topic625801-1291-1.aspx

can you post the actual query? that would allow us to give an exact answer; for here, i think general suggestions will just lead to more questions and confusion.

stored procs and functions are a little harder to migrate; most of it is manually editing the procs, sorry.

things to look for:

10G uses the standard JOIN syntax, so that's a...

IF your table has a a datetime column with a default value of getdate(), you whould simply use a WHERE MYDateColumn BETWEEN date1 AND Date2; If there is not column...

Here's my first guess, and it's probably right:

when they are coming thru your UI, they are using a different login than when they connect vi SSMS....

if i connect with user...

i think it's Vista;

compared to XP, where every login was also an admin, didn't Vista remove some rights you might expect by default for security purposes? so your login...

do you mean something other than using sp_who or sp_who2?

post the query.

you might be suffering from parameter sniffing, where an execution plan is built on an assumption by the Query optimizer about one or more of the parameters;...

i think what you are looking for is using a CASE and sum together to get the value you are after;

here's a the core example:

[font="Courier New"]SUM(CASE WHEN A.Trans_Type_ID IN ('Reversal',...

15 seconds is a long time, unless it is fiddling with billions of records.

post the query itself so we can see, maybe a missing join or something is killing performance.

saving...

on a similar issue, if you want to drop a FK on a column, but don't know the actual FK constraint name, i made the proc below...

you simply call

EXEC DROP_FK_FROM_SPECIFIC_COLUMN...

the error tells you exactly which line to go to to fix it....

it's pure syntax:

Msg 102, Level 15, State 1, Procedure SP_ResetCreditLimit, Line 32

Incorrect syntax near 'UPDDATE'.

Update is misspelled. remove...

i use something like this, involving an ORDER BY featuring a case statement:

i want nulls at the end, but non-numerics at the beginning;

ORDER BY

CASE WHEN ISNULL(Yourfield) = 1...

if you add the access database as a linked server, you can treat it as any otehr table...

so you could SELECT...INTO NEWTABLENAME FROM ACCESS:

for example, if you created a linked...

yes, but he needs the same WHERE clauses in his subsequent inserts/updates to his other three tables....so I thought he needed the comparison for the later SQL's....

same thing, different island,...