Forum Replies Created

Viewing 15 posts - 9,601 through 9,615 (of 13,460 total)

  • RE: Very slow with php iis6

    times are now in the millisecond range:

    2 rows selected it took 0.002 seconds. ...

    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!

    April 27, 2010 at 11:36 am

    #1158395

  • RE: Need advice to prevent Insert

    not sure how you handle checking in on hte same day someone else checks out; if i leave on 05/07/2009, someone else presumably could check in on the same date,...

    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!

    April 27, 2010 at 11:34 am

    #1158393

  • RE: Need advice to prevent Insert

    awesome that you posted the table structure and sample data; it made my creation of a possible solution and testing so easy. thank you!!!

    The only way i see is 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!

    April 27, 2010 at 11:22 am

    #1158388

  • RE: Very slow with php iis6

    anthony when i tested, i was getting sub-second query times around 0.700 secs or so according to your page;

    i guess we could help more if we saw the actual query...

    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!

    April 27, 2010 at 10:57 am

    #1158376

  • RE: Missing Foreign Keys

    ally this might get you started:

    i made this script a long time ago for SQL 2000, so it does not take schemas into consideration;

    it makes the following assumptions:

    the PK 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!

    April 27, 2010 at 10:50 am

    #1158374

  • RE: T-SQL - some HELP

    just syntax...there is no IF<condition>THEN<statement>, only IF <condition><statement>

    IF EXISTS (SELECT DATEPART(hh, scheduledtime)

    FROM intakesource_daily

    ...

    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!

    April 27, 2010 at 9:11 am

    #1158311

  • RE: Constraint for 2 fields to be consistent

    ok that helps explain the logic, thanks.

    is there a master table that has value like this?:

    1 Gary

    2 Terry

    3 Bob

    so we could lookup/compare the proper name 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!

    April 27, 2010 at 6:34 am

    #1158158

  • RE: Question

    not enough info;

    you have a table with salaries, what does it contain? do you mean a base rate of pay? is it an hourly rate, so $10 dollars an...

    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!

    April 27, 2010 at 5:57 am

    #1158133

  • RE: Constraint for 2 fields to be consistent

    terry you'll need to explain the "rules" a bit clearer. I'm not sure why a unique index on the two columns does not do what you want.

    i'm just guessing, but...

    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!

    April 27, 2010 at 5:44 am

    #1158120

  • RE: Getting Unique Data From Two Tables

    I'm venturing a guess that you might not be familiar with creating a join on more than one column...like you said, it's intuitive if you had a unique column.

    what might...

    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!

    April 26, 2010 at 7:37 pm

    #1157956

  • RE: create a view for the entire Database with Indexes (Excluding UniqueIdentifier fields) .

    skb 44459 (4/26/2010)

    This will work just fine.

    But i would like to create the indexes as well.

    The views will use the existing indexes that are already on the tables; no...

    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!

    April 26, 2010 at 2:14 pm

    #1157873

  • RE: create a view for the entire Database with Indexes (Excluding UniqueIdentifier fields) .

    i had a little trouble reading what you wanted, but i think i got it.

    1. you want to create a view for every table in the database, but exclude one...

    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!

    April 26, 2010 at 12:44 pm

    #1157807

  • RE: How To Send Message To All Connected User On Insert In A Table

    but with Service Broker, you are sending emails and such, right? I thought the original poster was saying he wants a form to open up on everyone who 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!

    April 26, 2010 at 12:16 pm

    #1157785

  • RE: PLEASE HELP !!!!

    David with luck this will get you oriented.

    you need to open SQL Server Management Studio, and get the object explorer on the left side opened up; once you have 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!

    April 26, 2010 at 12:14 pm

    #1157783

  • RE: Trying to use variables in a view.

    the error tells what the issue is, but it might be a little new to you for debugging these kinds of issues.

    to really help; we'd have to see the code...

    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!

    April 26, 2010 at 9:32 am

    #1157700

Viewing 15 posts - 9,601 through 9,615 (of 13,460 total)