Forum Replies Created

Viewing 15 posts - 9,241 through 9,255 (of 13,460 total)

  • RE: matrix border formatting craps out when cell value is Nothing -- pic included

    i think it's an html thing, if you put a space or an html non-breaking space, i think you'll fix it:

    =" " & IIF(Fields!occ_period_id.Value = Parameters!spid.Value,"Red",IIF(Fields!show_date.Value = "Grand total" 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 15, 2010 at 7:50 am

    #1180419

  • RE: change data type in all the tables

    i think you can generate the ALTER TABLE ALTER COLUMN statements with this:

    select

    schema_name(objz.schema_id) as schemaname,

    objz.name as tablename,

    colz.name as columnname,

    colz.max_length,

    'ALTER...

    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, 2010 at 7:35 am

    #1180404

  • RE: How to use sqlcmd to run my create database/tables/sp's script

    well, the command line program osql can give you a list of all SQL servers that answer on the network, whether they are SQLExpress versions or not would require running...

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

    #1180329

  • RE: CLR Development: Visual Studio Pro Version Required?

    ok rich; I'm putting a link to CLR Database Project and it's solution; after unzipping it and opening it in the BIDS version of VS2008, if you go to 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!

    June 14, 2010 at 5:48 pm

    #1180154

  • RE: CLR Development: Visual Studio Pro Version Required?

    that doesn't sound right...if you can do File>>New Project, is there a template for Database Project?

    I know you can download the VS Database Template from MS, and there is instructions...

    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, 2010 at 1:07 pm

    #1180060

  • RE: How to use sqlcmd to run my create database/tables/sp's script

    well, i've done the basic setup lots of differnet ways, from providing a database for the dba to attach, to providing a script for the dba to run, to doing...

    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, 2010 at 7:28 am

    #1179848

  • RE: a question about trigger

    why back it up? at the moment of creation it is an empty copy of model. it would be better to simply schedule a script to backup every db 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 12, 2010 at 1:33 pm

    #1179563

  • RE: trigger error

    that's not the line raising the error; paste the whole trigger.

    the error line is going to say something like this:

    WHERE SomeVariable = (Select SomeVariable from someTable)

    the select in parenthesis 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!

    June 11, 2010 at 2:49 pm

    #1179438

  • RE: How to improve this query?

    this is just a WAG to get the max's without the temp table and double join;

    does this return the desired results? how does it perform?

    SELECT

    s1.Recordid,

    s1.SubrecordID,

    ...

    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, 2010 at 12:13 pm

    #1179371

  • RE: How to improve this query?

    well, without the execution plan that Wayne requested, we can only offer the obvious advice:

    the problem is probably the WHERE statement:

    WHERE (s1.Substantiation_Indicator = 'N'

    OR s1.Substantiation_Sequence_Letter_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!

    June 11, 2010 at 11:33 am

    #1179339

  • RE: TEXT/NTEXT Find and Replace

    tcshekar (6/11/2010)

    Got this error...on execution.

    Msg 280, Level 16, State 0, Line 1

    Only text, ntext, and image columns are valid with the TEXTPTR function.

    sdounds like you are trying to use 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!

    June 11, 2010 at 11:03 am

    #1179327

  • RE: Varchar sizing question

    Stumpy D (6/11/2010)[hrSo other than indexing restrictions, there is no difference if I declare a varchar(8000) and a varchar(10) to store a 10 character string?

    Seems odd as why even bother...

    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, 2010 at 9:20 am

    #1179265

  • RE: Can I FAX report from SQL Server 2005

    I don't think sql server does not have access to any printer objects; Because of that, I think what you want to do is use/create a program that reads...

    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, 2010 at 8:40 am

    #1179230

  • RE: Varchar sizing question

    i think the biggest impact on varchar sizes has to do with the ability to index the column.

    if the column is bigger than 900 bytes, the index rasies an 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!

    June 11, 2010 at 8:00 am

    #1179184

  • RE: Comma Issue

    take a look at the thread below; another poster had the exact same problem, except he had semicolons at the beginning at or end;

    there are some fine solutions in that...

    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, 2010 at 7:23 am

    #1179158

Viewing 15 posts - 9,241 through 9,255 (of 13,460 total)