Forum Replies Created

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

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

    SD1999 (12/6/2011)

    Thank you, i'll play with it.

    those are not really phone numbers, it was just for example

    no more rules, this is it

    what and where do you think would be a...

    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 1:07 pm

    #1417637

  • 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

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