Forum Replies Created

Viewing 15 posts - 12,766 through 12,780 (of 13,460 total)

  • RE: Finding unused databases?

    you don't want to actually delete anything, because dev databases might contain the most cutting edge stored proc some developer has been working on or something, so you want 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!

    January 22, 2007 at 12:19 pm

    #684766

  • RE: text field in sql server 2000

    What is the max length of the text field. I saw that  in our system, the length is set up to 17 while the length of the characters is many...

    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!

    January 22, 2007 at 11:15 am

    #684755

  • RE: Exporting SQL Server data to SQL Anywhere

    there's a few things you should check:

    first off, does "select *from table " return any rows? here we determine that data exists.

    second, could it be that the db is case...

    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!

    January 22, 2007 at 11:04 am

    #684752

  • RE: MySql vs Sql, Bombay vs Rio

    even mysql says that stored procs are useful, faster and more secure...they also say their implementation of stored procedures is not yet complete...

    for an expert to contradict the database provider...

    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!

    January 22, 2007 at 7:28 am

    #684676

  • RE: Stripping Data

    this might get you started; LEFT,RIGHT and SUBSTRING functions can be used to get parts of strings.

    note how im checking to make sure that the field is at least 8...

    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!

    January 19, 2007 at 1:24 pm

    #684427

  • RE: Gender Function

    well, it depends on the field you are examine...is the field a "name" field? so you are going thru the data and making a best guess at the gender, or...

    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!

    January 19, 2007 at 10:00 am

    #684378

  • RE: creating self signed certificates

    i noticed in the example you pasted, and also in the web page example, it is using extended ascii characters for the quotes (left dbl quote and right dbl quote)...

    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!

    January 19, 2007 at 9:53 am

    #684376

  • RE: dosomethingbig & dosomethingsmall

    you might want to paste your procedure here; some of us can point out any spots where the procedure might be able to be optimized. I think you glazed 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!

    January 19, 2007 at 7:41 am

    #684301

  • RE: list User Stored Procedures that reference a specified table

    sql_er no it does not address the issue where a tablename might span across  the 4000 char mark in syscomments;

    in my case, i check sysdepends and this, and it's "good...

    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!

    January 18, 2007 at 3:47 pm

    #684136

  • RE: Null column values in select query equality check

    try SELECT name, age FROM users WHERE ISNULL(age,0) = ISNULL(@age, 0)

    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!

    January 17, 2007 at 11:55 am

    #683819

  • RE: dosomethingbig & dosomethingsmall

    if it's taking 1.5 hours to complete, i bet it's got a row by row cursor on a big table, and whatever it is doing might be optimized into 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!

    January 17, 2007 at 9:27 am

    #683784

  • RE: Cutting a Column Apart

    Stephen's right...you could use a case statement to avoid the < 20 pitfall:

    CASE WHEN len(Incident_Details.Description) < 20 then '' ELSE

    substring(Incident_Details.Description, 20, len(Incident_Details.Description) -19) END AS...

    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!

    January 17, 2007 at 9:18 am

    #683778

  • RE: Creating views under INFORMATION_SCHEMA in SQL 2005

    peter I'm having a similar issue when i try to do it as well in my 2005 test server.

    I never created my info views based on other views, so 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!

    January 16, 2007 at 8:59 am

    #683507

  • RE: Possibly complex SQL

    it's the alias for the count....we still need the schema and datasample to give a meaningful answer.

    SELECT USER,

    CASE WHEN ISNULL(APPLICATION1,0)=0 THEN 0 ELSE 1 END  +

    CASE WHEN ISNULL(APPLICATION2,0)=0 THEN...

    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!

    January 16, 2007 at 8:07 am

    #683490

  • RE: Possibly complex SQL

    thanks for the correction Vladan; i missed that one since i just winged it and didn't test it in QA. Maybe he can redesign the schema and fix the issue.

    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!

    January 16, 2007 at 7:30 am

    #683470

Viewing 15 posts - 12,766 through 12,780 (of 13,460 total)