Forum Replies Created

Viewing 15 posts - 7,801 through 7,815 (of 13,460 total)

  • RE: Add single code using macro in excel

    manavairajan (4/7/2011)

    Sub addsinglequte()

    For a = 1 To 60

    Range("d" & a).Select

    If Len(ActiveCell.Value) > 0 Then ActiveCell.Value = "''" & ActiveCell.Value & "',"

    Next

    End Sub

    Is there a question in here...

    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!

    April 7, 2011 at 6:19 am

    #1308452

  • RE: Creating Delimited Strings

    Brandie glad you found what you are after, and thanks for the link; I added some of those methods to my snippets.

    If you get a chance, can you explain why...

    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!

    April 7, 2011 at 5:52 am

    #1308439

  • RE: How really works TRUNCATE TABLE?

    misiekbest (4/7/2011)

    Hi.

    Question is simple. What does sqlsrv engine do with table after truncate command?

    Someone told me, that it just rename that table (internally?), create new one and drop renamed...

    Well,...

    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!

    April 7, 2011 at 4:58 am

    #1308409

  • RE: dual six core processor TSQL

    it depends on the work to be done; SQL would evaluate the command and make a decision/plan as to whether pieces of it can be processed in multiple cores; it...

    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!

    April 7, 2011 at 4:54 am

    #1308407

  • RE: equivalent to oracle "imp scott/tiger file=database.dmp fromuser=scott touser=scott" in sqlserver 2005

    SQL is a little different;

    i believe you are looking for a BACKUP of one database(to create the dump, or *.bak file) and then when it's needed to restore over...

    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!

    April 7, 2011 at 4:50 am

    #1308406

  • RE: Creating Delimited Strings

    I've used the FOR XML trick to get the data...it returns string data(varchar(800) or max

    this seems to do what you asked for:

    /*DocIDSkills

    1DocumentNumber,Sale Date

    2First Name

    3Last Name,DocumentNumber

    8City

    10Sale Date

    */

    SELECT DocID,stuff(( ...

    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!

    April 6, 2011 at 2:04 pm

    #1308268

  • RE: file get from ftp using script

    is there a question?

    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!

    April 6, 2011 at 12:13 pm

    #1308192

  • RE: Sql query on orcale DB error (literal does not match format string)

    souldn't the data be ('04/04/2011...

    or the pattern be M/D/YYYY...

    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!

    April 6, 2011 at 12:04 pm

    #1308189

  • RE: Best way to handle email addresses inside stored procedures

    like this: just tested it:

    select * from

    (

    select definition,myf.* from sys.sql_modules

    cross apply dbo.DelimitedSplit8K(definition,' ') myf

    where definition like '%[A-Z]@_%'

    ) myAlias

    where Item like '%[A-Z]@_%'

    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!

    April 6, 2011 at 11:44 am

    #1308172

  • RE: Best way to handle email addresses inside stored procedures

    well as a start, you could limit it to only procs/functions/triggers that have strings that might be an email;

    this certainly found the two objects i have that have a hardcoded...

    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!

    April 6, 2011 at 11:39 am

    #1308169

  • RE: Get Similarity Values is Same Table on Same Row

    for addresses, there are a number of services that will standardize your address info for a fee;

    if your cheap or just like a challenge (like me) what I've done 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!

    April 6, 2011 at 11:12 am

    #1308149

  • RE: Link Server Issue

    the SQL statement is wrong.

    if you are going to use double dots, which tells the linked server to get the default object, it is like this:

    it has to be 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!

    April 6, 2011 at 9:38 am

    #1308079

  • RE: Sorting Multiple Columns

    think about it: how many unique employees receive two salaries? i doubt any in this table.

    maybe you need to join to a different table, say the payroll table, so you...

    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!

    April 6, 2011 at 7:04 am

    #1307991

  • RE: Sorting Multiple Columns

    subrat_4ualways (4/6/2011)

    Hi

    The query is

    Select * from emp_details order by EmpId desc,EmpSal

    The output I am getting is Empid desc only....

    Many Thanks

    Subrat.

    I think David nailed it, unless an EmpId appears more...

    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!

    April 6, 2011 at 6:37 am

    #1307970

  • RE: Linked Server Anomoly

    Sounds pretty wierd; can you script the linked server command out so we can see it? that woudl be most helpful in the diagnosis; you are of course sure you...

    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!

    April 6, 2011 at 6:25 am

    #1307962

Viewing 15 posts - 7,801 through 7,815 (of 13,460 total)