MAX

SQL SERVER 2005-MAX FUNCTION

I have a stored proc1 which returns a list of dates for one particular job number.I execute this proc in an other proc2 ,to get the list of all dates.Then in my proc2 we can get the MAX of this list of dates. In the WHERE clause of my SELECT statement, i need to filter the result set by dates less...

View Answer   |  Jun 6 2008   6:18 PM GMT   |  asked by Beginner in IT
SQL Server 2005, MAX, SQL Server

Using MAX data types in SQL Server

I'm new to using large data types (varchar(max))and after reading an article (Using MAX data types in SQL Server) I have a few questions.I am trying to understand how you insert such a long string (up to 2 billion char) in the database table? I am assuming this would include storing Word Documents,...

View Answer   |  Dec 20 2007   6:03 PM GMT   |  asked by Hank1039
SQL Server, Data management and storage, MAX

Sql Query - Unique item with latest date of entry

Hey guys, I have been working on the query running against MS access database. The table has multiple columns and two of them (which are vital to this query) are Date and ItemN ( suggesting Item number).There are tuples which show multiple entries for single itemN, for example. item 1 has three...

View Answer   |  Dec 17 2007   6:44 PM GMT   |  asked by SmurkyIS
SQL, Subquery, Distinct