Forum Replies Created

Viewing 15 posts - 7,366 through 7,380 (of 13,460 total)

  • RE: Deleting 4000 different records from a table with where and conditions on each row.

    SQLRNNR (6/15/2011)

    If there is nothing about those 4000 records to be deleted that makes them similar to one another, then you have to delete 1 by one. If 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 15, 2011 at 12:33 pm

    #1339216

  • RE: Conversion failed when converting the varchar value '.' to data type int

    select convert(int,'.') --fails

    select convert(money,'.') --0.00

    so if your data is only a period, what value did you expect?

    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 15, 2011 at 11:06 am

    #1339148

  • RE: Handling error in t-Sql script DURING Create Procedure

    i think you'll have to switch to dynamic sql instead for stored procs,views and functions...

    edit: just plain bad advice/not needed. see opc.three's excellent comment below.

    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 15, 2011 at 9:37 am

    #1339089

  • RE: msg 15530...object already exists...

    any possibility it's not a table, but a view or proc or a poorly named constraint or something that happens to be named 'sample'?

    select

    schema_name(a.schema_id) as SchemaName,

    a.name as ObjName,

    a.type

    from...

    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 15, 2011 at 9:11 am

    #1339062

  • RE: Missing Database

    Satya_skj (6/15/2011)

    You should review the SQL Server error log for date/time when this is happening and as explained you might review the number of users with SYSADMIN privileges.

    actually, a user...

    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 15, 2011 at 4:46 am

    #1338867

  • RE: SP

    Sean Lange (6/14/2011)

    yes

    😀

    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 14, 2011 at 12:43 pm

    #1338611

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

    One Procedure To Rule Them All? Lord Of The Rings Style?

    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 14, 2011 at 9:53 am

    #1338489

  • RE: your spare time?

    i recently threw some of my free time at a local non-profit; they've been around for twelve years, but still didn't have a web site.

    That was one of those undefined...

    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 14, 2011 at 9:12 am

    #1338457

  • RE: Error while connecting a password protected MS access 2003 database from MS SQL 2005/2008

    based on the error, is there any chance someone has the database open? the linked server requires exclusive access, right? that error "It is already opened exclusively by another user,...

    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 14, 2011 at 9:03 am

    #1338448

  • RE: Missing Database

    Syed Jahanzaib Bin hassan (6/14/2011)

    Give other users Readonly rights

    ...and then try to take the full backup

    ...and then restore it with different name

    ...after restore is complete then drop...

    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 14, 2011 at 7:02 am

    #1338340

  • RE: Odbc Management Studio very interesting

    i'll leave the research and testing to you, but here's a quick list, in the order that i would try first:

    1. use the OPTION(OPTIMIZE FOR @p1 UNKNOWN) or OPTION(OPTIMIZE...

    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 14, 2011 at 6:36 am

    #1338315

  • RE: Odbc Management Studio very interesting

    sounds like "parameter sniffing"

    typical symptoms:

    1. SSMS with hardcoded values = fast

    2. With Recompile = fast

    3. run from an application with values other than you tested with = slow.

    there's a lot...

    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 14, 2011 at 6:09 am

    #1338294

  • RE: difference between result in Studio and ASP

    i think it's all back to html and your form...clearly someone typed a value into a input type="text", right?

    and all values in a form are encoded to html-acceptable values....

    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 13, 2011 at 11:04 am

    #1337918

  • RE: Multiple data fields

    missing too many details..

    you have two tables, header and footer, or is this a text file?

    if it is a pair of tables, is there a relationship betwene the header table...

    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:38 am

    #1337847

  • RE: difference between result in Studio and ASP

    yep implicit conversion:

    also note your command is wide open to sql injection; you'd be better off switching to parameters.

    add the N to the front of your command:

    sqlString...

    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:24 am

    #1337832

Viewing 15 posts - 7,366 through 7,380 (of 13,460 total)