adding some background, because i didn't know what 610 did, let along as it pertains to availability groups

http://sqlblogcasts.com/blogs/simons/archive/2010/11/17/trace-flag-610-when-should-you-use-it.aspx

---

Trace Flag 610 – When should you use it?

Thanks to Marcel van der...

to find the percentile, you need the age, gender and BMI. then you could use a lookup table.

Body mass index-for-age percentiles: Boys, 2 to 20 years

i had a similar issue, which might help.

i wanted to start adding filtered indexes...indexes with WHERE statements; as soon as i added the first one, some processes started throwign that...

it SO depends on what you want to export.

what is actually in the PDF? a tablular looking/rows and columns? colored headers?

it's very easy to export to HTML from SQL, as...

i think your implementation of concatenation on either one is wrong.

'121'+'34' or '12' + '134' = '12134', which is a problem with your calculation.

whether hasbytes or either of...

while it's possible to search every column in the database for a specific value with a big old nasty slow cursor that cripples other users performance while you are using...

can you convert it to varchar(11) in your report datasource?

this produces the expected format, and cuts off the trailing zeros from a simple CONVERT(varchar,@CPUTM)

/*--Results

(No column name)(No column name)

00:00:00.8200:00:00.8200000

*/

DECLARE @CPUTM [time]...

i forgot the alias for the max:

MAX(ais_data.mssisdtg1) AS mssisdtg1

select

ships.name,

ais_data.mmsi,

ships.country,

ais_data.course,

ais_data.sog,

ais_data.heading,

...

it looks like some inline strings/code that is being constructed in c#, which is then being executed, presumbly by LoadDatatable?

i'm not sure where =\'" + dtg + "\' is...

mw112009 (2/26/2015)

---

Tried that web page. it is not there any more...

You can share yours if you like.

The only good thing is he had written in in such a way that...

maybe this one from Narayana Vyas Kondreddi?

http://vyaskn.tripod.com

I've been using a modified and renamed version of his for years.

the end user is going to be using TSQL to send files to disk, or is this some sort of automated process that you are envisioning?

in my case, i have...

krypto69 (2/26/2015)

---

Hi,

I found a few 'SearchAllTables' scripts out there to help me find a value in any table/column/row of any Database.

My problem is that none of these database search queries...

recursive CTE is the way to go. no doubt about it, and no way around it.

just stick the top results of your recursive query in a temp table or...

pretty...