Damn, Ryan beat me to it, agian

My solution anyway

CREATE FUNCTION dbo.udf_renters (@house int)

RETURNS varchar(1000)

AS...

I am not sure of your requirements, please supply sample input and desired output.

Or you could utilize a function

CREATE  FUNCTION dbo.udf_warehouse (@SKU int, @status varchar(4), @Date datetime)

RETURNS varchar(100)

AS

BEGIN

    DECLARE @result varchar(100)

    SELECT @result = COALESCE(@result+',','') + Warehouse

    FROM Items

   ...

CREATE FUNCTION dbo.GetReports(@IncludeParent bit, @intParentPlantAreaID int)

RETURNS @retFindReports TABLE (intParentPlantAreaID int, strPlantAreaName varchar(50), intPlantAreaID int)

AS 

BEGIN

DECLARE @child TABLE (intParentPlantAreaID int, strPlantAreaName varchar(50), intPlantAreaID int)

DECLARE @parent TABLE (intParentPlantAreaID int, strPlantAreaName...

Nice one Jason.

I should of thought of that

Try

EXEC sp_executesql @sqlcmd, N'@JobID INT OUTPUT', @JobID OUTPUT

What version of SQL are you using?

On SQL2k I get the following plan

Filter(WHERE[calllist].[DispoType]='984'))

  |--Bookmark Lookup(BOOKMARK[Bmk1000]), OBJECT

This gave an error when I tried it

My solution

SELECT TOP 1 Hid, HDate

FROM

ORDER BY ABS(DATEDIFF(day,HDate,GETDATE())) ASC

This will ignore time...

or if you do not wish to use an input file then

osql -Q "EXEC SP_FormatName 'TEST_TABLE'" /U sql_username /P sql_password /S servername /o logfilename

If the table is fixed as specified then either of these

SELECT call_id,

1 AS [event_1],

MAX(CASE WHEN event=1 THEN param1 ELSE null END) AS [param1_1],

MAX(CASE WHEN event=1 THEN param2 ELSE...

I did not mean to offend people.

No offence here

You spent 10 years with a company, first of all, all you had was the experience in that...

Not sure about the error but because your file is character you cannot use SQLINT for field definitions although BCP will output this in a fmt file by default.

Try this...