hi Razvan Socol

the give none working fine, but this query is populating up to 32767 rows only. After that its giving error. can u please provide the information regarding that.

I don't know what the original post was, but you may want to look at the Red
Gate Data Generation Tool.

John

As I cannot find the original post, or the SQL used to generate your data, I
would suggest you look at the SQL to see if you are using an INT field as an
incremeneting couter within a loop construct.  If I'm guessing right, you
are exceeding the size of the INT within a loop.

If I'm wrong .... my bad ... just disregard.

Regards

Shane Brodie


Show quoteHide quote

Hello, Shane

My original post is here:
http://groups.google.com/group/microsoft.public.sqlserver.server/browse_frm/thread/78e662cc6be03253/eb38233a18391f0e

The problem is not related to the int data type, but to the usage of
master.dbo.spt_values. If more than 32767 rows are needed, then this
table should to be joined to itself three or more times (instead of
two times, like I did in the original post). Of course, one may create
his own table of numbers, using as many numbers as he wants. Or, if we
are talking about SQL Server 2005 or later, use a CTE to generate
numbers, like shown here:
http://www.projectdmx.com/tsql/tblnumbers.aspx

Razvan

Lumigent Log Explorer - where to get it?
Database Mirroring not synching till I open Mirroring Monitor
12m ghost records
sys.sp_dbmmonitor* procedures missing from msdb at mirror
Should I enable AWE on 32-bit SQL 2005 EE running on 64-bit Window
NCHAR -> CHAR COLLATION problems
issue with data format in joining tables
Connections between 2 SQL Servers
high table/index fragmentation
Performance Tuning a DB