Forum Replies Created

Viewing 15 posts - 10,846 through 10,860 (of 13,460 total)

  • RE: Change value returned by getdate()

    why not create a user defined function on the server, ie dbo.mydate()

    that returns a specific datetime value; it could return something like the calculated last business day, or 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!

    July 11, 2009 at 11:36 am

    #1023539

  • RE: Add column at ordinal position programmatically

    Thank you! I consider that very high praise coming from you!

    I'll submit both the 2000 and the 2005 scripts to the scripts here;

    I had slapped together an article 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!

    July 11, 2009 at 9:02 am

    #1023505

  • RE: T-SQL column value concatination

    Lynn Pettis (7/10/2009)

    I am really getting tired of this intermittent issue of not being able to post code on forums from work.

    Lynn what browser are you using? 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!

    July 10, 2009 at 11:31 am

    #1023236

  • RE: How to Remove a character in the middle of a stirng

    i saw that after you posted....i'm embarrassed to offer it now , since STUFF is such a better solution

    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 10, 2009 at 11:09 am

    #1023225

  • RE: How frequently we need to take full and Log backkups of System databases??

    i think it goes to how much business data would be lost.

    if the system crashed half an hour before the next log backup, and you had to restore to 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!

    July 10, 2009 at 11:07 am

    #1023223

  • RE: How to Remove a character in the middle of a stirng

    first, let me thank you for the CREATE TABLE and INSERT code; it helps enourmously. way to go!

    here's one way to do it; here i'm assuming the column is exactly...

    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 10, 2009 at 10:45 am

    #1023208

  • RE: capture sql statements

    did you drop your temp table so it can be recreated with the new column?

    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 10, 2009 at 10:36 am

    #1023198

  • RE: capture sql statements

    you had a few errors in what you were trying to do;

    dbcc inputbuffer returns a table with 3 columns...you have to capture the columns.

    your concatenation was not quite right;

    hre's 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!

    July 10, 2009 at 10:26 am

    #1023192

  • RE: DB object dependents.

    maybe you are comparing it to the way oracle works? oracle is very user centric...delete a user, and you delete all the data owned by that user. could be gigs...

    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 10, 2009 at 10:19 am

    #1023185

  • RE: query running now for over 3 hours

    with massive updates like that I think it is a lot easier to undo or stop if you did the updates in batches, instead of trying to do the whole...

    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 10, 2009 at 8:14 am

    #1023052

  • RE: Select Where Any Column Equals (or Like) Value

    I'd seen a similar requirement before, so I created this procedure...you have to pass it two parameters: the tablename and the search term.

    it uses dynamic sql to quiery just 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!

    July 10, 2009 at 6:41 am

    #1022979

  • RE: How does the points system work?

    ok, it's the middle of the night, and to boost my coolness, i answered a hundred or so questions in the Question of the Day section;

    they don't get added...

    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 10, 2009 at 12:03 am

    #1022853

  • RE: How to set up oracle 11g as linked server in sqlserver 2005

    oops duplicate reply from me somehow...

    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 9, 2009 at 11:26 pm

    #1022851

  • RE: How to set up oracle 11g as linked server in sqlserver 2005

    here's the code I use to add a linked server; there's no difference between a linked server for 10G vs 11G as far as I know.

    --#################################################################################################

    --Linked server Syntax for Oracle...

    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 9, 2009 at 11:23 pm

    #1022850

  • RE: Scripts to create AdventureWorks

    definitely permissions related...operating system privileges, not related to SQL.

    i think if you right click on the shortcut to SQL Server Management Studio, you can choose Run As...

    if you do 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!

    July 9, 2009 at 3:30 pm

    #1022724

Viewing 15 posts - 10,846 through 10,860 (of 13,460 total)