Forum Replies Created

Viewing 15 posts - 6,736 through 6,750 (of 13,460 total)

  • RE: Excel Hell

    One of our developers started down that same road, because we had so many users familiar with Excel, but we ended up switching to a web page instead;

    we had...

    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 20, 2011 at 8:38 am

    #1383880

  • RE: How to test Failover in production sql server cluster?

    stop the SQL service on the Active node....

    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 20, 2011 at 7:58 am

    #1383860

  • RE: Burst a record to multiple copy based on a field of that record

    that "burst" keyword your using is throwing me off...i'm not sure what you mean.

    you can use a "Tally" or "Numbers" table (search here on SSC) to cross join as many...

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

    #1383837

  • RE: Listing Parent tables and child table

    you can use sp_fkeys [ParentTable] to generate a list of child table references;

    from there you can use that list to script your merge statements...does that help?

    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 20, 2011 at 6:58 am

    #1383821

  • RE: Inbox message how to store in database

    from the link that was posted, i also noticed you cannot use SQLMail with 64 bit SQL.

    it's kind of hard to not use 64 bit with anything that's reasonably new...

    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 20, 2011 at 6:08 am

    #1383773

  • RE: How connect several progress databases with one sql linq connection.

    this link shows how to make a linked server to a PROGRESS database:

    http://progress.atgnow.com/esprogress/jsp/AnswerControls.jsp?directSolutionLink=1&tabs=true&docPropValue=p120484

    from there, it's a matter of the linked server calls via 4 part naming conventions:

    select * from lsProgress..Database1.Table1

    select...

    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 20, 2011 at 6:06 am

    #1383770

  • RE: Inbox message how to store in database

    vinaseetha87 (9/20/2011)

    I have create a website.the customer send the query in my mail that query how to store in database.

    I want to read the inbox message ,that message 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!

    September 20, 2011 at 4:37 am

    #1383710

  • RE: Adding a null column and setting it to a default value of 0

    ALTER TABLE X add acolumn smallint NULL Default 0 WITH VALUES

    the optional WITH VALUES populates existing rows with the default value in the new column

    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 19, 2011 at 4:43 pm

    #1383572

  • RE: Adding db users to multiple db

    rob.sellinger 92152 (9/19/2011)

    I am still looking for a way to grab the user accounts from a list as well. Ultimately i would like to run this script to generate 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!

    September 19, 2011 at 4:39 pm

    #1383564

  • RE: substring with changing length

    i'm using the patindex a second time to find the comma, and then pulling the length of whatever is between the two.

    with stg_reporting([column 5])

    AS (

    SELECT '[jobname] [RPP] Info: [RPP] Job...

    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 19, 2011 at 3:21 pm

    #1383521

  • RE: Adding db users to multiple db

    rob.sellinger 92152 (9/19/2011)

    So i get an incorrect syntax on line 7 concerning the user name? Does not matter if i try to use a sql or domain user. there was...

    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 19, 2011 at 3:14 pm

    #1383518

  • RE: Adding db users to multiple db

    rob.sellinger 92152 (9/19/2011)

    ok that may work. So do i still put in each db name or is it going through all db not under id 4? also for the 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!

    September 19, 2011 at 2:24 pm

    #1383490

  • RE: Unable to print variables outside of loop

    any chance the values could be null? it looks to me like your code might do a SELECT TOP 1 from the table , and that could reutrn NULL, but...

    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 19, 2011 at 1:57 pm

    #1383473

  • RE: Creating a database and then migrating a folder full of files that was created by a vb6 program into a table

    is that what it really looks like, or is it really tab delimited, so it's something more like this with the row of data on a single line?

    SAMPLE CLIENT.⇒229-19534221 N.E....

    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 19, 2011 at 1:05 pm

    #1383451

  • RE: Creating a database and then migrating a folder full of files that was created by a vb6 program into a table

    SSIS is part of one of the paid versions of SQL Server: Standard,Enterrpsie,Developer or Datacenter;

    the free version fo SQL (SQL Express) installed with Visual Studio, or downloaded for free does...

    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 19, 2011 at 12:54 pm

    #1383447

Viewing 15 posts - 6,736 through 6,750 (of 13,460 total)