Jeff Moden

Forum Replies Created

Viewing 15 posts - 20,371 through 20,385 (of 59,098 total)

RE: DEBIT AND CREDITS

cbrammer1219 (6/14/2015)
Here is the table structure and attached is the data.
USE [dsg]
GO
/****** Object: Table [dbo].[DICE_APDH] Script Date: 6/14/2015 3:44:42 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

June 14, 2015 at 2:57 pm

#1805365
RE: Hierarchical Tree Reading in SQL Server

You might also have a problem with you Primary Key. In most "Adjacency List" hierarchies, the child (your AccountID) should be the single column PK as well as the...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

June 14, 2015 at 1:39 pm

#1805359
RE: Hierarchical Tree Reading in SQL Server

a4apple (6/8/2015)
Hello All,
Currently we have a Hierarchial Tree table that saves our account level information as follows.
sample DDL
CREATE TABLE TreeTable
(
AccountID INT,
SponsorID INT,
[Level] INT,
[Tree] VARBINARY(4000),
CONSTRAINT PK_TreeTable PRIMARY KEY (AccountID, SponsorID, Level)
)
sample...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

June 14, 2015 at 1:29 pm

#1805358
RE: Agent XPs automagically being disabled

rnolan 96369 (6/12/2015)
I had a similar problem with a slightly different cause, so I thought I would throw this out in case any one else gets burned like I did....
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

June 13, 2015 at 4:12 pm

#1805326
RE: DEBIT AND CREDITS

cbrammer1219 (6/13/2015)
Hi I am trying to pull only open AP invoices, so when a invoice has been credited I don't want to pull that amount.
923037 ...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

June 13, 2015 at 4:05 pm

#1805325
RE: An RDP Session issue

Alan.B (6/12/2015)
It's a bad idea to use RDP to manage a DB server.
If you're going to say something like that, you need to explain why. To...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

June 13, 2015 at 4:00 pm

#1805324
RE: Accidentally set max server memory to 0

That's excellent news. Thanks for posting it.
Still, I think I'll be a whole lot more careful in the future. Even if you can recover, it's a pain in...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

June 12, 2015 at 8:09 pm

#1805287
RE: SQL 2008 Converting Row values to columns with dynamic columns

DiabloZA (6/12/2015)
Hi Eirikur Eiriksson,
You are the man 🙂
I really appreciate your help for the second time 🙂
Can you please guide me to an article or a site where I can...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

June 12, 2015 at 5:26 pm

#1805281
RE: Run DTEXEC from Powershell - convert from batch file

dcwilson2009 (6/12/2015)
I tried converting it for Powershell ...
If the batch file was working, then I have to ask... WHY?
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

June 12, 2015 at 5:09 pm

#1805278
RE: db_datareader

Eric M Russell (6/12/2015)
Jeff Moden (6/12/2015)
charipg (6/12/2015)
user have db_datareader role in in a database.
But user is not able to see the storedprocedures.
any suggestion pls.
I have a different suggestion than the...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

June 12, 2015 at 5:07 pm

#1805277
RE: SQL 2016 R Syntax?

And still.... even after all of that, nothing to handle true CSV with text qualifiers that work for the way that Excel exports CSV or even TSV. What a...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

June 12, 2015 at 5:04 pm

#1805276
RE: TVF is slower when running as paramerized

phosplait (6/12/2015)
@jeff, there is no begin in the function. It is an inline function that does a cross apply with another inline function onto a range of dates
Just had to...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

June 12, 2015 at 4:49 pm

#1805275
RE: Which certificate will help me earn a job in IT?

hanialbarni (2/9/2015)
I don't think they can help me in getting a job. all the jobs I apply for they all need at least 1 year experience or more which I...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

June 12, 2015 at 2:56 pm

#1805260
RE: db_datareader

charipg (6/12/2015)
user have db_datareader role in in a database.
But user is not able to see the storedprocedures.
any suggestion pls.
I have a different suggestion than the others... why is it necessary...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

June 12, 2015 at 2:41 pm

#1805249
RE: TVF is slower when running as paramerized

phosplait (6/12/2015)
I am trying to run an inline TVF as a parameterized SQL query.
Just to be sure, does the function code contain the word BEGIN anywhere in it?
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

June 12, 2015 at 2:37 pm

#1805247

Viewing 15 posts - 20,371 through 20,385 (of 59,098 total)