Forum Replies Created

Viewing 15 posts - 9,451 through 9,465 (of 13,460 total)

  • RE: xml schema definition for the database tables

    i usually add a blank xsd file to my project, then with server explorer, create a connection to the database.

    once that is there, you can drag and drop all 60...

    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!

    May 17, 2010 at 4:53 pm

    #1168521

  • RE: Enforce entry in one of two fields

    i had done this requirement before, but additionally one of the values had to be populated...i didn't see if both values were allowed to be null or not;

    the only way...

    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!

    May 17, 2010 at 3:49 pm

    #1168491

  • RE: sp_rename error

    ok this was kewl to know;

    once you doink up an object name so it has a dot in it, you need your brackets around the object, and it was easier...

    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!

    May 17, 2010 at 11:51 am

    #1168386

  • RE: How to do an ongoing count

    {edit after i posted, i saw this is in a SQL 2000 forum, and this requires 2005 and up.

    doing this in SQL2000 usually requires asticking the results in a temp...

    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!

    May 17, 2010 at 10:45 am

    #1168355

  • RE: Script task to write to fixed width file

    it's an ugly implementation, but it works.

    it's based on the actual contents....if something was defined as a varchar(max), how big is it in a fixed with file?

    for me,i'm looping thru...

    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!

    May 17, 2010 at 8:18 am

    #1168283

  • RE: Working With comma Separated values

    good job on providing the table structures and the desired output;

    if you had posted the INSERT INTO for the data, your question would be perfect!

    to convert rows into a comma...

    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!

    May 17, 2010 at 7:04 am

    #1168238

  • RE: SQL 2000 IDENTITY ON/OFF

    ahh that's just syntax; the SET switch is for IDENTITY_INSERT, all one word with an underscore,no brackets around identity; i fat fingered my example and forgot the underscore.

    --you had SET...

    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!

    May 17, 2010 at 6:29 am

    #1168223

  • RE: Query Selectivity Computation

    he had a similar thread on this;

    i think the original poster is trying to get a formula like (#records matching my WHERE clause) / Total Records, but he thinks it...

    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!

    May 17, 2010 at 5:56 am

    #1168207

  • RE: Difference between Migration and Upgradation in sqlserver?

    Seriously? you need to ask? just by the question itself, you can tell it involved moving something(migration)

    from one server to another vs upgrading an existing server?

    you are posting...

    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!

    May 16, 2010 at 8:31 am

    #1168013

  • RE: what are the roles and responsibilities of sql server dba job?

    i just saw something with that same question here that woudl probably answer the question more completely.

    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!

    May 16, 2010 at 8:28 am

    #1168012

  • RE: Finding similar values in a column

    another thing I've done is use a Tally table to split the company name into single words....then try to match the single word against another copy of the table;

    that way,...

    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!

    May 15, 2010 at 7:57 pm

    #1167979

  • RE: Script task to write to fixed width file

    apache i don't know SSIS, but i know .NET;

    I've already written some code that i use in .NET all the time that takes any dataset and returns the data as...

    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!

    May 15, 2010 at 4:50 pm

    #1167961

  • RE: Reduce the time spent on cross process communication

    Hi Neel;

    I'd expect anything called 10K times to be in the realm of a max of 400 items per second; so for 10K calls, i'd expect that to take 25...

    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!

    May 15, 2010 at 6:12 am

    #1167906

  • RE: How to copy the table's structure of dbo schema to other schema

    apjchandresh (5/15/2010)

    Yes ,But when running the database script on stroed procedure the 'Go'Statement can create problem,and Without Go statement the Relation ship and other contriants are not created...

    dynamic sql....

    declare...

    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!

    May 15, 2010 at 6:06 am

    #1167905

  • RE: How to copy the table's structure of dbo schema to other schema

    why can't you script the table out? and change dbo to the new schema name?

    explain a bit more why you need to clone the table(and the data?) more than one...

    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!

    May 15, 2010 at 5:44 am

    #1167903

Viewing 15 posts - 9,451 through 9,465 (of 13,460 total)