Forum Replies Created

Viewing 15 posts - 3,496 through 3,510 (of 13,460 total)

  • RE: How do I retrieve a value in a text column that has a XML

    mw112009 (5/8/2013)

    Lets make this simple.

    select top 100 message from [surescripts_msg_import]

    In this case the column message is of type text.

    Can someone please help me write a select query that will retrieve...

    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!

    May 8, 2013 at 12:41 pm

    #1613495

  • RE: CROSS APPLY Question

    my best guess is this will perform better, but it depends on the data;

    also it looks like you are pulling from a view(v_MOTS_RELATED_CONTACT_DATA_N), which itself could be pulling in...

    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!

    May 8, 2013 at 11:59 am

    #1613480

  • RE: SQL Server disaster recovery - advice about AppAssure

    remind him about partial data recovery and point in time restores.

    the little bit i read says NIGHTLY backups, and does not mention SQL Server point in time recoveries throughout 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!

    May 8, 2013 at 11:11 am

    #1613459

  • RE: SQL Server disaster recovery - advice about AppAssure

    interesting, my knee jerk reaction is That I would still script out for disaster recovery, an d keep performing native backup and disaster recovery for SQL server regardless 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!

    May 8, 2013 at 11:00 am

    #1613454

  • RE: Whats the easiest way to read the first 10 characters of a flat file

    in a kind-of-similar thread, someone had a table full of varbinary(max) datatypes full of graphic images, without the filename/extension, so they couldn't figure out if the file was *.jpg, *.gif...

    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!

    May 8, 2013 at 10:30 am

    #1613444

  • RE: SSMS 2012 Restarts Itself

    maybe you added a plugin for SSMS, and it's crashing on the close of SSMS, which causes the restart?

    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!

    May 8, 2013 at 10:17 am

    #1613434

  • RE: excel migration issue

    yes; the link i posted used the latest drivers that are compatible with opening all previous excel formats,

    I've connected to pre-2007 xls, 2007 xlsx and 2010 xlsx spreadsheets with...

    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!

    May 8, 2013 at 10:11 am

    #1613431

  • RE: How to define SPID of default trace

    we are really on the same page;

    i use traces a LOt, especially becasue i'm very familiar with it, and it's easy to create a trace template with profiler, and make...

    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!

    May 8, 2013 at 10:07 am

    #1613427

  • RE: excel migration issue

    i've read it's possible by doing something in the C:\Windows\SysWOW64\odbcad32.exe folder or something as well, but the method i'm mentioning is what i'm currently using;

    glad you guys have a handle...

    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!

    May 8, 2013 at 10:04 am

    #1613424

  • RE: How to define SPID of default trace

    when i run sp_who2, i see a few rows that might be the "right" server side spid(14,29 and in my case), with the command "TRACE QUEUE TASK"

    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!

    May 8, 2013 at 9:40 am

    #1613415

  • RE: How do I retrieve a value in a text column that has a XML

    i couldn't get your one example to work, because the data was malformed in your pasted example; it was missing two tags, so it was not valid xml; it was...

    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!

    May 8, 2013 at 9:06 am

    #1613395

  • RE: XML.Value when it has attributes?

    Ok the light came on with Marks' wildcard solution, thank 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!

    May 8, 2013 at 9:04 am

    #1613392

  • RE: XML.Value when it has attributes?

    thanks, arthur, but that's kind of what's confusing me;

    if i don't use the namespace, i get the desired results for the second item but not ht efirst; if i use...

    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!

    May 8, 2013 at 8:28 am

    #1613373

  • RE: Hw to execute stored procedure using select statement?

    nareshmsbi13 (5/8/2013)

    I have execute my stored procedure using a select statement like

    Exec SP where select * from view,wt is the finall out put of this query can some...

    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!

    May 8, 2013 at 7:08 am

    #1613317

  • RE: excel migration issue

    db042188 (5/8/2013)

    hate to be a pain Lowell but are you running dtexec as 64 bit (from the non x86 directory) and bringing/reading excel 2007 data into your ssis buffer?

    myself, specifically,...

    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!

    May 8, 2013 at 7:05 am

    #1613315

Viewing 15 posts - 3,496 through 3,510 (of 13,460 total)