Forum Replies Created

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

  • 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

  • RE: how to move the table to another drive with out taking them to offline?

    Krisn (4/26/2010)

    Hi all,

    could you please let me know how to move the table to another drive with out taking them to offline in sql 2k?

    thanks in advance,

    regards,

    Kris

    Kris if you alter...

    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 8:16 am

    #1157639

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