Forum Replies Created

Viewing 15 posts - 1,936 through 1,950 (of 13,460 total)

  • RE: How to find who is indirectly connected to a database?

    the question really is WHY do you need to know if any are happening, if the developers are allowed to do that. what do you want to do that 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 25, 2015 at 11:54 am

    #1780029

  • RE: NOT IN affecting output

    you ar emissing the empty string part i put in my example:

    ISNULL(person_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!

    February 25, 2015 at 10:39 am

    #1780002

  • RE: NOT IN affecting output

    null cannot be compared to any value, as NULL is undefined,so it affected your logic.

    ...AND ISNULL(person_name,'') NOT IN ('john smith', 'sally brown') would resolve 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!

    February 25, 2015 at 10:06 am

    #1779982

  • RE: AutoNumber Integer to Varchar with min ID

    its possible, but you have to have defined the matching criteria.

    until you define logic for identifying the duplicates, you cannot consolidate duplicates. also, you probably need additional logic, since 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 25, 2015 at 9:07 am

    #1779957

  • RE: Generate Records For gaps To Create A Chart for every Date

    sm_iransoftware (2/25/2015)

    I Must Started For every User From Its Register Date !!!!

    (And Inserted Date from That Date to now - For every User)

    i showed you a basic example that gets...

    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, 2015 at 5:35 am

    #1779866

  • RE: Generate Records For gaps To Create A Chart for every Date

    the best way this is done by joining to a permenant Calendar table first, which contains all possible dates, and left joins to your data.

    if you don't have one, 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 25, 2015 at 5:23 am

    #1779858

  • RE: permissions for connect any database

    i believe when you grant VIEW ANY DEFINITION TO [SpecialUser], that inherently grants connect permissions to each database; you do not need to add anything additional for that permission.

    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 24, 2015 at 3:11 pm

    #1779766

  • RE: concatenate image with varchar

    abhas (2/24/2015)

    Thanx Lowell,

    By the way any other option to do this? i need to display output as test1(checkbox)test2(checkbox). Client want just output,i can use any other methos as well.

    Thanks

    Abhas.

    it...

    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 24, 2015 at 10:11 am

    #1779661

  • RE: Sql Server DATALENGTH() function in C# or SQL CLR

    the datalength of an NVARCHAR is doubled, as that is telling you how much storage is required in SQL;

    i don't think that is relevant in c#, is it?

    /*--Results

    (No column name)(No...

    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 24, 2015 at 9:55 am

    #1779655

  • RE: concatenate image with varchar

    abhas (2/24/2015)

    yes, Iamge is binary value like 0x0000A38C00BEB787....

    Thanks,

    Abhas

    then no, you cannot do what you are asking.

    you cannot concatenate an image to text.

    you might be able to display text and image...

    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 24, 2015 at 9:51 am

    #1779652

  • RE: Named instance connectivity issues

    since this is an instance, and you already conencted to a default instance on port 1433, i doubt very much the named instance is listenting on 1433 like you think.

    connect...

    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 24, 2015 at 9:48 am

    #1779651

  • RE: concatenate image with varchar

    well, this has more to do with the display medium more than anything. if you mean checkbox is actually code like this:

    <img src="Mywebsite.checkbox.gif">

    or

    <input type="checkbox" >

    or your image is actually a...

    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 24, 2015 at 9:40 am

    #1779644

  • RE: Sql Server DATALENGTH() function in C# or SQL CLR

    inside the CLR, if you are using a datatable to hold the data, you can find the max length of the values in the a column, , or if...

    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 24, 2015 at 9:26 am

    #1779634

  • RE: concatenate image with varchar

    is the image datatype actually a text file or something stuffed into the column? what is in the image column? a real image? html rtf or something?

    if the base type...

    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 24, 2015 at 9:20 am

    #1779631

  • RE: Help me with the UPDATE statement

    well, you can visualize the desired data with a join,

    /*--results

    name unit Lab

    ------- ----------- ------

    abc 1 ...

    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 24, 2015 at 9:16 am

    #1779627

Viewing 15 posts - 1,936 through 1,950 (of 13,460 total)