Forum Replies Created

Viewing 15 posts - 8,701 through 8,715 (of 13,460 total)

  • RE: Install Issues

    seems like your column EEO1Classification is actually a varchar even though it might contain what seems to be just integers....so you'll have to explicitly convert it to do the sum...

    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!

    September 22, 2010 at 10:22 pm

    #1226050

  • RE: Procedure not executing in trigger

    what would happen if your procedure received NULL for either of the two parameters? could it raise an error?

    exec [sp_ETL_To_Rpt] @frmdt,@todt

    since your trigger says it's also for DELETE, and 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!

    September 22, 2010 at 10:19 pm

    #1226048

  • RE: GetDate() or CURRENT_TIMESTAMP

    i use getdate() excluseively; like others havre said, it's been in my repitoir for years, and also because of that datatype where a timestamp is not really a timestamp, 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!

    September 22, 2010 at 11:00 am

    #1225774

  • RE: SQL Server Table Structure, StartDate and EndDate

    ok, this example, based on your provided data seems to work for me;

    i'm assuming the discount rates are added to the same table...but i hope it is obvious that 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!

    September 21, 2010 at 7:01 am

    #1224763

  • RE: SQL Server Table Structure, StartDate and EndDate

    interesting wissam;

    the excel spreadsheet you receive, does the start and end date apply only to the short term offer? so for one month some rate is slightly cheaper, but 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!

    September 21, 2010 at 4:23 am

    #1224654

  • RE: Disabling the Named Pipe Protocol in SQL Server

    Ratheesh.K.Nair (9/19/2010)

    The application wont connect to database...

    For remote connection you should enable both TCP\IP and NAMED PIPES

    i don't think that is true; SQL will simply use only the TCP/IP instead;...

    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!

    September 20, 2010 at 2:29 am

    #1223852

  • RE: GetDate() not working

    it's they way a default constraint works...i think you are misunderstanding it.

    a default constraint DOES NOT replace nulls with the default value...it puts the default value in if the column...

    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!

    September 20, 2010 at 2:24 am

    #1223850

  • RE: Importing excel data with preceding '0's into SQL Server

    is the length of the fields with preceding zeros all the same? for example are the 6 characters? '000008'?

    you can change the column to a varchar, and then update...

    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!

    September 20, 2010 at 2:12 am

    #1223847

  • RE: Replace function accross entire table

    not directly, no.

    each column has to be referenced in the update statement, but you can use the schema tables to generate the SQL statement for you.

    you were a little loose...

    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!

    September 19, 2010 at 3:08 pm

    #1223710

  • RE: SQL count

    here's another way to do the same thing: ColdCoffee thank you for the setup!:

    DECLARE @PhoneNumbers TABLE

    (

    ID INT IDENTITY(1,1),

    TEL1 BIGINT,

    TEL2 BIGINT,

    TEL3...

    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!

    September 19, 2010 at 10:44 am

    #1223652

  • RE: How to prevent our database to access any person

    kumar.sachu08 (9/19/2010)

    I hope microsoft will provide, any facility for the same in future.

    Sometime such cases come for DBA or developer. He don't want to share own database

    Sachin

    the technology already exists....

    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!

    September 19, 2010 at 10:37 am

    #1223651

  • RE: How to prevent our database to access any person

    I know the feeling...you put a lot of hard work and time into designing the database objects, and you don't want anyone to look at them because they could infer...

    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!

    September 19, 2010 at 7:07 am

    #1223610

  • RE: Efficient ways to reset lost sql sa password

    another way is to connect via the Dedicated Administrative Connection (DAC)

    a perfect example would be you removed builtin\administrators and then forgot the sa password...which was the only sysadmin on your...

    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!

    September 19, 2010 at 6:58 am

    #1223608

  • RE: SQL Server Management Studio’s Dropdown box contains server list not exist

    I had a similar issue where a specific login i created for testing would show up first when i selected a server...so i'd have to change it over and over...

    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!

    September 19, 2010 at 5:16 am

    #1223600

  • RE: (sql 2008) t-sql concurrency question.

    nice explanation, Craig;

    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!

    September 18, 2010 at 5:02 am

    #1223454

Viewing 15 posts - 8,701 through 8,715 (of 13,460 total)