Forum Replies Created

Viewing 15 posts - 5,101 through 5,115 (of 13,460 total)

  • RE: How to display current week as 0 for each year

    84gopi all 14 of your posts over the last 20 days are on the same subject: showing your data by weeks and ranges of weeks, in what i think 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 1, 2012 at 7:25 am

    #1520246

  • RE: Why there is a Limitations on Index size (900 Bytes)?

    it's not a one to one relationship. more than one index value will be able to fit in each 8k page;

    so an index will be made up of as many...

    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 1, 2012 at 5:47 am

    #1520192

  • RE: Are the posted questions getting worse?

    GilaMonster (7/31/2012)

    Evil Kraig F (7/31/2012)

    Ugh, sick for a week blows. I miss anything of import since last Tuesday?

    Vacation! Mine! (no, you're not invited 🙂 )

    speaking of vacations, I just...

    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!

    July 31, 2012 at 2:33 pm

    #1519974

  • RE: stored procedure- error

    Mr. Popki nailed it;

    your excellent error message shows the value 2012061414297 is being inserted into a table;

    that value is larger than the max of an int:

    select 2012061414297

    select convert(int,2012061414297)

    (1 row(s) affected)

    Msg...

    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!

    July 31, 2012 at 2:25 pm

    #1519969

  • RE: Identifying rows by customer

    similar to what Jayanth suggests, something like

    customer_number

    + CONVERT(varchar,row_number()

    OVER (partition by customer_number

    ORDER BY customer_number)

    )

    would work as well.

    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!

    July 31, 2012 at 2:20 pm

    #1519964

  • RE: Just a rant about how third parties design apps

    the reason is to make is a beauty of a gui/user tool.

    yes for a simple add column, it's a trivial one line wonder in TSQL.

    But they put logic in place...

    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!

    July 31, 2012 at 2:05 pm

    #1519954

  • RE: How can I attract Senior Database Administrator candidates?

    So many great posts on this one; I'll add a couple of my own thoughts.

    Managers worry that the guys who work from home put an hour at the desk, and...

    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!

    July 31, 2012 at 9:49 am

    #1519813

  • RE: Monitoring Changes to Users in databases.

    beautiful correction and thank you,

    I updated my snippets with a note so i remember that.

    thanks!

    opc.three (7/31/2012)

    The DEFAULT option works as you described, but you'll need to set @path this 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!

    July 31, 2012 at 7:03 am

    #1519694

  • RE: Linked Server vs Firebird

    i had to google that one, as i never had to connect to a firebird database yet;

    this page has screenshots and code that should help:

    http://www.ibprovider.com/forum/site/viewtopic.php?t=19

    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!

    July 31, 2012 at 6:09 am

    #1519651

  • RE: Can't drop primary key?

    what results do you get when you run EXEC sp_fkeys myTable?

    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!

    July 31, 2012 at 5:59 am

    #1519642

  • RE: Monitoring Changes to Users in databases.

    na1774 (7/30/2012)

    OMG. You are Amazing. Thank you very much. You were a ton of help.

    I was wondering when we run this does it query the current trace file. What 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!

    July 30, 2012 at 4:07 pm

    #1519468

  • RE: Monitoring Changes to Users in databases.

    ok, you can get whodunnit info fromt eh default trace, i just tested this:

    so if not too much time has passed, you can find out who;

    declare @path varchar(255)

    SELECT @path =...

    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!

    July 30, 2012 at 2:36 pm

    #1519422

  • RE: last date table was updated

    nope, sorry.

    unless you have some sort of auditing already in place, whether a server side trace, Change Data Capture, Change Tracking, SQL Audit, or some thing like triggers 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!

    July 30, 2012 at 1:45 pm

    #1519392

  • RE: Importing Access Database table data using Stored Procedure

    mramey (7/30/2012)

    Yes the structures are always the same. As I said before I will pass the path and names to the SP from an access vba application. 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!

    July 30, 2012 at 1:33 pm

    #1519385

  • RE: How to get sql server ip address

    Scott D. Jacobson (7/30/2012)

    Lowell, just out of curiosity, what would the result set look like on say a clustered SQL Server instance compared to standalone? I don't have the ability...

    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!

    July 30, 2012 at 1:16 pm

    #1519373

Viewing 15 posts - 5,101 through 5,115 (of 13,460 total)