Forum Replies Created

Viewing 15 posts - 3,796 through 3,810 (of 13,460 total)

  • RE: ER diagram and related query!

    join criteria is critical in any sql to make any sense from multiple tables.

    because you are using the old style joins, and never identify the join criteria, you are getting...

    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!

    March 29, 2013 at 6:28 am

    #1601983

  • RE: insert data into varbinary datatype column---------very urtgent.

    you'll need to insert the flat file into a staging table...the flat file doesn't contain a varbinary string, right?

    so you stick it in a table of the right data 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!

    March 29, 2013 at 6:11 am

    #1601980

  • RE: 3-Node, 3-Instance SQL Cluster -- Static IP address and Port 1433 question

    whoops i didn't read your quesiton completely. ; i was assuming a non-clustered setup;, i thought we were talking single server/3 ip's / 3 instances.

    my mistake i think.

    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!

    March 28, 2013 at 2:42 pm

    #1601871

  • RE: 3-Node, 3-Instance SQL Cluster -- Static IP address and Port 1433 question

    I think you'll have to modify each instance to listen to one IP address; then change the port on that one IP address so that it's 1433.

    no instance should listen...

    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!

    March 28, 2013 at 2:40 pm

    #1601868

  • RE: Different nolock question

    SELECT * FROM TableABC nolock

    is exactly the same as

    SELECT * FROM TableABC bananas

    In the above, the word after the table is just an alias.

    SELECT * FROM TableABC (nolock)

    This 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!

    March 28, 2013 at 2:22 pm

    #1601855

  • RE: Java dynamically builds SQL

    i would consider looking at whatever query the current code returns, and build a view of THAT, and fix the code to pass parameters for the WHERE clause;

    there's a lot...

    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!

    March 28, 2013 at 1:51 pm

    #1601837

  • RE: Searching for a database field in the SQL Server Database

    SQL is very similar, and there's two ways:

    select TABLE_NAME,COLUMN_NAME from INFORMATION_SCHEMA.COLUMNS where COLUMN_NAME='POS_TRANSACTION'

    --or

    select OBJECT_NAME(object_id) As TableName, name As ColumnName from sys.columns where name ='POS_TRANSACTION'

    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!

    March 28, 2013 at 11:15 am

    #1601763

  • RE: Just a random observation with 'WITH'

    a nolock on an update is ignored anyway, so there's no advantage to adding it anyway.

    only SELECT statements will honor NOLOCK, and then you get the usual possibilities about doubled/repeated...

    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!

    March 28, 2013 at 6:31 am

    #1601590

  • RE: ssms connect to database engine hangs

    03sunil (3/28/2013)

    Hi,

    We have similar kind of issue, We have 9 instances running on windows 2008 box. All are 2008 R2 instances. We have problem with only one instance.

    We are 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!

    March 28, 2013 at 6:15 am

    #1601583

  • RE: mutation in Trigger

    your trigger is on the table TEST, but the update command is looking at a different table;

    UPDATE S_ID SET STATUS ='Y'

    WHERE SID in

    (SELECT SID FROM TEST_CUST WHERE M_ID=:old."ID");

    shouldn't that be...

    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!

    March 28, 2013 at 6:12 am

    #1601582

  • RE: So How Do You do your mass Mailings?

    Thanks for the insight guys; I'm still hoping for some more suggestions.

    My non profit wouldn't even spend the five dollars per mailing, but would love for me to invest hundreds...

    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!

    March 28, 2013 at 6:09 am

    #1601580

  • RE: I need to write a SQL SELECT stmt that puts the results out to a CSV file in SQL 2008

    the command you posted is from MYSQL;

    SQL doesn't do file writing operations directly, you typically would use BCP OUT, or a CLR, or an application to write to disk when...

    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!

    March 28, 2013 at 5:56 am

    #1601573

  • RE: Are the posted questions getting worse?

    BrainDonor (3/28/2013)

    Lynn Pettis (3/27/2013)

    What to make of this?

    May not be what I was thinking. Good.

    "I'm a DBA, it turns out"

    How do you suddenly discover that you're a DBA?

    it's 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!

    March 28, 2013 at 5:30 am

    #1601561

  • RE: How do i line up the weeks in T-SQL ?

    ...ORDER BY ?

    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!

    March 27, 2013 at 1:57 pm

    #1601355

  • RE: Developing SSIS Packages

    BIDS is a trimmed down version of VS2010 with the project templates related to Business Intelligence installed.

    i have VS 2010 professional, and I have SQL 2008 standard installed on my...

    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!

    March 27, 2013 at 1:54 pm

    #1601351

Viewing 15 posts - 3,796 through 3,810 (of 13,460 total)