Geeks With Blogs
Gaurav Taneja Great dreams... never even get out of the box. It takes an uncommon amount of guts to put your dreams on the line, to hold them up and say, "How good or how bad am I?" That's where courage comes in. January 2009 Entries
Sequence Number Generation + sqlserver
CREATE @intShowVersion @strRotationName @strTrainOperator @strArrDate @strOut PROCEDURE [dbo].[GenTrainRandNo] tinyint, varchar(20), varchar(50), datetime, varchar(15) output AS SET NOCOUNT ON IF ELSE (@intShowVersion = 1 ) BEGIN SELECT VERSION='$Revision: 1 $' RETURN 0 END BEGIN DECLARE @intError AS INTEGER DECLARE @strYear AS VARCHAR(4) DECLARE @bitUseYear AS BIT DECLARE @strPrefix AS VARCHAR(10) DECLARE @intCurrentVal AS INTEGER DECLARE @strLen AS INTEGER DECLARE @strCurrentVal VARCHAR(15) SET ......

Posted On Thursday, January 15, 2009 8:50 PM

Copyright © Gaurav Taneja | Powered by: