Forum Replies Created

Viewing 15 posts - 4,351 through 4,365 (of 13,460 total)

  • RE: Intellisense - Table definition (hover over *)

    Bruce I've got both 2008 and 20012 installed; although the formatting/font is different for the tooltip on mouseover, i get the same information...

    if you create a NEW table, 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!

    November 20, 2012 at 12:58 pm

    #1560987

  • RE: two almost identical triggers working fine except one line in each

    i see that if any of these four fields are null, the value inserted would be null:

    INSERTED.PO_Number + INSERTED.AppUser + INSERTED.SoftwareShortName + INSERTED.HeatTicketNumber,

    also , depending on the datatypes, if any...

    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!

    November 20, 2012 at 12:14 pm

    #1560967

  • RE: Importing a Unix file to SQL

    David the Import Wizard in SSMS is probably the fastest solution.

    A full blown SSIS package, bcp /bulk insert with a format file, or the Import Wizard(which is SSIS Lite, really)...

    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!

    November 20, 2012 at 10:04 am

    #1560905

  • RE: CONTAINS Keyword.

    I've got an example of this in my snippets; I've added a last example at the end, which returns just what i thought you asked for: only the words...

    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!

    November 20, 2012 at 9:53 am

    #1560897

  • RE: Management Studio -> Tasks -> Generate Script

    Concurring with Gazareth here; if the logins need to be migrated, you need to use sp_help_revlogin , which will maintain the password in an encrypted binary string so it can...

    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!

    November 20, 2012 at 9:02 am

    #1560870

  • RE: Help with doing “Cast the decimal as string, parse into the format specified, and then cast back into datetime”?

    based on the other thread for the same issue the problem is SOME of his data is YYYYMMDD as a decimal, like 20121225, but some of his data is not...

    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!

    November 20, 2012 at 7:54 am

    #1560816

  • RE: Search String in Entire Database

    tonyarp05 61903 (11/19/2012)

    The reason is, Suppose i want to search a string 'Family' in entire database. so that i could get the output which are tables(Fields) are having the value...

    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!

    November 20, 2012 at 5:44 am

    #1560762

  • RE: creating an alert on a table

    sapen (11/19/2012)

    No this is not a special table. It has data in there luckily no value less than 50 for the column percent called so far.

    in that case, you need...

    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!

    November 19, 2012 at 5:21 pm

    #1560573

  • RE: Can you incorporate something from AD in a SQL query?

    it will pass your current credentials,which i assume are your windows credentials;

    if you hit it as sa, you'd get the typical error for invalid user.

    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!

    November 19, 2012 at 5:15 pm

    #1560571

  • RE: Convert field from YYYYMMDD format to MM/DD/YYYY ?

    swarup.malli (11/19/2012)

    Thank you for the reply Lowell,

    I was trying to create a view for all the tables.

    Could you demostrate how to implement this commoand inside a DDL statement for creating...

    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!

    November 19, 2012 at 3:34 pm

    #1560550

  • RE: Convert field from YYYYMMDD format to MM/DD/YYYY ?

    man, if at all possible, change your columns to true datetimes immediately.

    Like Sean said, one of a billion plus reasons to use the right datetime data type is headaches like...

    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!

    November 19, 2012 at 3:21 pm

    #1560541

  • RE: creating an alert on a table

    ok, is this a special table where there is one and only one row in the table?

    the reason i ask is the variable population like this:

    select @cnt = percentcalled

    from dbo.[StatLog]

    there's...

    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!

    November 19, 2012 at 3:05 pm

    #1560533

  • RE: Restore fails

    yogi123 (11/19/2012)

    Lowell (11/19/2012)

    yeah the error implies either the file or folder is spelled incorrectly, or the filename itself doesn't exist...extra underscore or anything like that a possibility in the name?

    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!

    November 19, 2012 at 2:03 pm

    #1560515

  • RE: creating an alert on a table

    well the details would help, but roughly it would look something like this:

    if exists (select 1 from VW_products

    where...

    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!

    November 19, 2012 at 1:58 pm

    #1560511

  • RE: creating an alert on a table

    you could do it in a trigger, when some value actually gets changed, or you could create a scheduled job to periodically scan the table for exceptions, depending on how...

    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!

    November 19, 2012 at 1:25 pm

    #1560504

Viewing 15 posts - 4,351 through 4,365 (of 13,460 total)