Jeff Moden

Forum Replies Created

Viewing 15 posts - 20,341 through 20,355 (of 59,072 total)

RE: Dynamic Conversion of PIVOT COLUMNS

ramrajan (6/15/2015)
I have attached SQL File which Gives me the below resultset Excel.xlsx
But the problem is i am not able to round off the dynamic columns in side my PIVOT...
--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 15, 2015 at 6:13 am

#1805425
RE: SQL Database Administration

Ed Wagner (6/15/2015)
I would start with this:
1. When are the backups taken?
2. Where are the backups stored?
3. Are the backups viable? Can they be used to restore? Have...
--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 15, 2015 at 6:09 am

#1805424
RE: Moving large databases from SQL Server 2005 to 2008

Does anyone have any info on whether or not it's possible to mirror a 2005 server to a 2008 server? I was pretty sure that they had to be...
--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 9:20 pm

#1805385
RE: log file does not match primary file

The safest thing to do for the future would be nightly full backups and log file backups every 15 minutes. That way, you'd never lose more than 15 minutes...
--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 9:12 pm

#1805384
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

Viewing 15 posts - 20,341 through 20,355 (of 59,072 total)