Jeff Moden

Forum Replies Created

Viewing 15 posts - 21,226 through 21,240 (of 59,072 total)

RE: Employeee Benefits Database

Gosh, this seems like homework. You should at least try to answer the questions and explain why . If you're wrong, then people will help.
--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:53 pm

#1784653
RE: My recent post is not showing up

DaPainKiller (3/17/2015)
I have 'Added Topic' and it's name is shown under recent subscriptions in my subscriptions list but it never appears on the forum page. Please help
You might want 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)

March 17, 2015 at 6:49 pm

#1784637
RE: Time difference with dates in same column

thomashohner (3/17/2015)
Wow that was fast!
And its faster than my attempt at creating a temp table to build a start and stop time column.
Amazing 242,139 rows in under 30 seconds
How...
--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 5:59 pm

#1784636
RE: Add 15 minutes to a time in char format

CELKO (3/17/2015)
Gosh NO! You're missing an entire 10th of a second and if someone uses the table for a different resolution that you built the table for, they're 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)

March 17, 2015 at 5:17 pm

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

Viewing 15 posts - 21,226 through 21,240 (of 59,072 total)