Forum Replies Created

Viewing 15 posts - 10,276 through 10,290 (of 13,460 total)

  • RE: SUM(Case) issue

    well, if there was only one in the "p" table for shift 3, the issue is your joins are bringing in 4 more rows, right? i would guess the other...

    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!

    December 2, 2009 at 7:49 am

    #1086496

  • RE: SUM(Case) issue

    well the SQL looks right, so it's gotta be the data not meeting your expectations.

    i would expect the SQL below to show you that there really is 4 items 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!

    December 2, 2009 at 7:06 am

    #1086455

  • RE: SQL Server 2005 Developer Edition - Licensing

    i believe by single developer, it is single installation. they do not want you to buy one copy and install it on 20 developers machines. 20 installations would require 20...

    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!

    December 2, 2009 at 5:17 am

    #1086377

  • RE: More efficient INSERT "blank row" statement.

    if your table t1 already has those values, you should be able to use the integer modulus to determine/select only those values that are perfectly divisible by 100; then do...

    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!

    December 2, 2009 at 5:06 am

    #1086372

  • RE: Delimited file import

    easily bob;

    if the table exists, or if you create a staging table, there's no porblem; you want to use BULK INSERT command to do it. your example seemed to be...

    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!

    November 30, 2009 at 9:31 am

    #1085496

  • RE: Strange "access denied" message - in the middle of set of queries

    when you run the profiler, does the spid in the loop change, or is it incrementing?

    if it was incrementing, that would imply to me that it is getting new connections.

    if...

    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!

    November 30, 2009 at 9:23 am

    #1085491

  • RE: Default value binding of columns using Trigger

    glad i could help!

    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!

    November 30, 2009 at 8:46 am

    #1085459

  • RE: Default value binding of columns using Trigger

    that's what i was hoping....that there was an Id, in your case, PersonId in the table. your modification looks good.

    you can easily test it with this, which would insert 4...

    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!

    November 30, 2009 at 8:37 am

    #1085448

  • RE: Strange "access denied" message - in the middle of set of queries

    well, I'm pretty sure you are running out of connections. it may have run without a problem previously, but breaking now because you are finally looping/creating more than 32767 connections.

    since...

    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!

    November 30, 2009 at 8:31 am

    #1085441

  • RE: Strange "access denied" message - in the middle of set of queries

    i've seen this before, but in a vb6 application; are you using .NET?

    opening and closing a connection takes resources, and time, since the server has to answer back with 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!

    November 30, 2009 at 7:43 am

    #1085409

  • RE: Default value binding of columns using Trigger

    i think this is more like what you want:

    CREATE TRIGGER tgrDefaultValue ON tblPerson

    FOR INSERT

    AS

    UPDATE tblPerson

    SET LastName = FirstName

    FROM INSERTED

    WHERE tblPerson.ID...

    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!

    November 30, 2009 at 7:33 am

    #1085399

  • RE: Query with index

    to take advantage of an index, you can't use any functions on the column in the WHERE statement; the isnull(name, '') = '' doesnt allow a Sargable search, 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!

    November 29, 2009 at 5:33 pm

    #1085205

  • RE: How to compare two tables from two servers.

    by changing, do you mean schema changes, ie new columns, defaults,constraints, datatype changes, etc, or do you mean data changes, like new rows of data,others updated/deleted

    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!

    November 26, 2009 at 6:59 am

    #1084584

  • RE: How to Modify SPs automatically to include the change of tableSchema

    PavanKK (11/26/2009)

    Hi All,

    I am new to adminstration. can you help me with following.....

    My application contains 300 tables & 1000procedures. Now am adding additional column to some tables ( say 180...

    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!

    November 26, 2009 at 6:19 am

    #1084570

  • RE: Anything other than Trigger ?

    I agree with Steve; a well written trigger would have no problem copying data to another table, so if you can show us your trigger code you tried, as well...

    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!

    November 25, 2009 at 4:42 pm

    #1084403

Viewing 15 posts - 10,276 through 10,290 (of 13,460 total)