Forum Replies Created

Viewing 15 posts - 6,271 through 6,285 (of 13,459 total)

  • RE: how many times cursor has looped....

    SD1999 (12/6/2011)

    One more condition here i forgot to mention...

    the logic(algorithm) of number replacements should be followed as per below

    we cant use some random number

    the reason is appl talking to oracle...

    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 6, 2011 at 12:25 pm

    #1417614

  • RE: Backup to disk not on the domain

    yes it's possible because of the way the NET USE command can allow you to map a drive with someones credentials

    exec master.dbo.xp_cmshell 'NET USE G: \\UNCPath\d$ /user:domain\user password'

    something like this...

    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 6, 2011 at 11:13 am

    #1417577

  • RE: temp tables

    add that issue to your to-do list also...anyone creating queries that run for that long need some help in writing better performing code;

    We had the same problem a while...

    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 6, 2011 at 10:05 am

    #1417509

  • RE: how many times cursor has looped....

    well, here's how I do it;

    My assumption is the phone number string in question is all numeric with no dashes, but it's not hard to add logic to fiddle...

    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 6, 2011 at 9:55 am

    #1417495

  • RE: how many times cursor has looped....

    SD1999 (12/6/2011)

    I knew, i will step on 'cursor killers' 🙂 🙂

    Sure, thank you for the offer.

    Need some time to modify script ( for security purposes ) before i 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!

    December 6, 2011 at 8:41 am

    #1417433

  • RE: how many times cursor has looped....

    I'm skipping the question completely, and going to what i think was the core issue...scrambling data.

    I stopped as soonas I saw the cursor, because I know that unless you 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 6, 2011 at 8:33 am

    #1417424

  • RE: COMPATIBILITY_LEVEL question: Upgraded to 2008 R2... Sort of... or "Is there a tool that will tell me what this upgrade broke?"

    ALZDBA (12/5/2011)

    When you switch to the engine level compatibility (100):

    - did you update all statistics

    - did you perform dbcc updateusage

    - did you perform full db maintenance

    - did you run...

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

    #1417409

  • RE: Select the time part of a date.

    ChrisM@Work (12/6/2011)

    Cool, thanks for the feedback. I learned the trick from an article Lowell did years ago 😀 Thanks, Lowell.

    Lol you used it last, and I don't really remember posting...

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

    #1417367

  • RE: Select the time part of a date.

    Dev (12/6/2011)

    Please try convert with style 108.

    http://msdn.microsoft.com/en-us/library/ms187928.aspx

    i would disagree; you want to stay in the same datatypes whenever possible.

    /*--results

    09:00:50.9600000

    09:00:00.0000000

    */

    --SQL2008 has the new Time datatype as well as 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 6, 2011 at 7:01 am

    #1417330

  • RE: Reading data from a text file

    SSIS is reading a text file, so yes, it's text until it's implicitly or explicitly converted to a specific datatype.

    so if you had the SSIS task read the file and...

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

    #1417316

  • RE: Unable to import all rows from .csv

    how are you importing? SSIS? BULK INSERT? are you importing to a staging table first?

    I'm sure there's an explanation, we just gotta dig a little bit.

    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 5, 2011 at 1:30 pm

    #1417013

  • RE: Update Trigger for changes to the Primary Key

    I'm still wondering how to implement this myself...if the Pk is a foreign key in the child table, won't the FK prevent you from changing the key to a 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!

    December 5, 2011 at 1:27 pm

    #1417012

  • RE: COMPATIBILITY_LEVEL question: Upgraded to 2008 R2... Sort of... or "Is there a tool that will tell me what this upgrade broke?"

    if an application is building SQL statements and executing them, then your database and it's objects could be version 9/10 compatible, but the commands create by the application may...

    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 5, 2011 at 12:57 pm

    #1416993

  • RE: How to export sql server data into multiple csv sheets ?

    well, what you are asking is how to create an Excel document with multiple sheets; '

    a CSV is actually a raw text file, which by default opens in Excel, which...

    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 5, 2011 at 12:35 pm

    #1416983

  • RE: Convert MSSQL date to MySQL date

    any chance teh report is returning results that create something like this, which would of course return no records?

    WHERE (recordDateTime BETWEEN '2001-01-01' AND NULL)

    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 5, 2011 at 12:30 pm

    #1416979

Viewing 15 posts - 6,271 through 6,285 (of 13,459 total)