Forum Replies Created

Viewing 15 posts - 8,071 through 8,085 (of 13,460 total)

  • RE: variable column count txt files to sql server table

    there are a number of posts by Jeff Moden to do this via BCP; he refer's to the issue as "ragged right";

    here's one example he posted to address the issue...it's...

    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 22, 2011 at 1:13 pm

    #1290073

  • RE: INVENTORY ONE TABLE CREATE HOW TO BALANCE QTY CARRY IN NEXT ROW

    consumable data for the next poster:

    With [MY DATE](ITEM_NAME , CODE , [DATE] , OB_QTY , RECD_QTY , ISSUE_QTY, BALANCE_QTY)

    AS

    (

    SELECT '5 PR CABLE','05','01/04/10','25','0','0','25' UNION ALL

    SELECT '5 PR CABLE','05','02/04/10','0','2','0','2' UNION ALL

    SELECT '5...

    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 22, 2011 at 12:55 pm

    #1290056

  • RE: Trigger help

    you might need to explicitly define the columns:

    INSERT INTO tblHistorySource(Column1,ColumnList,CreationDate)

    select Column1,ColumnList, getdate()

    from DELETED --the old values...new values are ijnt eht able if you need to compare them.

    also, completely remove 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!

    February 22, 2011 at 12:47 pm

    #1290052

  • RE: database tables change suggestion(urgent help pleasee)

    wouldn't the new to SQL2008 Change Data Capture do what you need? plenty of articles on that, when i tested it it worked really nice.

    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 22, 2011 at 12:27 pm

    #1290041

  • RE: Capturing Index script programmatically

    The scripts for an index, like the scripts for a table, don't actually get saved/stored the way a procedure or function's body does;

    it goes straight into the metadata, so 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!

    February 22, 2011 at 11:15 am

    #1289992

  • RE: find top 50 values from 90% records of table.

    abhas (2/21/2011)

    Thank u Lowell

    But i need avarage upon time not on date.and time is in miliseconds.So i have to find largest 90% avarage from table.How can we do?

    Regards

    Abhas.

    details....

    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 21, 2011 at 9:52 am

    #1289484

  • RE: Shuffling Data in sql 2005 table

    I've got a nice example where a replace all the Last Names of a table with one of the standard HTML colors;

    I use variations of this to munge data so...

    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 18, 2011 at 3:04 pm

    #1289094

  • RE: sql trigger get incoming SQL

    just to confirm, from inside a trigger, you cannot always get the whole SQL statement; you can use DBCC inputbuffer, but that returns only the first 255 chars; a lot...

    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 18, 2011 at 2:49 pm

    #1289087

  • RE: Why does it take longer to run a script through a linked server?

    Colleen nailed it, I'll just try to explain:

    There are several threads here on SSC on Linked Sserver performance;one thread which stated that openquery against a linked server was faster for...

    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 18, 2011 at 12:36 pm

    #1289004

  • RE: Laptop suggestions with VS2008 in mind?

    As an FYI, i bought a recent Win7 HP laptop with 19" wide screen and full keyboard.

    While i love the OS and layout, I get more Blue Screens Of Death...

    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 18, 2011 at 12:18 pm

    #1288996

  • RE: MS SQL DATABASE CONNECTING TO CLASSIC ASP

    well... start with the basics....if you want real help, you'll have to give real details.show us the exact code you are using.

    comment out 99% fo the code , run 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 18, 2011 at 11:34 am

    #1288972

  • RE: MS SQL DATABASE CONNECTING TO CLASSIC ASP

    the section you pasted looks like it came from a .net config file. i think you're having trouble directly related to that....are you doing ASP classic or ASP.NET?

    the connection string...

    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 18, 2011 at 8:38 am

    #1288884

  • RE: Need help identifying query

    Mr Magoo I'd love to hear the back story on this...might be very educational for us....

    what happened that made you start thinking something was flooding the server...after looking at 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 18, 2011 at 7:18 am

    #1288836

  • RE: MS SQL DATABASE CONNECTING TO CLASSIC ASP

    i realize this is probably a smippet, and not the whole page, but bear with me.

    I do not see the connectionstring being assigned to the connection object, nor do 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!

    February 18, 2011 at 5:46 am

    #1288750

  • RE: PROC Questions

    Khades (2/16/2011)

    Oh Thanks, awesome!

    What about question 2 though? Will having Child procs for the code to run parallel to each other improve performance?

    And can 1 proc run parallel to itself...

    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 16, 2011 at 5:24 pm

    #1288003

Viewing 15 posts - 8,071 through 8,085 (of 13,460 total)