Viewing 3 posts - 1 through 3 (of 3 total)
In my "live data" that does not give me the proper break in sequences.
February 21, 2012 at 6:18 am
#1449654
IF OBJECT_ID('TempDB..#SampleData','U') IS NOT NULL
DROP TABLE #SampleData
CREATE TABLE [dbo].[SampleData](
[Company_ID] [nvarchar](50) NOT NULL,
[Unit_ID]...
February 16, 2012 at 1:39 pm
#1448122
they are not nulls. the table appears just as shown in the example. I need to scan the table for missing sequences in the TX_NUM column
February 16, 2012 at 12:41 pm
#1448099