Forum Replies Created

Viewing 15 posts - 3,946 through 3,960 (of 13,460 total)

  • RE: Exported to Visual Basic - Now I need to run

    dlangschied (2/27/2013)

    I needed to export some data from SQL 2000 database to Excel. I only needed a portion of two of the tables, so I generated as a Visual...

    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!

    February 27, 2013 at 11:48 am

    #1591670

  • RE: Splitting a string from a column into three values

    great jo providing the setup data!

    Here's another fast way using the PARSENAME function;

    PARSENAME is usually used to split object names, like ServerName.Databasename.dbo.TableName,

    but can be used for IP address 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!

    February 27, 2013 at 11:06 am

    #1591656

  • RE: DB Mail - Controling What apears in the FROM setcion of an email

    YSL i put this together in a different post, it scripts out all your database mail settings;

    for me this is handy when i want to winmerge and look for subtle...

    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!

    February 27, 2013 at 9:49 am

    #1591625

  • RE: How to compute a single bit wise operator in MDX

    MDX is nothing i've played with, but my google fu pointed me here:

    http://www.google.com/search?q=mdx+bitwise+operations

    and that seems to say you've got to add some .net toys? because MDX does not do bitwise...

    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!

    February 26, 2013 at 2:49 pm

    #1591321

  • RE: Auto delete datas from database

    but two years would be 730 days (365 x 2?), not 2, right?

    DELETE FROM incident WHERE DATEDIFF(DD, CAST(getdate AS DATE), created) > 730

    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!

    February 26, 2013 at 2:28 pm

    #1591316

  • RE: Deleting unused objects (tables, SP, UDF etc) not in use

    another thing to consider is to search any sourcecode for object names;

    we have plenty of "functionality" that exists in various application, but noone ever uses the functions in real life;

    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!

    February 26, 2013 at 1:58 pm

    #1591312

  • RE: extract date

    monilps (2/26/2013)

    Hey,

    Thank you for quick response

    What I meant was

    For Ex:

    Row1: aaaaaaa 02/20/2002 jjjjjj sddsdjjjjsdsd sdsds

    Row2: asdlajsd fjsdfjkdgn dsjbfks, dfjksflml,fsf,f sdfsdf 9/3/99 sjdfnsdnf sjdfoisofn

    Row3: sdkfjos fjsdopfj uyro dlsfl 02-02-02...

    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!

    February 26, 2013 at 1:41 pm

    #1591310

  • RE: extract date

    it'll take a bit of work, and you'll need the DelimitedSplit8K function (search SSC and read the article)

    things like 02/02 and 02-02 are not dates, so they do not get...

    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!

    February 26, 2013 at 1:00 pm

    #1591298

  • RE: delete from multiple tables within a database

    possible, but i wouldn't recommend it; deletes should be decided based on some analysis, and not just because a table might contain a columname that matches or something. Additionally, 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!

    February 26, 2013 at 9:01 am

    #1591225

  • RE: delete from multiple tables within a database

    if you use SET XACT_ABORT ON, you can make the code a little easier to read; if any error occurs, it stops the process and rollsback the transaction automatically:

    each delete...

    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!

    February 26, 2013 at 8:36 am

    #1591209

  • RE: Statistics - ' Auto Update Statistics ' - 'Auto Update Statistics Asynchronously'

    you might get a benefit out of it, but it's one of those one half of one percent kind of things, and not a major performance enhancements.

    remember what has 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!

    February 25, 2013 at 12:15 pm

    #1590917

  • RE: how to create user group logins in SQL server 2005

    you choose New Login, and then use the find object to find a windows group....once you are in there, it becomes more clear:

    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!

    February 25, 2013 at 10:00 am

    #1590861

  • Reply To: Autoclose property changes automatically?

    nothing happens automatically, so something is changing the setting.

    if you restore a database, the property for autoclose is stored inside it, so that's one possibility....restore it,and since the last setting...

    • This reply was modified 7 years, 2 months ago by Lowell.
    • This reply was modified 5 years, 11 months ago by Dave Convery.

    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!

    February 23, 2013 at 5:28 am

    #1590597

  • RE: how to determine the first column with null value

    MadRazzi (2/22/2013)

    what if ax2 through ax5 is null for a record

    wouldn't the case statement assign value 5 to POS?

    no.

    the case statement stops executing as soon as a match 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!

    February 22, 2013 at 3:17 pm

    #1590542

  • RE: In --> Group By with Multiple columns...> how it will responds

    the title of your post "In --> Group By with Multiple columns...> how it will responds " is not enough for us to go by;

    can you explain...

    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!

    February 22, 2013 at 12:40 pm

    #1590494

Viewing 15 posts - 3,946 through 3,960 (of 13,460 total)