Viewing 15 posts - 1,921 through 1,935 (of 13,462 total)
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...
March 3, 2015 at 12:52 pm
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...
March 3, 2015 at 9:01 am
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...
March 3, 2015 at 7:12 am
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...
March 3, 2015 at 6:44 am
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]...
March 2, 2015 at 2:44 pm
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,
...
February 27, 2015 at 1:54 pm
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...
February 27, 2015 at 7:19 am
mw112009 (2/26/2015)
You can share yours if you like.
The only good thing is he had written in in such a way that...
February 26, 2015 at 2:11 pm
maybe this one from Narayana Vyas Kondreddi?
I've been using a modified and renamed version of his for years.
February 26, 2015 at 1:29 pm
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...
February 26, 2015 at 1:22 pm
krypto69 (2/26/2015)
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...
February 26, 2015 at 12:30 pm
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...
February 26, 2015 at 8:08 am
arrjay (2/26/2015)
Perfect! Thanks.The results don't include objects which have not been written/read to/from i.e. nulls. Is there a way of returning these stats? Thanks again.
pretty...
February 26, 2015 at 6:57 am
the file must exist on the server, unless you explicitly call a unc path like \\servername\c$\Files\12656.jpg
even then, the service account that SQL runs under must be the one with permissions...
February 26, 2015 at 6:55 am
ok while this gives me the desired results, it bothers me to be using distinct.
under the covers it's twisting these five rows into 250K rows, and back down to ~1300...
February 25, 2015 at 2:39 pm
Viewing 15 posts - 1,921 through 1,935 (of 13,462 total)