Forum Replies Created

Viewing 15 posts - 8,821 through 8,835 (of 13,460 total)

  • RE: getting duplicate records for a primary key column

    mostly your problem is your design is not using an identity...but it is also procedurally based, and not thinking in terms of SET based solutions.

    what if i were to insert...

    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!

    September 3, 2010 at 3:58 am

    #1216079

  • RE: getting duplicate records for a primary key column

    why are you using a GETNEWKEY functionality to generate a number for your PK column instead of allowing an identity column to generate the value for you? the identity property...

    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!

    September 3, 2010 at 3:48 am

    #1216075

  • RE: Connect from one instance to another via T-SQL ,SQL 2000

    it's fairly easy; you just need to add a linked server, and then select using 4 part naming conventions:

    EXEC master.dbo.sp_addlinkedserver @server = N'ANOTHERSERVER\INSTANCENAME', @srvproduct=N'SQL Server'

    EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname = N'ANOTHERSERVER\INSTANCENAME', @locallogin...

    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!

    September 2, 2010 at 8:09 am

    #1215628

  • RE: Adapting a Code

    crap someone else asked this exact same question a while ago and i answered it;

    is this a homework question?

    http://www.sqlservercentral.com/Forums/Topic968341-131-1.aspx

    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!

    September 2, 2010 at 7:05 am

    #1215570

  • RE: Array in SQL server

    SQL Server thinks of arrays as tables, so it doesn't have an array data type....

    to decode a string from a delimited list to a table, you can use one 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!

    September 2, 2010 at 5:51 am

    #1215525

  • RE: job is fail in sqlserver? what are the reasons to fail the job

    it depends on the job. way to many reasons to fail.

    a job can be poorly written, try to access databases or database objects that don't exist(anymore? maybe someone dropped 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!

    September 2, 2010 at 5:34 am

    #1215518

  • RE: Windows Authentication restriction

    it's possible, but let me explain the pitfalls.

    once i have a username and password with access to a database, i can use any application to get there...SSMS, a program i...

    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!

    September 2, 2010 at 4:56 am

    #1215501

  • RE: Restoring Master database different versions of same service pack

    for me, the master database doesn't have anything of interest besides logins;

    i would restore a master database as a user db so i could extract logins, if they were...

    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!

    September 1, 2010 at 11:36 am

    #1215179

  • RE: Accessing trigger tables (inserted/deleted) vai a stored procedure

    cycles through each field

    Without looking at your trigger, I'm thinking there may be a better or faster way to do whatever you are doing in your trigger;

    if your trigger...

    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!

    September 1, 2010 at 4:50 am

    #1214850

  • RE: sql server 2005 & 2008 installtion Drive selection

    the database engine and a lot of the support files must be installed on the %system% drive; after installation, you can move all the mdf/ldf files(alter database with move )...

    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!

    September 1, 2010 at 4:45 am

    #1214846

  • RE: Import to SQL from VFP table programmatically

    jesuslives01 (8/31/2010)

    Thanks but that gives me an error pointing to the last dirmsarf2:

    Incorrect syntax near 'dirmsarf2'.

    well, what is the name of the table inside the foxpro database? is it dirmsarf,...

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

    #1214564

  • RE: 4 Part Naming Convention

    yes that was what i was refering to, i could/should have been more precise, sorry;

    with a COUNT, the OutputList has no values, select a field instead to see stuff in...

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

    #1214440

  • RE: 4 Part Naming Convention

    believe it or not, NOT declaring objects with 4 part naming actually increases the overhead, admittedly by a very very tiny bit; The SQL Engine has to lookup (or infer)...

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

    #1214414

  • RE: How to convert Exponentials value to Numerics

    Mr.SQL DBA (8/31/2010)

    Hi SSC Experts,

    From the front end application a numeric value of 10 digits with datatype varchar(max) ex:9247497829 like Phone Number

    is entered by the front end user and 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 31, 2010 at 7:15 am

    #1214255

  • RE: Trigger to a View

    you might be able to add a job which checks for new entries in the view on an hourly basis or something, and have that job insert the new data;

    but...

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

    #1214248

Viewing 15 posts - 8,821 through 8,835 (of 13,460 total)