Forum Replies Created

Viewing 15 posts - 7,381 through 7,395 (of 13,460 total)

  • RE: difference between result in Studio and ASP

    are you using parameters from the asp page?

    the datatype of the parameter is probably the issue in this case;

    can you show us how the parameter is being passed to your...

    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!

    June 13, 2011 at 9:11 am

    #1337821

  • RE: All Fields in a Table Under One Unique Key

    well this stands out to me:

    There isn't a single process which uses every field in the table.

    that means some, or many of the columns might be null...for me,that alone would...

    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!

    June 13, 2011 at 8:50 am

    #1337797

  • RE: Row count in temp table

    we'd have to see your code, but are you doing something like this? remember @@ROWCOUNT gets reset with EVERY command, including SET operations, so you have to be careful.

    DECLARE @mycount...

    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!

    June 13, 2011 at 8:20 am

    #1337772

  • RE: Building an ARRAY and then LOOP through results

    allmhuran (6/13/2011)

    words like "array" and "loop through"

    couldn't help but think of an old cowboy movie with someone saying "Them Thar is Fightin' Words!"

    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!

    June 13, 2011 at 8:17 am

    #1337769

  • RE: Does anyone have a good reason to run xp_CmdShell?

    lol...i use it myself whenever i feel like it...but can i justify using it at all; it was the fastest to grab tool in the toolbox...nah, can't justify myself at...

    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!

    June 13, 2011 at 8:03 am

    #1337756

  • RE: Need a template to create Medicaid UB92 form from ssrs

    following up on what Ron said, my google search lead me to lots of pdf files, as well as some information about creating UB92 or it's "digital equivilent"

    is this just...

    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!

    June 13, 2011 at 7:50 am

    #1337746

  • RE: not able to connect to sql 2005 on windows 7 !!!

    on windows 7 machines, security is tighter...local users are not automatically added as SQL administrators unless you specifically add them;

    easiest way,since you said SQL 2005, is to use the surface...

    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!

    June 13, 2011 at 6:42 am

    #1337710

  • RE: How to drop the extended stored procedure

    that stored proc is used inside other system procedures...if you were to drop it, i guarantee you will, at a minimum, break replication, the SQL Agent, scheduled jobs,let alone lots...

    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!

    June 13, 2011 at 6:02 am

    #1337693

  • RE: One procedure to insertupdate all master tables using if statements

    I'm afraid the answer is "it depends"...we'd need to really see the procedure to give you a peer review and tell you what we thing is good, bad, or could...

    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!

    June 13, 2011 at 5:35 am

    #1337681

  • RE: Handling truncated leading spaces in Reporting Services

    you need to replace vbCrLf with the html break tag <br /> & vbCrLf, whether in the data source at SQL, or in the textbox/panel you are loading the data...

    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!

    June 11, 2011 at 7:48 am

    #1337377

  • RE: How to have a 'text' type column included in an index

    ok one imporvement i see is some out of date statistics on the Table CorrespondenceLog;

    the estimated plan expecting 4 rows, but the actual ended up using almost 12 million.

    can 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!

    June 10, 2011 at 1:53 pm

    #1337248

  • RE: How to have a 'text' type column included in an index

    great greg...can you post an Actual execution plan? that's where a few more details will help as 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!

    June 10, 2011 at 1:32 pm

    #1337232

  • RE: How to have a 'text' type column included in an index

    ok i see what you are saying...you have a slow query, and at least a portion of the slowness is probably attributable to the grabbing lots of rows 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!

    June 10, 2011 at 1:17 pm

    #1337220

  • RE: How to have a 'text' type column included in an index

    SQL Server indexes are constrained to a maximum width of 900 bytes; so you could include *part* of that text column, potentially;

    typically when you have to search a text/varchar(max) column,...

    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!

    June 10, 2011 at 1:02 pm

    #1337210

  • RE: Using SELECT INTO a bad practice?

    i wouldn't say bad practice; you'd have to review the logic to determine if the data REALLY needs to go into a temp table (like it's being further processed or...

    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!

    June 10, 2011 at 12:43 pm

    #1337199

Viewing 15 posts - 7,381 through 7,395 (of 13,460 total)