Forum Replies Created

Viewing 15 posts - 8,191 through 8,205 (of 13,460 total)

  • RE: Sql help: Triggers

    i think you'll want to search a bit more here on SSC for a better example of auditing changes.

    first, your example table is missing a primary key...so for your example,...

    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!

    January 25, 2011 at 2:04 pm

    #1278181

  • RE: BCP Not Working

    he means you have to run the full path: something like this instead:...this is the path on my specific machine:

    C:\Program Files\Microsoft SQL Server\100\Tools\Binn\bcp.exe

    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!

    January 25, 2011 at 9:20 am

    #1277959

  • RE: Maximum number of Simultaneous Users

    no i was thinking that you should run monitoring tools against your live server and gather statistics that help identify your bottlenecks;

    there's a link on this thread that has 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!

    January 24, 2011 at 3:29 pm

    #1277499

  • RE: Maximum number of Simultaneous Users

    the identity() columns themselves are not a problem; I read an

    article years ago where SQL2000 could handle 400 new identity values per second in a table...and that was given...

    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!

    January 24, 2011 at 3:15 pm

    #1277490

  • RE: SELECT latest transactions

    by using the row_number() function,a nd a subquery to limit the results ot the row number, you'll get one(max) record for each account...that's because of the partition by.

    try this:

    SELECT AccountNbr,...

    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!

    January 24, 2011 at 3:09 pm

    #1277487

  • RE: Add a new user account with certain priviledges

    one of the options in SSMS is that you can script out any command you are doing in the GUI...

    the way to do it is as follows:

    1. create 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!

    January 24, 2011 at 2:33 pm

    #1277479

  • RE: Add a row number column while creating a temp table

    another option is to use the IDENTITY() function, which is allowed when you use the SELECT INTO format to create an identity column in the dynamically created table:

    SELECT

    identity(int,1,1) 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!

    January 24, 2011 at 2:05 pm

    #1277466

  • RE: T SQL FOR JOINING DIFFERENT TABLES on different databases with different credentials

    to use openrowset or openquery, adhoc would need to be enabled; if that is not possible, then linked servers, or using a login that has access to both databases would...

    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!

    January 24, 2011 at 12:32 pm

    #1277419

  • RE: T SQL FOR JOINING DIFFERENT TABLES on different databases with different credentials

    I think linked servers would allow you to change authentication information, but you didn't want to do that...

    The openrowset command lets you specify the connection information, you might roll both...

    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!

    January 24, 2011 at 11:21 am

    #1277387

  • RE: Update Triggers

    even worse, i believe the UPDATE() and COLUMNS_UPDATED() returns which columns were REFERENCED in the update statement, not which ones actually changed their value...since a lot of datalayers would send...

    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!

    January 24, 2011 at 9:13 am

    #1277277

  • RE: Random ordered groups

    so correct me if i'm wrong, but you might want a sampling, like a random top 3 per group, right?

    if that is the case, it's deceptively simple...a CTE and newid...

    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!

    January 23, 2011 at 11:35 am

    #1276993

  • RE: Dialog box

    can you check the version of the instance you are connecting to? it might be that that instance is, say RTM, but your client tools are using SP4 or something,...

    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!

    January 23, 2011 at 8:58 am

    #1276975

  • RE: Foiled By SQL Azure Again

    i haven't tried Azure yet, but why can't you create a permanent Tally table and use 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!

    January 22, 2011 at 9:03 am

    #1276899

  • RE: Parameter with \ (backslash) not parsing properly

    Looks like the server name in @REMSServer has TWO slashes in it, the way C languages tend to escape the slashes.

    can you PRINT @REMSServer and confirm the value is NYSQL004\NYSQL004...

    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!

    January 21, 2011 at 12:09 pm

    #1276726

  • RE: Increment a variable by another variable in a select statement

    doh rereading based on getoffmyfoot's comments, you are definitely looking for a running total kind of solution.

    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!

    January 20, 2011 at 2:11 pm

    #1276254

Viewing 15 posts - 8,191 through 8,205 (of 13,460 total)