Just as an explanation, the AS clause allows you to alias a column while the equals operator assign the column's value to the indicated variable. So, in your first...

You were really close...:

SELECT @val1 = val1 FROM tblTemp1 WHERE rowID = 1 



INSERT INTO tblTemp2

(RowGUID, ID1, ID2, val1, CreationDate)

VALUES

(@RowGUID, @ID1, @ID2, @val1,...

In English, not SQL, what are you trying to accomplish here? Have you taken a look at DATEADD(hour, DateField)? To strip the time portion of a datetime field,...

It's not an issue with the SQL, it's an issue with the JDBC driver and the TEXT data type. See this link for an explanation:

http://www.developersdex.com/sql/message.asp?p=2496&ID=%3C5f5501c33fcb%249e03b560%247d02280a%40phx%2Egbl%3E

looks like Java doesn't play...

What is the statement? If you don't post either the SQL or the Java code, we won't know what the issue is or where the bug lies. My...

I think this forum's a pretty good place to go!

but for syntax type references, Books OnLine, which comes with SQL Server client tools, is the first...

Please post the code which is generating the error so we can take a look.

No need for any of that. Just change the procedure to accept a NULL ArrivalDateFrom and ArrivalDateTo parameters and then do a where clause:

WHERE b.Arrival_Date...

If SAGE is running on SQL Server, and you can see a "date" field, but it looks like character data, try doing:

WHERE DATEADD(day, 0, CONVERT(SMALLDATETIME, MyDateField))...

Thanks, I'll check it out.

sorry, not familiar with mssqlxpress. How does the Edit Design functionality in that app differ from the Query Analyzer interface?

Can you post the SQL code, or is it proprietary? Have you tried contacting the vendor for support?

What functionality are you looking for; perhaps if you explain what you're looking for, we could point you in the right direction. Any specific capability you need?

Anything returned in the Query analyzer is available in the Recordsets collection in ADO. Just issue a call to Recordset.NextRecordset to move to the next set of returned data...

Agree with Antares on this one...I use Textpad myself for all development outside of QA. It has excellent support for native and add-on toolsets, compilers, etc, and awesome regexp...