Forum Replies Created

Viewing 15 posts - 1,726 through 1,740 (of 13,460 total)

  • RE: Extracting Numbers from String

    Eirikur Eiriksson (6/2/2015)

    Lowell (6/2/2015)

    take a look at this thread from a while ago: it's got some excellent examples on stripping out non-numeric characters in the fastest way possible.

    do you have...

    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!

    June 2, 2015 at 2:25 pm

    #1802456

  • RE: Extracting Numbers from String

    take a look at this thread from a while ago: it's got some excellent examples on stripping out non-numeric characters in the fastest way possible.

    do you have a StripNonNumeric ITVF...

    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!

    June 2, 2015 at 1:39 pm

    #1802431

  • RE: Creation of random password which is easy to remember!!

    For assigning an easy to remember initial password, i like to use a dictionary plus a couple of random numbers.

    using a table of animal names, HTML Color Names or things...

    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!

    June 2, 2015 at 11:52 am

    #1802383

  • RE: Missing Identity Numbers

    i belive a serverice stop and start of SQL automatically bumps identity seeds by 1000 in SQL2012

    read about the feature / defect here:

    https://social.msdn.microsoft.com/Forums/sqlserver/en-US/3d256650-0e94-4d0f-8b52-0ba6e1903215/primary-key-auto-incrementing-by-1000-instead-of-1

    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!

    June 2, 2015 at 11:39 am

    #1802380

  • RE: Send subscriptions to email stored in the table

    yes.

    on codeplex.com, there is free, available source code for at least two projects i know of that lets you do data driven subscriptions from SQL Standard instead of enterprise.

    my...

    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!

    June 2, 2015 at 5:41 am

    #1802248

  • RE: Method for triggering the automatic start of a SQL Trace

    you can create a different job that monitors things, and have that job run every minute or something;

    if it's critera is matched, , and the tace is not already started,...

    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!

    June 1, 2015 at 8:22 am

    #1802005

  • RE: updating ReportServer.dbo.Catalog directly: too smart for my own good?

    this is what i THINK i found out. If the report has a subscription, the rdl is cached in another table, and its bibary, no way to tweak it. 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!

    May 30, 2015 at 3:32 am

    #1801797

  • RE: Sql Custom Script to run in the job

    ok, the better question is why do you feel you need to modify the code to exclude the procedure?

    Ola's scripts are tried and true, peer reviewed and used in big...

    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!

    May 21, 2015 at 11:20 am

    #1799778

  • RE: Self Contracting Licensing, Insurance, Questions

    i found a good rule of thumb example here, comparing w2 vs 1099:

    http://www.city-data.com/forum/work-employment/1535070-how-compare-w2-wages-versus-1099-a.html

    Basic Calculator for converting W2 to 1099 rates

    W2: $30.00/hr

    1099: $32.25/hr min

    1099: $45.00/hr max

    W2: $35.00/hr

    1099: $37.63/hr min

    1099:...

    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!

    May 21, 2015 at 11:03 am

    #1799775

  • RE: Self Contracting Licensing, Insurance, Questions

    i did a gig self contracting with a previous employer before, and they gave me a 1099 when it was done.

    don't let them rope you into "we'll pay 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!

    May 21, 2015 at 10:55 am

    #1799772

  • RE: Storytime:- Cursor.... in an update trigger... that inserts into another table... with an insert trigger... with a cursor... that updates the first table.

    Matthew Darwin (5/21/2015)

    ... so we don't get caught in a trigger loop of doom.....

    So, what sort of horror gems have you found recently?

    Matthew

    Matthew that's awesome, thanks for the chuckle, 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!

    May 21, 2015 at 8:44 am

    #1799711

  • RE: Sql Custom Script to run in the job

    well, exec sp_depends IndexOptimize shows it as a dependancy, and if you review the code itself, the code blocks realted to 'INDEX_REORGANIZE' and 'UPDATE_STATISTICS' (~ lines 1180 or so)c learly...

    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!

    May 21, 2015 at 7:06 am

    #1799650

  • RE: Balance Sheet Query showing wrong amounts on VAT accounts only

    well, you might need to pull in some of the business guys.

    obviously they already told you "all the numbers except VAT are good"

    so VAT is supposed to be handled differently,...

    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!

    May 21, 2015 at 7:00 am

    #1799645

  • RE: Sql query to convert varbinary to datetime

    well, i can't tell what was supposed to be stored in the varbinary to obfuscate the date.

    i assumed maybe i could convert it to int, and then do 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!

    May 21, 2015 at 6:16 am

    #1799623

  • RE: Balance Sheet Query showing wrong amounts on VAT accounts only

    Raimon it looks like the issue has got to be in the data.

    there's nothing in the query itself that seems to show that VAT Input refundable account 123600 and VAT...

    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!

    May 21, 2015 at 5:37 am

    #1799611

Viewing 15 posts - 1,726 through 1,740 (of 13,460 total)