Forum Replies Created

Viewing 15 posts - 2,206 through 2,220 (of 13,460 total)

  • RE: How can I run this query for the current days business?

    assuming your Transactions table has a column named [TransactionDate], and that date represents the date you are looking for, this query will

    get all transactions from midnight until the second...

    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!

    September 22, 2014 at 8:55 am

    #1747121

  • RE: Data shows up in SQL Server but not in SSRS Report

    Visual Studio can create a cache file for reports , so it skips getting the data from the server during a report preview. if the data changed, or the cache...

    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!

    September 22, 2014 at 7:40 am

    #1747070

  • RE: Junk/SPAM Posts Overwhelming

    additionally, how about a scheduled job that looks for more than one post per second per user, and deletes the ones that were spammed based on that criteria?

    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!

    September 21, 2014 at 7:47 pm

    #1746930

  • RE: View changing but not able to capture who/what is doing it

    phingers (9/19/2014)

    unfortunately it could be someone who logs in under the same credentials as me.

    The db mail idea is good, although in the same way as disabling 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!

    September 19, 2014 at 5:06 am

    #1746671

  • RE: How to restore 1 or more SSRS Report From A Backup Of The ReportServer Database without Restoring the Entire ReportServer Database on SQL Server 2012

    i had to do something similar, where the Visual Studio Project was deleted on a developers machine. The RDL's and all the data sources etc are stored in 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!

    September 18, 2014 at 2:33 pm

    #1746545

  • RE: Generate Scripts Result in a order of tables and then stored procedures in SQL Server

    well i know how to get the order of dependencies : if you limit the results to just Tables, that is the order of foreign key hierarchys...but then 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!

    September 10, 2014 at 5:52 am

    #1744401

  • RE: SQL 2012 query via powershell

    my powershells cript has similarities, butis a little different on that like for .Fill;

    i don't have void or[void] anywhere.

    i'm also filling a dataset, and not a datatable.

    $SQLDataSet = New-Object System.Data.DataSet;

    $SqlDataAdapter.Fill($SQLDataSet,...

    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!

    September 9, 2014 at 11:30 am

    #1744205

  • RE: SQL 2012 query via powershell

    since it's a named instance, i think it might be a SQL express instance...which has TCP/IP disabled by default.

    do you know if it's an express instance?

    if it is, first 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!

    September 4, 2014 at 1:35 pm

    #1743333

  • RE: What the most significant condition to use SQL CLR?

    i use CLR extensively, and for a lot of different reasons.

    Here's a list of the things i use it for:

  • Exporting a query to disk: TXT/CSV/TSV/RTF/HTML/DOC/XLS/More format's than you care to...

    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!

September 4, 2014 at 12:35 pm

#1743308

  • RE: Invalid Object In SQL Server 2008 database

    that's a "feature" of procedures, with deferred name resolution.

    there's no way to turn it off, unfortunately, as it would be very valuable to be able to do that in some...

    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 28, 2014 at 5:44 am

    #1741602

  • RE: Does anyone have a good 'validate email' function?

    take a look at this thread, where we did some analysis a while back;

    i threw a SQL CLR function out, that seemed to do pretty well performance wise, that leverages...

    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 27, 2014 at 2:50 pm

    #1741502

  • RE: Expired SQL 2012 license. Moving on to 2014

    you can stop the SQL 2012 service and find the mdf and ldf files for the database(s) in question.

    copy them to the new server and use the Attach method:

    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 26, 2014 at 12:48 pm

    #1741119

  • RE: TSQL to create Excel 2013 file

    correct me if i'm wrong, but I thought noone can write to a file on the root of the C drive unless they are running elevated, admin priviledges:

    so C:\CambridgePubs.xlsx would...

    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 25, 2014 at 10:46 am

    #1740763

  • RE: InPlace Updates for Key columns

    i believe it's a design structure built into SQL, where in place updates are never truly performed.

    'The design makes sense, because it allows you to reference both old 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!

    August 22, 2014 at 1:39 pm

    #1740397

  • RE: Equivalent sql code for NORMSINV Excel Function

    i googled "tsql normsinv" and found quite a few; my second link pointed me, indirectly, to a script and forum post here on ssc for a couple of variations:

    http://www.sqlservercentral.com/scripts/Miscellaneous/31632/

    http://www.sqlservercentral.com/Forums/Topic158858-21-1.aspx#bm159154

    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 22, 2014 at 1:31 pm

    #1740395

    • Viewing 15 posts - 2,206 through 2,220 (of 13,460 total)