no insults, just help with the logical rules of thumb for procedures and functions:

avoid loops whenever possible: that's cursor, while loops whatever;

like everything in SQL, there's more than one...

ok capn; you just need a function that expands the integers that should bebetween tow numbers as a comma delimited list, is that right?

here's both an ITVF and a scalar...

mpdillon (12/11/2012)

---

I need to find a faster way to return records from an order history table. The item numbers are all numeric. The digits of the item number have a...

bartvdc (12/11/2012)

---

I'm yet another user of this great procedure. Lowell, thanks for the work and sharing.

I'm using it to (re)create tables from within a java app. I just have...

the better question is do you REALLY need to install another instance in the first place, if you already have SQL installed?

Having a single instance provides a single centralized point...

I would basically do it the same as anthony; they are already in a table, so not temp table or cursor required.

I kind of like some of the built in...

the questions too vague for a solid answer; we have to see teh server side code, which is connecting/doing SQL stuff/disconnecting to be able to help at all.

any specific, exact...

it's just example WHERE statement for the data; your query which gathers the "right" emails would be very specific to your business logic, and especially the WHERE statement which...

a rough example of multiple recipients from a query, unique emails, same attachment:

declare

@isql varchar(2000),

@email varchar(64)

declare c1 cursor for select distinct email FROM...

so you want to send 100 individualized emails, each with the same (or different?) attachment?(hint: cursor)

or do you want to send a single email, with 100 To:/CC:/BCC:/ and the same...

try using a CASE statement to filter out the rows that have a zero denominator

something like this is my first guess:

CASE

WHEN DATEDIFF(SECOND,dr.startTime,dr.endTime) = 0

THEN 0

...

Alex, you posted the estimated execution plan, which shows a nice expected clustered index scan; i think we need the actual execution plan, where it's being returned slowly via SSMS...

in that case, baring slow network issues, i'd think the first thing is to look at the execution plan, and the real query;

anything from parameter sniffing, out of date statistics,...

marlon i looked at this page, and osql @ the cmd prompt, and this is what i think:

i tried to put comments in, i hope the comment start chars are...

I think SQLHeap has got the core issue. linked servers have performance issues you need to be aware of.

try these two things on the server witht eh linked server on...