Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Procedure parameter problems
thank you r937 that worked although i used it without the % it irritates me tho because i tried this once and it didnt work. but works great now thanks again -
Procedure parameter problems
no i just forgot to delete that ')' before posting but more detail on my problem is this: if i type this: exec spBalanceRange @VendorVar = 'Vendor' i get this error: Invalid column name 'Vendor'. so if it using a column name: exec spBalanceRange @VendorVar = 'VendorName' it runs it. i dont... -
Procedure parameter problems
i shortned this procedure. but im havving problems with the like clause in this, it says it cannot find the column which i dont understand CREATE PROC spBalanceRange @VendorVar VARCHAR(50) = NULL, AS DECLARE @QUERY VARCHAR(1000) SET @QUERY = 'SELECT VendorName, InvoiceNumber, PaymentTotal AS...
