Jeff Moden

Forum Replies Created

Viewing 15 posts - 21,256 through 21,270 (of 59,098 total)

RE: The Right and Wrong of T-SQL DML TRIGGERs (SQL Spackle)

alen teplitsky (3/17/2015)
do people really write code where they insert data like that with the status and the code not part of the insert operation and you have to update...
--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)

March 17, 2015 at 4:23 pm

#1784625
RE: Report Builder 3.0 Expression to extract 2 parts of a string

mschaper (3/17/2015)
I'm developing a report in Report Builder 3.0. [font="Arial Black"] One of the fields returns one of the following notes[/font]:
Audit Status changed from STOP to RELEASED.
Audit Status...
--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)

March 17, 2015 at 11:27 am

#1784562
RE: Splitting a single column into multiple columns

sqlquery29 (3/17/2015)
Thanks andy...
We have like after 40 characters the unit of measure is place in the description field. We have more than one space between the description and unit of...
--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)

March 17, 2015 at 11:21 am

#1784559
RE: Snapshot of data, compare previous day

SQL_Kills (3/16/2015)
Hi,
I have the following table
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Transactions](
[ID] [char](5) NOT NULL,
[Amount] [float] NULL,
[InjectedDate] [datetime] NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
insert into Transactions values ('A0001',50,'2015-03-01 23:19:01.727')
insert...
--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)

March 17, 2015 at 11:18 am

#1784558
RE: Missing green arrow on the sql server icon in object explore

I did the same thing. Two accounts, I mean. Thanks for the feedback on that.
--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)

March 17, 2015 at 11:13 am

#1784556
RE: Query to show Database Objects last change

dwilliscp (3/17/2015)
If I skip those objects that were deleted, is there a query that I can run off Master/MSDB that will show all database objects and when they were last...
--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)

March 17, 2015 at 11:04 am

#1784552
RE: Missing green arrow on the sql server icon in object explore

You bet, Adam. Thank you for the feedback. Sorry I've missed this post over the last 3 years.
--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)

March 17, 2015 at 9:21 am

#1784532
RE: Bulk Insert (How do I find my rowterminator?)

Resolving this issue is actually pretty easy but I need some data to work with. Any chance of you attaching a file that I can test with after work...
--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)

March 17, 2015 at 8:01 am

#1784501
RE: Missing green arrow on the sql server icon in object explore

I haven't read through the 8 pages of responses on this thread but the most recent question seems to indicate there might still be a "problem" understanding why this all...
--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)

March 17, 2015 at 7:00 am

#1784479
RE: Extract Value from XML Column

maruthasalam (3/16/2015)
I have modified the SQL query and the below SQL query done what i need exactly.
Except run fast/efficiently. The code that Dwain posted will do fine without 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)

March 16, 2015 at 7:13 pm

#1784397
RE: Leading zeroes substring query in SQL Server

SQListic (3/16/2015)
Thank u so much
I also did it with RIGHT FUNCTION
SELECT substring(RIGHT('00000000' + CAST([END DATE] AS VARCHAR), 8),5,4)+substring(RIGHT('00000000' + CAST([END DATE] AS VARCHAR), 8),1,2)+
substring(RIGHT('00000000' + CAST([END DATE] AS VARCHAR), 8),3,2)...
--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)

March 16, 2015 at 7:06 pm

#1784396
RE: Using powershell in tsql scripts

I believe you've been bitten by the dynamic SQL. To prove what I'm thinking the problem is, change all of your path, filename, and other variables that have anything...
--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)

March 16, 2015 at 4:59 pm

#1784375
RE: Trigger for updates on a row using previous record value?

CELKO (3/16/2015)
Do you know of any SQL engine that has a function that will convert that ISO format directly to a "week start date"?
DB2, Ingres, Postgres and...
--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)

March 16, 2015 at 4:50 pm

#1784373
RE: Trigger for updates on a row using previous record value?

CELKO (3/15/2015)
It is not denormalized; it is another temporal scale exactly like the Common Era Calendar is a scale. This is like saying a measurement in meters instead of...
--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)

March 16, 2015 at 7:53 am

#1784254
RE: Using powershell in tsql scripts

kevaburg (3/16/2015)
roger.price-1150775 (3/16/2015)
Not seen SQL call Powershell but seen lots of powershell scripts calling SQL.
Why are you renaming the files ?
If it's to ensure a file is only processed once...
--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)

March 16, 2015 at 7:45 am

#1784249

Viewing 15 posts - 21,256 through 21,270 (of 59,098 total)