Forum Replies Created

Viewing 15 posts - 526 through 540 (of 13,460 total)

  • RE: Stored Procedure Help Required: Updating A Users Balance For Every Bet Won

    I didn't have your real table structure, but this is a best guess on if you HAVE to have a static table
    CREATE PROCEDURE [dbo].[UpdatePayout]
    @accountID uniqueidentifier
    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!

    May 12, 2017 at 7:21 am

    #1942322

  • RE: Stored Procedure Help Required: Updating A Users Balance For Every Bet Won

    my first reaction is thinking outside the corner you are painting yourself in.
    a balance like that should be calculated on demand, as a query or as a view, 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!

    May 12, 2017 at 7:04 am

    #1942317

  • RE: Copy data from flat file with multiple headers

    if you are only removing repeating header, you might consider using a  conditional split that tests the string;
    then the conditional split can redirect the headers, or maybe do nothing...

    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!

    May 11, 2017 at 9:58 am

    #1942187

  • RE: FK constraints and sp_rename

    the FK's point to the object_id of that lookup table,and not the name. you can see that is some of the sys views, like select * from sys.foreign_keys; the name 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!

    May 10, 2017 at 6:56 pm

    #1942113

  • RE: remove the characters and need to show only Numbers

    there are a number of "StripNonNumeric" functions here on SSC scripts section:
    http://www.sqlservercentral.com/search/?q=StripNonNumeric

    I would strongly recommend either of the inline table value function that Sean Lange or Alan...

    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!

    May 10, 2017 at 5:52 am

    #1941961

  • RE: How to Delete an SSAS .ABF File from HDD

    Like Sue suggested, i use Powershell, as a scheduled job step to remove any abf files older than x number of days.
    not sure how you are backing up, in...

    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!

    May 9, 2017 at 12:11 pm

    #1941868

  • RE: Missing SSISDBBackup.bak

    is there any chance that when you installed Developer2016, you didn't install Integration Services? this screenshot shows the checkbox unchecked; i'd suspect that that might be issue. SSDT is the...

    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!

    May 9, 2017 at 11:43 am

    #1941864

  • RE: Insert data into a table without disabling the constraints (pk and fk)

    sounds like an order-of operations issue, right? insert into the parent tables, first, then move on to the tables that are FK'd to the tables.
    the built in microsoft procedure...

    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!

    May 9, 2017 at 11:11 am

    #1941858

  • RE: Help needed with configuring sp_rename ( Works well but how do we include the schema name )

    you are probably looking to move an object to the other schema. THERE ALTER SCHEMA command lets you move a schemaname.object name into a specific schema.

    if i "develop"...

    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!

    May 9, 2017 at 11:03 am

    #1941856

  • RE: Upgrade Advisor Errors

    not sure if it is related, but back when i had 2008/R2 instances, i had the built in procedure sp_spaceused return the same error, because i had some very large...

    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!

    May 8, 2017 at 12:00 pm

    #1941656

  • RE: Missing SSISDBBackup.bak

    Just checking the basics, but is there any chance that the server you are connecting to is an Express instance, and not Developer/Standard/Enterprise?
    If it were express, I'd expect a...

    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!

    May 8, 2017 at 11:47 am

    #1941650

  • RE: problem in connect tosql of internet

    he said he is getting this error:

    login field login for 'sa' (microsoft sql server , error:18456)

    that means he's successfully connected to an instance.
    so 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!

    May 6, 2017 at 7:39 pm

    #1941454

  • RE: Grabbing sets less than an arbitrary number; not quite a bin packing problem

    Luis you posted your solution between the time i looked again; your's works as well, thank 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!

    May 4, 2017 at 11:54 am

    #1941137

  • RE: Grabbing sets less than an arbitrary number; not quite a bin packing problem

    OK walking away and doing a mental reset let me see my issue, or at least come up with a working solution
    i *think* i had two things going on. 

    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!

    May 4, 2017 at 11:51 am

    #1941135

  • RE: Why is this user able to work even when the login doesn't exist?

    it could also be nested permissions in Active Directory too.

    So The users in [OURDOMAIN\SomeUsers] Are in [OURDOMAIN\BusinessAnalysts], and  [OURDOMAIN\BusinessAnalysts] was explicitly granted access.

    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!

    May 2, 2017 at 3:21 pm

    #1940795

Viewing 15 posts - 526 through 540 (of 13,460 total)