Forum Replies Created

Viewing 15 posts - 8,386 through 8,400 (of 13,460 total)

  • RE: Temp table (#tname) causing database blocking on 'drop table #tname' call w/in stored procedure

    there is a forum post on here somewhere where someone compared explicitly dropping a temp table created inside a proc, vs letting the system destroy it automatically when 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!

    November 22, 2010 at 9:19 am

    #1253822

  • RE: how many variables can I have?

    BenWard (11/22/2010)

    Thanks lowell.

    These aren't input parameters but rather individual variables created like DECLARE @fYetAnotherDamnedNumber AS FLOAT

    I'm going crosseyed looking at so many variables!

    ok, ASFAIK, ither than memory/disk constraints, there's no...

    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!

    November 22, 2010 at 8:48 am

    #1253804

  • RE: how many variables can I have?

    from my old notes, SQL2000 had these limits. 2005/2008 might be more now.

    ·UDF can have upto 1023 input parameters, Stored Procedure can have upto 2100 input parameters.

    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!

    November 22, 2010 at 8:04 am

    #1253760

  • RE: Can you restore Enterprise Edition databases to Developer Edition Servers?

    as long as the other instances are also SQL2008 R2, then yes.

    the backup is stored in a specific format to teh SQL version; it's not specific to the instance type...

    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!

    November 22, 2010 at 7:48 am

    #1253745

  • RE: Error Executing the Convert Function. Please assist.

    also a valid file name cannot have colons in it('D:\backup\AdventureWorks_22 Nov 2010 19:29:35:003.BAK'), so you need to make sure the string you are building is valid for a filename.

    i usually...

    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!

    November 22, 2010 at 7:17 am

    #1253724

  • RE: Dynamic query in a function

    if you take a proc, stick it in the master database, and mark it as a system object, then it will use the datasase reference of the calling SQL.(it also...

    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!

    November 22, 2010 at 6:10 am

    #1253687

  • RE: Reading SQL Server's Transaction Log

    I believe the target schema is 2008; it worked just fine for me...the object id of my table was actually exactly the same as the article.

    in 2005 Express, i get...

    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!

    November 22, 2010 at 5:51 am

    #1253673

  • RE: How to excecute a SELECT statement from a computer w/o SQL SERVER to produce a text file from SQL server?

    malik_nagel (11/21/2010)

    I have a computer that is NOT a SQL server and that has only ODBC access to an external SQL server. What is the best way to execute...

    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!

    November 21, 2010 at 8:48 pm

    #1253568

  • RE: help needed

    Sean Lange (11/19/2010)

    The simple piece I posted should work fine for that format too. Simple, clean, fast. 🙂

    gotta agree; clean fast code that takes into consideration everything wer've seen so...

    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!

    November 19, 2010 at 9:41 am

    #1253154

  • RE: help needed

    depending on the data, for example if it was always N{quote}{three chars}{quote}{Comma}

    you might just use STUFF and a tally table to for to the length of the variable

    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!

    November 19, 2010 at 8:38 am

    #1253098

  • RE: best course of action

    first, it's a creepy requirement to uppercase everything without reviewing the data.

    do a backup before you run the results of this query. someone undoubtedly did not think this requirement...

    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!

    November 19, 2010 at 8:31 am

    #1253090

  • RE: help needed

    Sean Lange (11/19/2010)

    You could use the replace function to remove N' and replace it with '

    that's work pretty well, except for those rare cases when a variable between quotes ends...

    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!

    November 19, 2010 at 8:04 am

    #1253064

  • RE: VB.Net or Not

    IMHO, it depends on the syntax you are more familiar with to soften the learning curve.

    .

    learning a "new" language is really more about two things: learning the basic syntax, 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!

    November 19, 2010 at 7:59 am

    #1253061

  • RE: Extremely slow rendering in Internet Explorer 8

    wow, that was my best guess, As I'm on a listserv for Watin(Web Application Testing in .NET...IE/firefox browser automation)

    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!

    November 18, 2010 at 11:15 am

    #1252664

  • RE: Extremely slow rendering in Internet Explorer 8

    i don't have IE8 at work, but this website has a ton of screenshots that might help;

    :

    http://blogs.msdn.com/b/ie/archive/2008/08/27/introducing-compatibility-view.aspx

    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!

    November 18, 2010 at 8:07 am

    #1252540

Viewing 15 posts - 8,386 through 8,400 (of 13,460 total)