With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.
Declare @list NVarchar(30) Set @list = '190,191,192,193' Declare @sql nvarchar(1000) Set @sql=' select Sum(afsAmount) from proc_cfa.dbo.P_AvailableForSale where afsid in (' + @list + ') group by Left(afsSource,7)' exec (@sql)
|Unable to save view in SSMS||21||53|
|datetime in sql||6||23|
|Using SQL Server 2008, how would you modify 2 input parameters to compare them to a date field considering the 2 parms passed in contain the month and year (not the date of the month) ?||1||15|
|I am using SQL Server 2008. Is there a way to pass in 2 parameters strings in the format MM/DD/YYYY and convert these strings into a DATE data type using SQL Server 2008 and then make a date compare?||3||12|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
11 Experts available now in Live!