-George
Strong and bitter words indicate a weak cause. - Fortune cookie wisdom RE: Error? Operand type clash: uniqueidentifier is incompatible... SQLBill (MIS)1 Feb 06 12:07It sounds like @retTable already exists and one column (either invoiceNumber or other) is maybe IDENTITY and you are trying to insert a value into it.
-SQLBill Posting advice: FAQ481-4875 RE: Error? Operand type clash: uniqueidentifier is incompatible... sonname (Programmer)(OP)1 Feb 06 12:31George I ran that query and I get an int and a varchar as results as datatypes for those 2 columns. RE: Error? Operand type clash: uniqueidentifier is incompatible... gmmastros (Programmer)1 Feb 06 12:34Run it again, but this time...
CODESelect Data_Type, Column_Name
From Information_Schema.Columns
Where Table_Name = 'Invoices'
And Column_Name = 'Id' -George
Strong and bitter words indicate a weak cause. - Fortune cookie wisdom RE: Error? Operand type clash: uniqueidentifier is incompatible... sonname (Programmer)(OP)1 Feb 06 12:34SQLBill--I don't understand how @retTable could already exist since this is not a permanent table, but just a variable? RE: Error? Operand type clash: uniqueidentifier is incompatible... sonname (Programmer)(OP)1 Feb 06 12:36George--I ran it again and I get an int as a datatype, this just doesn't make sense to me. RE: Error? Operand type clash: uniqueidentifier is incompatible... gmmastros (Programmer)1 Feb 06 12:39Maybe the 'real' problem is the way you are calling it. Try this...
Select * from dbo.myFunction(Some int that should return data) -George
Strong and bitter words indicate a weak cause. - Fortune cookie wisdom googletag.cmd.push(function() googletag.display('div-gpt-ad-1406030581151-2'); ); Red Flag This PostPlease let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.
CancelRed Flag SubmittedThank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.