Forum Replies Created

Viewing 15 posts - 3,301 through 3,315 (of 13,460 total)

  • RE: Combine columns into One with Delimiter

    my verison is kinda of wordy but works with a case statement:

    SELECT

    CASE

    WHEN RTRIM(ISNULL(col1, '')) <> ''

    AND RTRIM(ISNULL(col2, '')) <>...

    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!

    June 6, 2013 at 1:21 pm

    #1621892

  • RE: How to add a login with db_datareader in a database in a remote server via tsql from the given server?

    Jerome it seems to me you are leaving a lot out.

    your example must be coming inside a cursor, right? why don't you show that part too?

    your code(so far) is adding...

    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!

    June 6, 2013 at 7:52 am

    #1621745

  • RE: Create Job to run indefinitely

    Ratheesh.K.Nair (6/6/2013)

    Thanks Lowell,

    I want the process to keep running. Creating a recurring job wont help me.

    Since am trying on test server DBCC CHECKDB wont take more than few seconds.

    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!

    June 6, 2013 at 7:29 am

    #1621732

  • RE: To find unique constraint in a table

    SQLSACT (6/6/2013)

    ikonrao (6/6/2013)

    We have a table in which we want to know whether any of the columns has unique constraint defined.

    Or if we can get create table statement for 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!

    June 6, 2013 at 7:09 am

    #1621722

  • RE: Create Job to run indefinitely

    Ratheesh.K.Nair (6/6/2013)

    Hi experts,

    Can anyone please help me create a job that should run indefinitely i mean the the script should keep on running.

    Thanks in Advance

    have you created a job at...

    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!

    June 6, 2013 at 7:04 am

    #1621719

  • RE: SSMS not connected on query tabs but still connected in object explorer

    zip184 (6/6/2013)

    I have the same problem in 2008. I never used to but I re-installed it recently and this started happening.

    Have you found anything yet?

    Maybe the autoclose proeprty 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!

    June 6, 2013 at 6:57 am

    #1621716

  • RE: How to add a login with db_datareader in a database in a remote server via tsql from the given server?

    i think the issue is your second statement; you only select if your variable is empty string, but you already created it?

    i would do it all in a single command,...

    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!

    June 6, 2013 at 6:52 am

    #1621714

  • RE: Data type Question

    We support an app that connects to either SQL or Oracle as well, and trip over the which-data-types-are-equivalent questions as well;

    for your second question,

    NUMBER(10) = int

    this is my go 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!

    June 6, 2013 at 6:08 am

    #1621692

  • RE: To find unique constraint in a table

    ikonrao (6/6/2013)

    We have a table in which we want to know whether any of the columns has unique constraint defined.

    Or if we can get create table statement for that table,...

    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!

    June 6, 2013 at 5:20 am

    #1621672

  • RE: New to sql server

    I'd recommend starting with some of hte articles in the "stairways" series, here on SQL Server Central:

    http://www.sqlservercentral.com/stairway/

    those articles are on subjects and build up from basic information to more 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!

    June 5, 2013 at 3:05 pm

    #1621531

  • RE: Weird Behavior of a Stored Proc

    Michelle-138172 (6/5/2013)

    The main thing that puzzels me is why it only happens to web calling. There's never a problem running it in the Management Studio. My web dev guys can't...

    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!

    June 5, 2013 at 2:10 pm

    #1621511

  • RE: Fizz Buzz interview questions for phone screens?

    so much of it depends on how it was presented, also;

    As a veteran of more than a couple of posts here,

    How well the question is phrased directly affects...

    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!

    June 5, 2013 at 1:47 pm

    #1621499

  • RE: Weird Behavior of a Stored Proc

    Michelle-138172 (6/5/2013)

    Thanks for the advice! The thing is, all the tables involved in the proc are very static. The updates happen once a while and the proc usually works fine...

    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!

    June 5, 2013 at 1:09 pm

    #1621483

  • RE: To merge several tables into one

    luis covered a couple important points i wanted to mention again: you'll need a new column for the ClientId in there somewhere.

    we've done this in the past, and the way...

    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!

    June 5, 2013 at 1:05 pm

    #1621478

  • RE: Weird Behavior of a Stored Proc

    Michelle-138172 (6/5/2013)

    I have a stored procedure that's called by a web application. Every now and then, the web call will time out for no apparent reason. But I can still...

    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!

    June 5, 2013 at 12:53 pm

    #1621469

Viewing 15 posts - 3,301 through 3,315 (of 13,460 total)