Forum Replies Created

Viewing 15 posts - 5,611 through 5,625 (of 13,460 total)

  • RE: Reading microseconds from Sql server into oracle 10g

    milliseconds requires systimestamp, and ss is seconds no matter how many times you repeat it in a string...it's a format mask. you mean to use something like FF2, FF3, FF6...

    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 10, 2012 at 2:20 pm

    #1471505

  • RE: Unclosed quotation mark after the character string

    i'm guessing it's a truncation issue with a field cast to varchar.

    if your driver is older, it might not support xml or varchar(max), and is casting the string you said...

    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 10, 2012 at 2:07 pm

    #1471499

  • RE: Reading microseconds from Sql server into oracle 10g

    are you using the Oracle TO_DATE() function to convert the data?

    what is your string format for the conversion?

    edit

    jsut read you need to use TO_TIMESTAMP() in oracle to get fractions 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 10, 2012 at 1:36 pm

    #1471487

  • RE: rows repeating

    hbtkp (4/10/2012)

    i am getting result like

    item1 item2 item3

    1 pen 34

    1 pen...

    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 10, 2012 at 12:56 pm

    #1471445

  • RE: floating error

    well, after correcting the extra parenthesis in your example, i'm not seeing the specific issue why it might overflow;

    possibly the table has a huge number of rows?

    the field "filed" 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 10, 2012 at 12:49 pm

    #1471437

  • RE: Banker''s rounding in T-SQL (like Math.Round in .NET)

    softech (4/10/2012)

    The speed is poblem !!

    This funkction is about 10 times slower then standard round()

    That is one of the other factors for this: a different solution is required to 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!

    April 10, 2012 at 12:37 pm

    #1471421

  • RE: Sudden fail of (long-time) scheduled db backup with OS error 5/Error 3201/Error 3013.

    thinking along the same lines as calvo...i think the issue is outside of SQL server:

    could the password have expired for the local/domain user that is used to run the SQL...

    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 10, 2012 at 11:50 am

    #1471394

  • RE: Enumerate single row to multiple rows

    it's not that difficult to do, but you need a Tally Table to do it.

    try this and you'll see it's generating the values as requested, but you'll wnat to test...

    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 10, 2012 at 11:25 am

    #1471379

  • RE: How to find the SQL Server databse Last used by db users ?

    Last used information is not really stored anywhere; but you can infer the lastused, since the last time the SQL Server Service was Restarted, based on sys stats for index...

    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 10, 2012 at 9:34 am

    #1471297

  • RE: Shifting values to the left

    something like this seems to work, using the Case Statement logic Jaren mentioned:

    with mySampleData (id,addr1,addr2,addr3)

    AS

    (

    SELECT'1','123',NULL,'Main St.' UNION ALL

    SELECT'2',NULL,NULL,NULL UNION ALL

    SELECT'3',NULL,'345','Elm St.' UNION ALL

    SELECT'4','678','Apt 4','Winding Rd.' UNION ALL

    SELECT'5','910','Rodeo Dr.',NULL UNION...

    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 10, 2012 at 9:09 am

    #1471273

  • RE: Documenting SQL Servers

    Just throwing this out there:

    I've used xmind for documentation and to help me flesh out a process tree;

    it's free and easy to use after you learn a few keyboard shortcuts.

    it's...

    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 10, 2012 at 8:13 am

    #1471230

  • RE: What edition of SQL 2008 should be ordered for small business? (3-5 users)?

    there's a good chance the free SQL Express Edition may suite your needs.

    the caveat there is you don't get any of the powerful business tools like SSIS, The ability to...

    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 10, 2012 at 7:46 am

    #1471207

  • RE: Passing table name as parameter

    not sure what exactly you are looking for. it kind of looks like you wnat to test if a table exists?

    this code example works, but might not be what 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 10, 2012 at 7:22 am

    #1471190

  • RE: Script Out Database Mail Settings?

    SQLKnowItAll (4/10/2012)

    mot256 (4/2/2012)

    Thank you very much for this script!

    +1 Lowell! I knew I would need this some day after reading the post. Today was that day!

    lol thanks everyone; every...

    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 10, 2012 at 6:54 am

    #1471171

  • RE: How to search Words From row using SQL Query?

    Ajith 42213 (4/10/2012)

    How to search Words From row using SQL Query?

    a Row has more than one column...if you mean searching all the char/varchar/nchar columns in a given table, the recommended...

    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 10, 2012 at 6:23 am

    #1471152

Viewing 15 posts - 5,611 through 5,625 (of 13,460 total)