SELECT CASE 

     WHEN uactequiv BETWEEN 1 AND 19 THEN 25 

     WHEN uactequiv BETWEEN 20 AND 21 THEN 50 

     WHEN uactequiv BETWEEN 22 AND 23 THEN 75

     ELSE 0

END...

Unless Date() is some kind of variable you are passing in, you may want to try the following

@sql = 'SELECT Count(tblLinkRequest.LinkRequestID) AS CountOfLinkRequestID, tblLinkRequest.DateSent FROM tblLinkRequest GROUP BY...

HB1 visa may be a possibility. 

This is a sizeable company with very good financing, so it should be around for the long run...

Competency and a 'fit with the...

Thank you! 

Try this: 

SELECT TOP 1 * FROM xcctran    (you need to either specify a field or use them all with the *) 

That is very odd.  I though SQL 8.0 was basically a slimmed version of SQL 2000.  If you do a SELECT TOP 1 * FROM CommonTable on one of your...

 (Don't post in multiple places...  you will get an answer...) 

You can try something along the lines: 

SELECT x, y, z

FROM SOHEADER...

You can try something along the lines: 

SELECT x, y, z

FROM SOHEADER HDR

     JOIN SOLINE LINE ON( HDR.OrdNbr = LINE.OrdNbr)

     JOIN (SELECT TOP 1 TRAN.OrdNbr FROM XCCTRAN...

After a quick conversation with Barrett (is that Grin and Barrett ) - sorry, couldn't help myself....   We determined this little #TempTable structure...

Here is a simple method.  You can specify whatever length works best for you. 

DECLARE @LongText AS varchar(8000)

SELECT @LongText = '1-2-3-4-5-6-7-8-9-10-11-12-13-14-15-16-17-18-19-20-21-22-23-24-25-26-27-28-29-30-31-32-33-34-35-36-37-38-39-40-41-42-43-44-45-46-47-48-49-50-51-52-53-54-55-56-57-58-59-60-61-62-63-64-65-66-67-68-69-70-71-72-73-74-75-76-77-78-79-80-81-82-83-84-85-86-87-88-89-90-91-92-93-94-95-96-97-98-99-100'

SELECT SUBSTRING( @LongText, 1, 99)

SELECT SUBSTRING( @LongText,...

Doh!  Don't you hate getting those kinds of replies?  I agree with PW.  It sucks to have to do that, but you will be much happier in the long run......

I am stuck in the middle of a code review and cannot get back to this request.  Sorry. 

PW has posted many excellent suggestions and will probably figure this out. ...

If I understand you correctly, you have a "Big Manager" who has "Little Managers" working for her.  Under the "Little Managers" are the "Drone Employees".  You want not only the...

Try this format and see if you like it. 

SELECT CONVERT( varchar, GETDATE(), 101) 

This will drop the time stamp element, hence when you use BETWEEN, you shouldn't have the...

Gambino Crime Family pocketted ~ $650 million in Credit Card and Telephone Number theft last year....  I guess I'd better get a shredder too...