Forum Replies Created

Viewing 15 posts - 6,841 through 6,855 (of 13,460 total)

  • RE: database mail error

    i'd say the issue's what you put for the mail server value..."could not connect to mail server." to me says that the url, say "mail.yourdomain.com is actually something else.

    it seems...

    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 1, 2011 at 6:00 am

    #1375899

  • RE: Where Do You Park?

    there was a mornings worth of controversy on a local radio station in south florida this week on this subject...someone who had been working for a business for 14 years...

    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 1, 2011 at 5:51 am

    #1375898

  • RE: how do I join these 3 updates into 1

    this is just a stab in the dark; i'm assuming the query you pasted was ok for Access,a nd also that access supports updates via a case statement...pretty reasonable guesses:

    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!

    August 31, 2011 at 2:19 pm

    #1375708

  • RE: how do I join these 3 updates into 1

    you can do it like this in SQL...i had to replace your MID functions witht eh SQL equivilents.

    this will definitely work for SLQ server, not sure if it works for...

    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!

    August 31, 2011 at 2:10 pm

    #1375700

  • RE: Using Intersect in a IF statement

    Blue Rabbit (8/31/2011)

    Lowell, your answer was spot on. I did want to update an extracted table if true. Your code worked perfectly, Thanks!

    woot! glad i could help! i...

    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!

    August 31, 2011 at 1:33 pm

    #1375680

  • RE: Using Intersect in a IF statement

    you were a little loose on the detaisl as to what flag you want to update...you might need to provide more detials.

    IF EXISTS can help i think:

    IF EXISTS(

    SELECT col1

    FROM...

    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!

    August 31, 2011 at 1:26 pm

    #1375669

  • RE: Get list of months, monthname and Year

    SELECT [year], [month], datename(month,dateadd(mm,[month] -1,DATEADD(yy, DATEDIFF(yy,0,[year] - 1900), 0)))

    FROM (

    SELECT 2005 AS [year] UNION ALL

    SELECT 2006 UNION ALL

    SELECT 2007 UNION ALL

    SELECT 2008 UNION ALL

    SELECT 2009 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!

    August 31, 2011 at 9:54 am

    #1375570

  • RE: .NET SQLClient data provider

    Like Jo pointed out, it's just a variable in the connection string, and really easy to change.

    you can even make SQL Server Management Studio show up with a different applicaiton...

    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!

    August 31, 2011 at 8:24 am

    #1375512

  • RE: Help with slow access on one SP

    others will chime in with more details, but here's the basics as i understand them:

    SQL server builds a query plan to access the data for the stored procedure based on...

    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!

    August 30, 2011 at 2:40 pm

    #1375244

  • RE: Enumerate Windows Group Membership within SQL Server

    there's an extended stored proc that can help, i think

    here's an example of the syntax:

    EXEC master..xp_logininfo

    @acctname = 'mydomain\lowell',

    @option = 'all' -- Show all paths a specific user gets his...

    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!

    August 30, 2011 at 1:52 pm

    #1375220

  • RE: Rounding the decimals

    Math.Ceiling(3.99) will round it up to the nearest integer...is that what you want? so Math.Ceiling(3.09) =4 also.

    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!

    August 30, 2011 at 1:48 pm

    #1375216

  • RE: bcp Errors

    Charlie-551146 (8/30/2011)

    No Sybase installed.

    Charlie don't hate me, i'm just the messenger, but that is defintiely the context menu from SyBase's bcp /?

    http://manuals.sybase.com/onlinebooks/group-as/asg1250e/util/@Generic__BookTextView/10086;pt=10086

    try changing the path to bcp to explicitly go...

    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!

    August 30, 2011 at 12:34 pm

    #1375194

  • RE: bcp Errors

    [:slice_number

    THAT makes me thing you are calling the SyBase bcp.exe and Not the SQL Server's version. SQl doesn't have a slice.

    do you have SyBase client tools installed?

    if you change 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!

    August 30, 2011 at 10:56 am

    #1375135

  • RE: When does sql 2008 release "memory"?

    SQL should have a show on Discovery Channel called "Memory Hoarders"..once it gets the memory, it does not let go, up to the limit of what you allowed at set...

    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!

    August 30, 2011 at 10:35 am

    #1375122

  • RE: Help with slow access on one SP

    John when a proc runs quick in SSMS and slow elsewhere, one of the first things i look for is parameter sniffing.(you can search for that term on this site...

    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!

    August 30, 2011 at 10:16 am

    #1375112

Viewing 15 posts - 6,841 through 6,855 (of 13,460 total)