for the other direction, when you have the full SSMS and you connect to a lesser isntance, it varies based on what you connect to; i have 2012 developer installed,...

CELKO (12/11/2012)

---

In COBOL, the display and the internal format of data was the same. Each field had a PICTURE clause to define it. Your question makes sense only in that...

as suggested: changinbg old style join to new style ansi JOIN..ON:

SELECT

tblTransactions.PO_Number,

tblTransactions.PO_Date,

tblTransactions.Quantity,

tblTransactions.Software_Description,

tblTransactions.Unit_Price,

tblTransactions.SoftwareShortName,

tblTransactions.Transaction_Number,

tblTransactions.Transaction_Type,

tblBulkPurchases.Quantity_Remaining,

...

Stuart what is the relevance of this WHERE statement coming from?

WHERE ttask.id = 23

are you only capturing queries that match a certain task type?

it looks to me like that would...

Chris Harshman (12/12/2012)

---

The problem is that SQL Agent is the program you'd typically use to do monitoring and alerting. It sounds like what you really need is some kind...

and what does the procedure sp_GetPublicKeyForSMSID do?

that's what's causing the exception i think...or at let the process that does the work.

...every minute sounds...

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...