Forum Replies Created

Viewing 15 posts - 4,726 through 4,740 (of 13,460 total)

  • RE: Importing and Splitting 150,000 columns flat file into three tables of 50,000 cloumns each

    just to pile on the bad news; Excel 2010 is limited to a max of 16384 columns.

    so you need a few more(10+?) worksheets or so.

    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!

    September 18, 2012 at 12:48 pm

    #1539238

  • RE: SSRS 2008 R2 Map report error while deploying

    I've tripped over this with some of our web services.

    it has to do with a default limit in the expected string size; i guess MS expected most services return tiny...

    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!

    September 18, 2012 at 12:25 pm

    #1539221

  • RE: unzipping files using 7zip

    is this more of a syntax question, or the wrong applicaiton, i wonder.

    i use the command line version of 7zip, which is 7za.exe;

    are you using the GUI version? I'm not...

    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!

    September 18, 2012 at 9:35 am

    #1539160

  • RE: Granting database access

    Brian Brown-204626 (9/18/2012)

    The SQL Server login already exists, but I need to grant access to a database from a T-SQL command, rather than use Management Studio.

    granting access to a database...

    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!

    September 18, 2012 at 8:24 am

    #1539120

  • RE: T-SQL Help Needed

    i just tripped over this exact lack of planning by the database architect when switching from one insurance agency to another. From Geico to Progressive: I saved 30% or more...

    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!

    September 18, 2012 at 7:52 am

    #1539105

  • RE: how to get current year

    two built in functions should get you what you are after:

    SELECT YEAR(getdate())

    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!

    September 18, 2012 at 6:56 am

    #1539068

  • RE: Creating a view becomes a SYSTEM object?!

    in SQl 2000, it was certainly possible to leave a setting ON so that subsequent objects were created as system objects.

    once an object is marked as a system object, you...

    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!

    September 18, 2012 at 6:28 am

    #1539056

  • RE: Granting database access

    i think it's because of two things:

    when you create a SQL user, that implicitly grants the CONNECT permissions; logins from the domain already exist, so it makes sense...

    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!

    September 17, 2012 at 2:32 pm

    #1538814

  • RE: Standard Edition Auditing

    There is no DML Event Notifications;

    there used to be a mistake in the documentation that seems to imply it, but if you look at the actual events available, they are...

    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!

    September 17, 2012 at 9:18 am

    #1538667

  • RE: Difference between a CROSS JOIN and a 'comma'

    that's because the old comma syntax didn't support left/right joins without that old =* or *= syntax (or the oracle the old styles pretty muich only inner joins without them

    =columnname(+)...

    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!

    September 14, 2012 at 6:55 am

    #1537797

  • RE: Difference between a CROSS JOIN and a 'comma'

    yes it's true; there are two ways to cross join tables.

    SQL server supports the old syntax of FROM TABLE1,TABLE2 as well as the more modern, explicit FROM TABLE1 CROSS JOIN...

    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!

    September 14, 2012 at 5:26 am

    #1537740

  • RE: Using Print, will it slow down procedure?

    here's the data as a readyly consumable CTE;

    if i knew what the process was doing, we could add a lot more to this:

    With MyTableExample ([Doc Number],[Document Date],[Rec Date],[Book],[Vol],[Page],[Doc Type],[# 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!

    September 13, 2012 at 2:53 pm

    #1537501

  • RE: Standard Edition Auditing

    oh yeah, i'm very familiar with the server side trace, but that only can capture the command text that was executed, for example.It cannot catch old versus new values, which...

    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!

    September 13, 2012 at 2:49 pm

    #1537496

  • RE: Using Print, will it slow down procedure?

    CptCrusty1 (9/13/2012)

    I thought I WAS using set-based processing. I"m definitley not using a cursor.....

    Pray tell... more feedback on what you're refering to...

    BTW... RBAR.......

    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!

    September 13, 2012 at 2:46 pm

    #1537491

  • RE: linked database opinion?

    sqlguy-736318 (9/13/2012)

    What if the core datamodel is for read-only purposes? Applications could each have their own database and connect to the core database for read-only purposes.

    If all the databases reside...

    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!

    September 13, 2012 at 2:42 pm

    #1537490

Viewing 15 posts - 4,726 through 4,740 (of 13,460 total)