Forum Replies Created

Viewing 15 posts - 1,291 through 1,305 (of 13,460 total)

  • RE: Looping Update Statement

    nice solution from Hugo, as always;

    for me, i really hate running totals stored in the table itself; plus it's breaking some of those rules for normalization, of course.

    eventually, 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!

    January 22, 2016 at 7:06 am

    #1853783

  • RE: SQL Join doesn't seem to be correct?

    i'm betting Sean Lange's suggestion that your left join converted to inner is your core problem:

    modify your join criteria like this, doe sthat solve the issue?

    SELECT

    ord.CustomerId,

    ...

    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!

    January 20, 2016 at 12:30 pm

    #1853261

  • RE: grant access to see and able to read, write to the databases created by one user to other

    User2 has to be created with the correct roles and permissions in the new database.; permissions in the old db would not make any difference;

    sounds like he has rights...

    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!

    January 20, 2016 at 12:15 pm

    #1853259

  • RE: what is the reason by rownum not performing on '=' & '>' operator.

    i think this is an Oracle question ffor the psuedo column rownum that is materialized in that RDBMS:

    https://docs.oracle.com/cd/B28359_01/server.111/b28286/pseudocolumns009.htm

    Conditions testing for ROWNUM values greater than a positive integer are always false....

    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!

    January 18, 2016 at 2:43 pm

    #1852616

  • RE: what is the reason by rownum not performing on '=' & '>' operator.

    tusharchpatil (1/18/2016)

    no i am not using simultaneouly its writing mistake

    i wanted to know why rownum not allowed = and > operator to get proper result.?

    it is absolutely allowed, and works...

    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!

    January 18, 2016 at 2:34 pm

    #1852613

  • RE: what is the reason by rownum not performing on '=' & '>' operator.

    rownum would have to be a real column name, right?

    if it is an alias for the row_number() functions's results, no results would occur if your table only had...

    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!

    January 18, 2016 at 1:20 pm

    #1852587

  • RE: Running a SQL SCript via SQL Alerts

    there is no alert for that specific condition(where a spid exists with value = -2.)

    so you cannot use Alerts, specifically.

    for specific events you can capture, you can have an event...

    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!

    January 16, 2016 at 5:38 am

    #1852362

  • RE: Finding info about a failed login

    it looks like you've got a process, maybe a sql job or windows scheduled task, that runs every five minutes?

    might also be an application or Service, installed on 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!

    January 15, 2016 at 10:27 am

    #1852296

  • RE: LEFT JOIN

    if your source has multiple lat/long for a postal code, you'd get the error;

    you need to limit to a single "missing" postal code

    WITH MySource

    AS

    (SELECT ROW_NUMBER() OVER (Partition By PostImp.ZipCode ORDER...

    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!

    January 14, 2016 at 2:52 pm

    #1852112

  • RE: Send email dynamically based on user

    yes, with a data driven subscription(if you have enterprise) ; more info is needed obviously, but if the report has a parameter for UserId or email to generate an...

    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!

    January 12, 2016 at 9:03 am

    #1851326

  • RE: Visual Studio stable version

    there are two specific, separate free downloads called SQL Server Data Tools(SSDT /SSDT-BI) that are related to SQL server 2014, so that you can do Data related projects 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!

    January 12, 2016 at 5:43 am

    #1851277

  • RE: SQL Azure Latest v12 update error Cannot bulk load. The bulk data stream was incorrectly specified as sorted or the data violate a uniqueness constraint imposed by the target table

    martin 48305 (12/4/2015)

    I am having the same problem with an even simpler UPDATE statement: UPDATE ... SET ... WHERE. Even though the fields that are updated already exists with 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!

    January 12, 2016 at 5:34 am

    #1851275

  • RE: Database Mail for Failed Jobs

    Michelle-138172 (1/11/2016)

    Thanks for the input.

    I checked the SQL Server Agent and the mail profile is enabled for the Alert System.

    There is no error message in the mail tables either.

    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!

    January 11, 2016 at 2:51 pm

    #1851155

  • RE: How to check whether email was sent to GMAIL account ?

    SQL server cannot connect to a POP3/IMAP a server to pull down the mail natively.

    you can do it in a programming language like c#/VB.net, which also means you can create...

    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!

    January 11, 2016 at 2:33 pm

    #1851144

  • RE: Database Mail for Failed Jobs

    you are sure they were REALLY sent, right?

    first check and make sure they were not receiving errors from the mailserver:

    SELECT top 100

    mail.send_request_date As SentDate,

    sent_status As Reason,

    err.[description],

    ...

    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!

    January 11, 2016 at 2:13 pm

    #1851135

Viewing 15 posts - 1,291 through 1,305 (of 13,460 total)