Forum Replies Created

Viewing 15 posts - 4,876 through 4,890 (of 13,460 total)

  • RE: Avoid characters that viloate UTF-8 Encoding

    ok, i just googled "Non UTF-8 Characters", and the only thing i can find is when something got malformed; otherwise, It looks like UTF covers teh whole range of...

    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!

    August 23, 2012 at 2:42 pm

    #1529463

  • RE: How can I pass table row as a in parameter to stored proc

    Ajdba (8/23/2012)

    I am not sure why it is not liking EDWGEARS..GT_GEARS.VW_GEARS_REPORT_DATA conventions;

    LinkedServerName.DatabaseName.SchemaName.TableName.

    i doubt very much you have a schema name named GT_GEARS

    it's much more likely that it should be EDWGEARS.GT_GEARS..VW_GEARS_REPORT_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!

    August 23, 2012 at 12:42 pm

    #1529413

  • RE: When to drop temp table?

    I'm trying to find the thread, but we once did a specific test here on the forums about whether there is a performance hit on whether you explicitly drop a...

    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!

    August 23, 2012 at 9:02 am

    #1529314

  • RE: nt given output server2000

    into #temp

    double check your code:

    the only thing that does is create a temp table.

    then it leaves at the end of the procedure.

    maybe you wnat to SELECT from that temp 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!

    August 23, 2012 at 7:20 am

    #1529231

  • RE: Helpdesk software which integrates with TFS

    anthony not sure if you have seen this yet;

    there's a helpdesk app called ZenDesk (no experience with it, sorry), and there is a codeplex project that integrates Zendesk with TFS...

    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!

    August 23, 2012 at 6:28 am

    #1529207

  • RE: Drop Table if exists

    laurie-789651 (8/23/2012)

    Why is avoiding syntax checking a good idea?

    It's a holdover from how my scripts get deployed; trying to avoid GO statements, so everything gets wrapped into dynamic SQL for...

    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!

    August 23, 2012 at 6:07 am

    #1529200

  • RE: Problem with query

    the table layout is critical here. you've got to provide the DDL to get a good answer;

    are Astore and bstore columns in the same table, or two differnet tables? 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!

    August 23, 2012 at 5:57 am

    #1529197

  • RE: Drop Table if exists

    I tend to simply check for the object_id a lot:

    I also tend to put the command for create/drop/alter for the table in dynamic SQL to avoid syntax checking.

    IF OBJECT_ID('ABC_School') 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!

    August 23, 2012 at 5:50 am

    #1529192

  • RE: table size growth report

    eugene.pipko (8/22/2012)

    Thanks for reply. I like the idea of adding the schema to what I already have. You wrote:

    <quote>The other thing you might do is take sp_spaceused, get the code...

    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!

    August 23, 2012 at 5:45 am

    #1529190

  • RE: Need a "Test" or Dummy XP Dll

    RBarryYoung (8/22/2012)

    That worked perfectly, it was exactly what I needed. Thank Lowell! 🙂

    Sweet! glad that worked! I know I had installed it once on both a 2005 32 bit,...

    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!

    August 23, 2012 at 5:23 am

    #1529181

  • RE: Send email with HTML format

    simon.letts (8/23/2012)

    That is exactly it Lowell!! Thanks so much for your time on this, it works a treat and saves me time re-working other solutions 🙂

    Excellent! glad this...

    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!

    August 23, 2012 at 5:21 am

    #1529180

  • RE: UDF In SQL 2005 when invoked throws error msg 512: Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.

    the error is occuring in the UDF itself, it looks like; can you post that? we can help you rewrite it to avoid that error.

    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!

    August 23, 2012 at 5:21 am

    #1529179

  • RE: Keep Package Running if Webclient has Timeout

    i think what you want is instead of the web client, say executing a stored procedure that does a bunch of work, you want to have the web page activiate...

    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!

    August 22, 2012 at 12:13 pm

    #1528835

  • RE: Collapse Logic in SQL

    looks like GROUP BY , and getting the MIN and MAX values;

    what have you tried so far?

    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!

    August 22, 2012 at 11:49 am

    #1528810

  • RE: Fantasy football 2012

    Local radio station recently said that people in a Fantasy Football League average 10 hours per week on Fantasy Football?

    Is that an exaggeration or do you think that is a...

    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!

    August 22, 2012 at 11:26 am

    #1528803

Viewing 15 posts - 4,876 through 4,890 (of 13,460 total)