Forum Replies Created

Viewing 15 posts - 1,921 through 1,935 (of 13,460 total)

  • RE: Getting this error while setting up the operator using DBArtisan tool.

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

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    March 3, 2015 at 12:52 pm

    #1781471

  • RE: Generate pdf

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

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    March 3, 2015 at 9:01 am

    #1781399

  • RE: Data Compare

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

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    March 3, 2015 at 7:12 am

    #1781343

  • RE: Identify Columns and/or Tables from records

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

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    March 3, 2015 at 6:44 am

    #1781338

  • RE: SSRS report not displaying Time values Correctly from SQL Server table

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

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    March 2, 2015 at 2:44 pm

    #1781224

  • RE: combine two separate queries

    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,

    ...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    February 27, 2015 at 1:54 pm

    #1780785

  • RE: combine two separate queries

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

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    February 27, 2015 at 7:19 am

    #1780587

  • RE: Do you know where i can find the famous stored procedure

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

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    February 26, 2015 at 2:11 pm

    #1780406

  • RE: Do you know where i can find the famous stored procedure

    maybe this one from Narayana Vyas Kondreddi?

    http://vyaskn.tripod.com

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

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    February 26, 2015 at 1:29 pm

    #1780391

  • RE: How do we generate csv with custom data?

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

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    February 26, 2015 at 1:22 pm

    #1780384

  • RE: Search all tables for Primary key value

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

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    February 26, 2015 at 12:30 pm

    #1780368

  • RE: Top most manager name with out CTE

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

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    February 26, 2015 at 8:08 am

    #1780277

  • RE: Last Table READ and WRITE

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

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    February 26, 2015 at 6:57 am

    #1780232

  • RE: Storing Images in Database

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

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    February 26, 2015 at 6:55 am

    #1780230

  • RE: splitting paramarray into groups of four with an offset

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

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    February 25, 2015 at 2:39 pm

    #1780068

Viewing 15 posts - 1,921 through 1,935 (of 13,460 total)