Forum Replies Created

Viewing 15 posts - 6,181 through 6,195 (of 13,460 total)

  • RE: SELECT TOP 50 Percent not returning 50 Percent

    i can confirm that SQL2005 express is returning 8 rows, where my 2008 returns 7.

    the only difference i see is in the execution plan; the layouts of the plans are...

    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!

    December 20, 2011 at 1:27 pm

    #1423910

  • RE: how to know which operation fired the DML trigger

    oops misread it a little bit...

    if you want to know if it was an INSERT, UPDATE or DELETE, you simply check the INSERTED or DELETED tables.

    if rows exist in both...

    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!

    December 19, 2011 at 6:52 pm

    #1423358

  • RE: Problem with left join.

    i'm guessing nwdetcot is a list of all possible prices, possibly for all products thru the begfinning of time..i'm betting you need to limit it to just the CURRENT...

    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!

    December 19, 2011 at 2:29 pm

    #1423307

  • RE: Find best key columns for Clustered Index

    SQLJocky (12/19/2011)

    Thanks. I understand the concepts when you know the data but what if you don't know the data? Is there a quick script that will show each...

    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!

    December 19, 2011 at 1:40 pm

    #1423297

  • RE: How-2-pass getdate() to oracle

    oracle has a suite of TO_* functions. TO_DATE and TO_CHAR for example, but i'm thinking this is going to be done on SQl, since you are really pulling the 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!

    December 19, 2011 at 1:07 pm

    #1423290

  • RE: How-2-pass getdate() to oracle

    SYSDATE is the equivilent in oracle;

    SELECT SYSDATE FROM DUAL; for example.

    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!

    December 19, 2011 at 12:49 pm

    #1423279

  • RE: Trigger fires twice

    also, make sure you don't have two triggers on the same table, both with the same basic code, but two different names.

    that might explain two rows inserted when you expect...

    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!

    December 19, 2011 at 8:55 am

    #1423148

  • RE: How to add the numbers in T-SQL

    if the datatype is vachar, then it will concatenate instead of addition.

    you'll most likely have to explicitly convert to decimal, or money:

    select convert(money,'77.41') + convert(money,'4')

    if this is a column of...

    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!

    December 19, 2011 at 8:51 am

    #1423143

  • RE: SSIS FTP over explicit TLS/SSL Files Download

    CoreFTPsupports Sftp and other secure ftp types, and can be scripted and. Called via a command line or Process.Start in. Net.

    Ive got it in place for a regular batch process....

    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!

    December 16, 2011 at 10:16 pm

    #1422786

  • RE: Alter database/Collation question

    it's not horrible to do, i've thrown some time at it a couple of times, and a simple search can find you someone elses script they already wrote to change...

    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!

    December 16, 2011 at 3:02 pm

    #1422745

  • RE: Loading TIMESTAMP(6) column in oracle 10g using SSIS from a flat file

    i think you want to use the TO_CHAR function on the oracle side...something like this, depending ont he desired format:(what is the timestamp(6) expected value? does it include TIME?)

    SELECT TO_CHAR(DATE_VALUE,'YYYYMMDD')...

    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!

    December 16, 2011 at 2:58 pm

    #1422742

  • RE: Table/Column/Index statistics updates

    statistics auto update when a count of rows equal to 20 percent of a total rows have changed.

    on small tables, that s fine, but on large tables, say a million...

    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!

    December 16, 2011 at 2:50 pm

    #1422740

  • RE: Alter database/Collation question

    yeah, you have to change the collation of each individual column that is char/nchar/varchar/nvarchar as a seperate suite of steps...man it's a lot of work, especially when some of 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!

    December 16, 2011 at 2:39 pm

    #1422737

  • RE: Convert an interger to year month and days

    if the integer was something like 40891, we could infer that it was 40891 days since the beginning of SQL time, which would, by coincidence, be today (12/16/2011.

    without a frame...

    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!

    December 16, 2011 at 2:34 pm

    #1422735

  • RE: Windows authentication : user still works but no login

    that's normal, because you most likely have a group the user belongs to as a login into the database; it might even be an admin group.

    try either ofg these two...

    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!

    December 16, 2011 at 2:00 pm

    #1422720

Viewing 15 posts - 6,181 through 6,195 (of 13,460 total)