the theoretical limit is 32767, but i think it has more to do with disk space and memory capacity.

http://msdn.microsoft.com/en-us/library/ms143432.aspx#Engine

i think you could fix it easier with a design change;

each attempt to contact, whether successful or not, inserts into a new table; a view gets added that shows the...

tnnelzo (6/20/2013)

---

It is always from the first day of the current month....to the current day

and b.date_entered >=cast('2013-06-01 00:00:00.000' as datetime)

and b.date_entered < cast('2013-06-20 00:00:00.000'as datetime)

and when the month ends...

tnnelzo (6/20/2013)

---

Hello lowell,

Here is the querry i run everyday,

Select day(b.date_entered)Day_D, sum(a.despatched_qty), sum(a.val) from scheme.dgtable1 a, scheme.dntable3 b

where a.order_no = b.order_no

and a.product like 'Machines%'

and b.date_entered >=cast('2011-05-01 00:00:00.000' as datetime)

and b.date_entered...

well, it depends.

have you set...

well, who in your company has a windows handheld device, vs having an android or iphone/ipad? in my shop of 30 developers, there are no windows based portable devices.

I would...

it depends on the "report"

Since you said it's a query, i assume you must be running it, copying it into an excel or something, and email it?

or formatting as HTML?

or...

here's a classic example of what J Good is talking about;

the proc below runs under elevated priviledges, so i can grant a normal user EXECUTE ont eh procedure to allow...

i have always converted IP's to big ints so that i could do cmparison and ranges;

something like this in your table setup can help:

DECLARE @IPInfo TABLE

(

MachineId int NOT NULL,

IPAddress varchar...

for a single table, i have this saved from Jason's website(the guy who posted before you

--http://jasonbrimhall.info/2011/07/11/foreign-key-hierarchy-update/

--SET XACT_ABORT ON

--BEGIN TRAN

DECLARE@StartParentTableVARCHAR(256)

SELECT @StartParentTable = 'GMACT'

;With Hierarchy (ParentTable,ParentColumn, ChildTable,ChildColumn, FKLevel, SortCol)...

also, modify Kingstons' execellent example with this:

INSERTsalesorder

SELECT3 UNION

SELECT NULL

and the query will return nothing, because the IN() list must be all non null values, otherwise, nothing gets returned.

it depends on why the job fails i guess;

one possibility might be to have the job use SET XACT_ABORT ON, and put it in a transaction; then if an error...

well, the NOLOCKS bother me enormously, it is not a magic "go fast" button for SQL, it has a lot of dark ramifications like missing or duplicate data.

as far...

RPSql (6/18/2013)

---

Is there a way to structure a single query to select all the unique values from field 1 of table A, and the unique values from field 2 of...

if you know there is a maximum number of distributores, it's pretty easy; for example, this would assume a max of five distributora records:

WITH CTE AS (

SELECT customer#, customername,

...