Forum Replies Created

Viewing 15 posts - 8,041 through 8,055 (of 13,460 total)

  • RE: View with 2 fields combined

    a_ud (2/28/2011)

    PS: can't you create 3 calculated fields F1, F2, F3 where F1 exists only when ContactType is Phone (and shows Contactinfo), and same for F2 and F3?

    yes, you can;...

    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!

    February 28, 2011 at 10:58 am

    #1292455

  • RE: In Search of a MS SQl developer job

    http://jobsearch.monsterindia.com/searchresult.html?fts=sql&loc=

    yep...monsterindia.com...easy enough to find once you know you want to search fro "sql jobs india"

    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!

    February 28, 2011 at 8:35 am

    #1292366

  • RE: In Search of a MS SQl developer job

    what about experience in programming languages?

    Most of the people we hire in my shop for example are C# or vb.net developers, and we look for SQL skills in that mix.

    Unfortunately,...

    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!

    February 28, 2011 at 8:27 am

    #1292350

  • RE: View with 2 fields combined

    I think you can do what you want as a set of case statements

    let me know if this model works for you:

    SELECT

    OtherFields,

    CASE

    WHEN...

    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!

    February 28, 2011 at 6:42 am

    #1292275

  • RE: is UNION ALL inherantly slow?

    I agree With Dave B; bcp, or BULK INSERT, or openquery would all be blazingly fast in comparison;

    I've used bulk insert to load files with a million rows in under...

    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!

    February 28, 2011 at 5:34 am

    #1292240

  • RE: drive to install sql server

    for the executable and services, you don't have a choice...it must be installed on the same drive as the operating system.

    after the install, you can move most of 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!

    February 26, 2011 at 8:45 pm

    #1291968

  • RE: Get DDL for any SQL 2005 table

    Also because mine is purtier!

    one of the main reasons i did this was formatting, and removing/pruning items that are optional in a table script, so the don't need to...

    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!

    February 25, 2011 at 11:15 am

    #1291685

  • RE: Get DDL for any SQL 2005 table

    well, i've got two variations of this...one returns the definition as a single varchar(max), and the other splits the same varchar(max) on CrLf so it's multiple rows.

    one purpose is standardization...developers...

    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!

    February 25, 2011 at 10:28 am

    #1291649

  • RE: Disappearing DML Triggers

    the drop of a trigger would be in the default trace, so you might be able to narrow down if it's a person or a process based on teh hostname,...

    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!

    February 25, 2011 at 8:58 am

    #1291592

  • RE: DB Performance is deteriorating over the time

    Grant said it all; you'll have to provide more details to get more relevant answers.

    the only thing i can offer is it is my experience that for some specific...

    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!

    February 25, 2011 at 7:42 am

    #1291534

  • RE: Query to get 2nd largest value

    chitturiii (2/25/2011)

    Thanks Lowell...

    I think the query goes on as:

    Select top 1 sal from employee where sal in (select top 2 sal from employee order by sal desc)

    order by sal

    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!

    February 25, 2011 at 6:34 am

    #1291492

  • RE: Cusror Loop to attach databases which are numbered from 1 to 294

    here's an example command for attaching a database; you'd have to do as suggested and script out the dynamic portions...the database name and the file path.

    it all starts with 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!

    February 25, 2011 at 5:43 am

    #1291473

  • RE: Query to get 2nd largest value

    this is a fairly easy question, and it comes up a lot in homework type situations; so I'll give you a hint and information rather than a full answer:

    there's two...

    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!

    February 25, 2011 at 5:33 am

    #1291467

  • RE: BULK INSERT multiple files without xp_cmdshell

    the BULK INSERT command doesn't use xp_cmdshell it basically has the same functionality as bcp(which does require xp_cmdshell);

    here's an example of multiple files via BULK INSERT...

    this example assumes I had...

    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!

    February 24, 2011 at 2:39 pm

    #1291292

  • RE: Procedure To Get Primary Key Columns Names, Ordinal Position and DataType From System Tables BAsed On Table Name

    William this seems to work for me: maybe you missed the double join?

    SELECT

    c.COLUMN_NAME,

    c.ORDINAL_POSITION,

    cls.DATA_TYPE

    FROM

    INFORMATION_SCHEMA.TABLE_CONSTRAINTS p

    INNER JOIN INFORMATION_SCHEMA.KEY_COLUMN_USAGE c

    ON c.TABLE_NAME...

    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!

    February 24, 2011 at 1:42 pm

    #1291268

Viewing 15 posts - 8,041 through 8,055 (of 13,460 total)