Viewing 8 posts - 1 through 8 (of 8 total)
Jeff Moden (10/21/2007)
October 21, 2007 at 12:06 pm
Jeff Moden (10/20/2007)
SELECT TOP 1
...
October 21, 2007 at 6:43 am
Jeff Moden (10/20/2007)
vadimt (10/18/2007)
i dont need it as a function because i need it only in one place in...
October 20, 2007 at 5:38 am
mrpolecat (10/19/2007)
declare @id intselect @id =( select top 1 n from tally where n > 5)
if @id is not null
begin
print 'yes'
print @id
end
else
begin
print 'no'
print @id
end
thanks.
i knew it was supposed to be...
October 19, 2007 at 8:16 am
Jeff Moden (10/18/2007)
the first solution didnt work. because of the Tally i didnt implement...
ps.
meanwhile the client "revised" some specs, so i do need these numbers now. but i still need...
October 18, 2007 at 8:11 am
Max Yasnytskyy (10/17/2007)
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE FUNCTION [dbo].[udfTRANSELATE] (@mixedString AS varchar(max))
RETURNS varchar(max)
as
BEGIN
DECLARE @resultString...
October 18, 2007 at 6:52 am
Greg Snidow (10/17/2007)
October 17, 2007 at 3:37 pm
Viewing 8 posts - 1 through 8 (of 8 total)