Forum Replies Created

Viewing 15 posts - 5,011 through 5,025 (of 13,460 total)

  • RE: Triggers

    a nice first effort!

    i think the issues still outstanding are as follows:

    i think you are counting all rows, not names:

    it's like counting the students in calss(ie 31) but not how...

    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 8, 2012 at 9:00 am

    #1523170

  • RE: Triggers

    think it through...how does a simple count() tell you whether there are duplicates?

    I'd don't think you have teh test down yet.

    are you familiar enough with SQL triggers that you know...

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

    #1523141

  • RE: procedure started taking longer time to retrieve data in last two days

    well like i said, the key is a redesign.

    first, i agree on getting rid of the xml for the list of years; it might be misleading, but 99 percent 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 8, 2012 at 8:00 am

    #1523122

  • RE: My 10,000th Post!

    Sean Lange (8/7/2012)

    Just use DBCC Timewarp and you can the Harley today!!!

    The funny thing is that your points show as 9,990 next to your icon but shows as 10,000 on...

    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 7, 2012 at 2:07 pm

    #1522830

  • RE: Deleting records from a table that is actively written too..

    Thanks for the Articles Gianluca!

    good reading.

    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 7, 2012 at 1:06 pm

    #1522795

  • RE: Import data from SQLite database into SQL server 2008 Database.

    i've done this in vb.Net / C#.Net; let us know if you are a programmer and just need a deeper code example.

    once i had the reference to System.Data.SQLite it's really...

    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 7, 2012 at 12:51 pm

    #1522788

  • RE: Good C# forum ?

    for quesitons,

    i tend to read stackoverflow.com;

    for code examples i like codeproject.com a lot; i love browsing the codeplex site for other examples as well;

    not yet familiar with a decent...

    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 7, 2012 at 12:30 pm

    #1522777

  • RE: Linked server permissions for a sql user

    not sure on this one now; i'm clueless on MAS90 in this case; any hints from Google on the issue?

    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 7, 2012 at 12:28 pm

    #1522776

  • RE: procedure started taking longer time to retrieve data in last two days

    that needs so much work, on so many levels;

    there's multiple cursors, cursor within a cursor, wow.

    how many total rows are in the EDWGEARS linked server table VW_FRED_AADT_HIST?

    is EDWGEARS ...

    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 7, 2012 at 11:59 am

    #1522761

  • RE: Crazy Interviews

    Daniel Bowlin (8/7/2012)

    Then there is the other end of the spectrum. I once had an interview that was 8 x 30 minute sessions with a total of 13 people...

    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 7, 2012 at 11:33 am

    #1522743

  • RE: Stored Proc to split data in two

    here's an example i wrote that splits sys.tables into five columns;

    i hope it's obvious how you could apply the same logic to your data.

    WITH

    baseCTE AS

    (

    SELECT

    ...

    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 7, 2012 at 11:30 am

    #1522742

  • RE: Crazy Interviews

    I had a similar interview like laurie had years ago; they were interested in whether I knew vb6, ADO and whether i knew javascript; the questions had a couple 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 7, 2012 at 11:00 am

    #1522731

  • RE: Linked server permissions for a sql user

    you said if you connect to teh server as your own user, you can select from that table via the linked server, right?

    that error sounds like the MAS90 user you...

    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 7, 2012 at 10:53 am

    #1522729

  • RE: Open port?

    hard to give any good advice, so many details will have to be found out;

    the web server is probably in it's own DMZ, on a differnet subnet than the normal...

    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 7, 2012 at 10:52 am

    #1522728

  • RE: .NET 3.5.1 and 4.0 on same server

    nope no issue at all;

    they get installed in seperate directories, ie inside C:\Windows\Microsoft.NET\Framework64

    you'll see V2.0.50727,v3.0,v3.5 and v4.0.30319

    when you create a visual studio project, you can target which framework to use.

    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 7, 2012 at 10:44 am

    #1522721

Viewing 15 posts - 5,011 through 5,025 (of 13,460 total)