Or a tweaked version of my above code:

DECLARE @USERNAME NVARCHAR(100) ; SET @USERNAME = N'SABY' ;

DECLARE @USERID INT , @ISADMIN INT

SELECT @USERID = USERID , @ISADMIN = ISADMIN

FROM Table_A

WHERE...

Remove the , and replace it with AND like this

Inner Join Products

ON...

Justin, the code that i had given, did u run it without editing anything ? whats the result of that?

ORDER BY must be present at the last of the code. That is where it should be; so your new code looks like

Select

Orders.OrderDate,

Orders.OrderId,

Orders.OrderNotes,

Orders.Custom_field_vehicleinfo,

Orders.Salesrep_Customerid,

OrderDetails.ProductCode,

OrderDetails.Productname,

OrderDetails.Quantity,

Products.CustomFeild4

From Orders

Join Products

ON Orderdetails.ProductName = Products.ProductName

/* Order BY...

There is no direct single T-SQL code that can do this requirement, but u still have a cool code to do it. Please go thro this fantastic article from our...

How about this ?

DECLARE @USERNAME VARCHAR(100)

SET @USERNAME = 'MIKE'

SELECT B.*

FROM Table_B B

JOIN Table_A A

ON A.USERID = B.USERID

AND A.USERNAME = @USERNAME

UNION ALL

SELECT *

FROM Table_B B

WHERE 1...

Excellent article Gian.. very precise and elegant...

How many entries per patient ID can hav ? only 2 or more ?

and, do we have a patient IDs stored in the DB sequentially and whats the Primary key...

The problem is with your scale and precision of NUMERIC and DECIMAL..

You have given "2004" and NUMERIC (4,2)

DECIMAL (scale, precision)

Scale = maximum number of digits that numeric value can have...

There are CAST and CONVERT functions that allow you to convert your VARCHAR functions to TIME format.. Please have a look-see at Books Online (A free help system that comes...

Thanks for the feedback , Malavika.. one caveat...

How about this ?

SELECT CASE WHEN DATEPART( HH , GETDATE()) > 12 THEN CAST ( ( DATEPART( HH , GETDATE()) % 12 ) AS VARCHAR) + ' PM'

...

:-D:-P

Update TableA.name column with values from TableB.altname ?

UPDATE A

SET A.name = B.altname

FROM TableA A

JOIN TableB B

ON A.acctno = B.acctno

Wont this do for you?

Import all the 8 file into individual tables (dedicate one table to each file , of course), then prepare a "VIEW" to pull the second column of each table and...