Jeff Moden

Forum Replies Created

Viewing 15 posts - 12,646 through 12,660 (of 59,095 total)

RE: How would you parse 000.024.000 into 24H?

NineIron - Wednesday, March 28, 2018 6:22 AM
My table holds values like 000.004.000, 000.02.000, 000.024.000. What is the best/easiest way to get...
--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 28, 2018 at 7:34 am

#1984787
RE: What next????

RonKyle - Tuesday, March 27, 2018 8:03 AM
Predictive analytics isn't BI 🙂 (not by most definitions of the term)
Apparently...
--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 27, 2018 at 9:09 am

#1984661
RE: With Execute As Not Working As Expected

Sue_H - Monday, March 26, 2018 12:03 PM
Try specifying a login - something like:
Alter Procedure [dbo].[RemoteLink]
@LinkedServerName Varchar(50)
AS
--With...
--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 26, 2018 at 7:36 pm

#1984608
RE: With Execute As Not Working As Expected

Dave Thomas - Monday, March 26, 2018 8:35 AM
Can anyone tell me why this is not working (I obfuscated the password, BTW). ...
--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 26, 2018 at 3:40 pm

#1984605
RE: What next????

GilaMonster - Monday, March 26, 2018 9:35 AM
xsevensinzx - Monday, March 26, 2018 6:32 AM
--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 26, 2018 at 3:22 pm

#1984604
RE: Use uniqueidentifier field in place of int

patrickmcginnis59 10839 - Monday, March 26, 2018 9:08 AM
unique identifier is not a numeric that can be fit into an int. even...
--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 26, 2018 at 3:19 pm

#1984603
RE: What next????

super48 - Monday, March 26, 2018 3:44 AM
I have total 5 year exp In Sql, ssrs, ssis, ssas(3 year).
I was thinking what...
--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 26, 2018 at 7:39 am

#1984532
RE: TEMPDB files

Perry Whittle - Monday, March 26, 2018 6:04 AM
GilaMonster - Friday, March 23, 2018 2:24 PM
--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 26, 2018 at 7:33 am

#1984530
RE: Abstract: Tech Writing for Techies

Ray K - Thursday, February 4, 2016 9:12 AM
Jeff Moden (1/28/2016)
I've found that many technologists that are in the business of writing...
--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 25, 2018 at 4:57 pm

#1984509
RE: Loading intermediate table

hoseam - Friday, March 23, 2018 6:10 AM
Hi,
I have these tables and data:
CREATE TABLE [Table1](
[PartnerSiteID] [int] IDENTITY(1,1) NOT NULL PK,
[PartnerID]...
--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 24, 2018 at 5:07 pm

#1984493
RE: Collation Question

r5d4 - Thursday, March 22, 2018 9:14 AM
Hiya,
I have a sql 2012 server set up with collation Latin1_General_CI_AS (default).
A vendor is performing an...
--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 24, 2018 at 5:03 pm

#1984492
RE: Use uniqueidentifier field in place of int

daniness - Friday, March 23, 2018 12:28 PM
Hi All,
I'm trying to populate a temp table. Here is the temp table:
[code...
--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 24, 2018 at 4:22 pm

#1984490
RE: Somebody Help! - T-SQL syntax help.

mw_sql_developer - Friday, March 23, 2018 3:03 PM
Jeff Moden - Friday, March 23, 2018 2:27 PM
--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 24, 2018 at 2:38 pm

#1984489
RE: Somebody Help! - T-SQL syntax help.

mw_sql_developer - Friday, March 23, 2018 10:09 AM

Here is what I need. I have s start date and a end date.
What...
--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 23, 2018 at 2:27 pm

#1984466
RE: SELECT INTO doesn't update the tables recursively

rva.raghav - Thursday, March 22, 2018 8:11 PM
Hi sgmunson,
Thanks for the answer. Appreciate it. I would like to know how to write...
--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 22, 2018 at 9:45 pm

#1984375

Viewing 15 posts - 12,646 through 12,660 (of 59,095 total)