Forum Replies Created

Viewing 15 posts - 7,051 through 7,065 (of 13,460 total)

  • RE: How to join two tables using wildcards.

    MySQL Syntax?

    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!

    July 29, 2011 at 8:20 am

    #1360834

  • RE: How to join two tables using wildcards.

    we'd have to see your actual code you executed;

    nia.CHARINDEX really implies something you changed.

    the CHARINDEX function is builtinto SQL, just like ISNULL...so if you preface it with a schema name...

    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!

    July 29, 2011 at 7:13 am

    #1360763

  • RE: Audit, track database connections / logins to a table ?

    - Win. (7/29/2011)

    Hello All,

    Sorry track this to another way.

    - Is there anyway that to track the Logins, created date, accessed date, when it was accessed the particular database.

    Is this...

    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!

    July 29, 2011 at 6:38 am

    #1360720

  • RE: grant execute permission on all sprocs

    defintiely the second; if you grant per item, otherwise if you drop and recreate a proc, or add a new proc you have to regrant the permissions

    that's very similar...

    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!

    July 29, 2011 at 6:24 am

    #1360715

  • RE: List of db_owner granted permissions

    http://technet.microsoft.com/en-us/library/ms189612(SQL.90).aspx

    db_owner has all the rights of these subordinate roles as well...

    basically the db_owner role can do anythign to the database..back it up, drop it, or create/change/destroy anything within 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!

    July 28, 2011 at 11:03 am

    #1360344

  • RE: Help with using an In Statement when declaring a parameter

    parameters don't do what you are expecting them to do there...@level is a string, which [by coincidence] contains commas, which makes you think it might do somethign special.

    to do what...

    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!

    July 28, 2011 at 9:42 am

    #1360242

  • RE: scramble data

    a lot of scrambling of data is specific to the tables and lookups invloved;

    I've got something that replaces all existing data with something like this (street names are a random...

    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!

    July 28, 2011 at 7:32 am

    #1360082

  • RE: How to join two tables using wildcards.

    the LIKE operator can be used in a join, as well as CHARINDEx or PATINDEX to try and find matching criteria.

    see how i provided copy-and-pasteable CREATE TABLE and sample data...

    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!

    July 28, 2011 at 6:04 am

    #1359981

  • RE: STORED PROCEDURE TO CORRECT

    not bad to, good job posting your work. since you put some effort into the homework problem , let me try to offer some constructive advice.

    i think i see two...

    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!

    July 27, 2011 at 12:54 pm

    #1359612

  • RE: sys.objects$ (with a Dollar sign)

    Thanks everyone;

    I've attached it successfully as a user database and will now make a huge mess of things.

    Thanks!

    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!

    July 27, 2011 at 12:08 pm

    #1359582

  • RE: Help creating Derived Column

    what you want to do is all the case logic inside the SELECT, without using that extra variable.

    something like this is syntactically correct...let me know if it is logically correct:

    select...

    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!

    July 27, 2011 at 9:38 am

    #1359400

  • RE: Datetime Formating -

    at our shop, we have to do both SQL and Oracle;

    as a result, to make our scripting a little easier, we added this package a long time ago;

    this makes 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!

    July 27, 2011 at 9:20 am

    #1359370

  • RE: Comparinng integer like string values.

    Nice, Jason, i like that...

    I think she has data that is not in 4 part naming conventions tho...version 10.45 compares to 8.34.53.2234 for example....i'm adding a CTE to my...

    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!

    July 27, 2011 at 9:04 am

    #1359350

  • RE: Comparinng integer like string values.

    yeah, you should test drive mine first before you say it won't work....

    whaty would you expect to be greater if you compare Version "10" to version '1.4.56.2344'?

    if everytthing is 4...

    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!

    July 27, 2011 at 8:43 am

    #1359319

  • RE: Comparinng integer like string values.

    Joy the only way i thought to do this right was with a case statement...i ended up dumping it into a scalr function;

    you can use this as an example and...

    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!

    July 27, 2011 at 8:16 am

    #1359289

Viewing 15 posts - 7,051 through 7,065 (of 13,460 total)