No cursor required as Luis said, but I think this may be what you are after, based on the description.

Perhaps if you could provide some expected output from that data,...

It's not about...

You can use a subquery to grab the Prodacts, like this:

select Person.Saler

, (

select Prodacts.Prodact

, Prodacts.Quantity

...

Is that time linked in any way to a date and if so, do you care about incrementing the data after midnight and do you care about Daylight Saving? (Adding...

Yes, it's used for various management tasks (for example, rs.exe uses it for command line management) and can be used in links to individual reports where the Report Manager interface...

Unfortunately, you can't do much about the Report Manager layout as the content is compiled into the application.

You can modify the CSS though, and if you were to add this...

It's the Report Manager interface you want, http://localhost/Reports_SQLEXPRESS

If you are not seeing the link to report builder on the report manager page, then you could try installing it directly.

http://www.microsoft.com/en-gb/download/details.aspx?id=42301

Isn't it also the case that using LIKE allows the QO to use statistics to estimate the selectivity of the query.

According to this White Paper: https://msdn.microsoft.com/en-us/library/dd535534(v=sql.100).aspx

String Summary Statistics

SQL Server 2008...

To account for repeated letters, I use row_number() partitioned by letter to assign a "positional" value.

So, for the word "test", the results of CTE "LETTERS1" would be

L P

e ...

Here's one, but it's not quick and I can't think of a way to make it quick, but maybe someone else can.

CREATE FUNCTION FindDifferenceCount(@string1 AS VARCHAR(50), @string2 AS VARCHAR(50))

RETURNS TABLE

WITH...

Lynn Pettis (10/9/2015)

---

I tried posting the hard way to do it but can't from here. So, replace the call to dbo.GetInvoiceIDFromBillID with the following to see what I did,...

Here's an alternative that will work, but not got around to performance testing yet, sorry.

CREATE FUNCTION dbo.GetInvoiceIDFromBillID(@Input VARCHAR(20))

RETURNS VARCHAR(20)

WITH SCHEMABINDING

AS

BEGIN

-- Function to extract all characters from the first numeric...

Further "interest" comes from comparing XML to JSON in SQL 2016.

context avg_duration (ms) avg_cpu_time (ms)

xml 4147.091600 ...

Kim Crosser (10/7/2015)

---

Brilliant! This is exactly why I posted here. I was hoping someone on the forum would come up with a new approach.

I would never have thought...

Eric M Russell (10/7/2015)

---

mister.magoo (10/7/2015)

---

Eric M Russell (10/7/2015)

---

mister.magoo (10/6/2015)

---

I don't know whether your setup would suit this, but how about converting to xml , then using hashbytes?

select MBT.refID,

...