Jeff Moden

Forum Replies Created

Viewing 15 posts - 17,686 through 17,700 (of 59,102 total)

RE: T-SQL query error while datetime conversion

sqlnaive (5/16/2016)
drew.allen (5/16/2016)
sqlnaive (5/16/2016)
I've one table with one specific integer column containing date as YYYYMMDD format and apart from date it also may contain value 99999999. I'm using this table...
--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)

May 16, 2016 at 9:50 am

#1879304
RE: Fiscal year concat not works in Sqlserver 2008

At this point, you might want to consider building a "Calendar Table". There are a lot of good articles out there on the subject that you can Google.
--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)

May 16, 2016 at 6:05 am

#1879207
RE: T-SQL query error while datetime conversion

As a test, have you tried to create a view consisting only of the BusinessDate column calculation and none of the other columns? That would be my first "Sherlock...
--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)

May 16, 2016 at 5:52 am

#1879205
RE: Scanning for a specific value in all the tables

rahulsahay123 (5/16/2016)
We have an OLAP system where we are assigning 0 value to any uniqueid column if the data is not following the business rule.
eg we have the following...
--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)

May 16, 2016 at 5:44 am

#1879202
RE: Splitting Strings in SQL Server 2016

@etheral1980,
Understood. But that's how it all starts and your example is exactly what I'm talking about. It seems totally harmless right now.
--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)

May 16, 2016 at 5:28 am

#1879193
RE: INT to DATE vs STRING to DATE

karthik M (5/13/2016)
All,
I have a thought on converting integer value (whereas date is stored in INT format) to Date. The same column is declared as char(8), so the convert...
--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)

May 15, 2016 at 2:38 pm

#1879154
RE: Splitting Strings in SQL Server 2016

etheral1980 (5/14/2016)
Good to know there would be built in function to split string now. And i have various ways to use them.
But right now i use function which can 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)

May 15, 2016 at 12:52 pm

#1879147
RE: Create Dev VM by Cloning Production VM

Hold the phone a minute. If the production database is under TDE, why on Earth would you copy it to a Developer's box? Sale of private/sensitive information doesn't...
--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)

May 15, 2016 at 10:34 am

#1879142
RE: Dynamic data masking feature

Steve Jones - SSC Editor (5/14/2016)
None, or negligible. This merely replaces the string being returned with some pattern.
That's what a lot of people surmised about the relatively new FORMAT function,...
--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)

May 15, 2016 at 10:27 am

#1879141
RE: t-sql 2012 date 1900-01-01

wendy elizabeth (5/14/2016)
In a t-sql 2012 statement where values are inserted into a table, the data is stored in the date column has a value 1900-01-01. I know this is...
--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)

May 15, 2016 at 9:52 am

#1879138
RE: Excel spreadsheet to SQL Server table

SQL!$@w$0ME (5/13/2016)
Hello guys,
I have a requirement to load data from excel spreadsheet to SQL server table and need to automate it. I believe this can be implemented with SSIS.
For this...
--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)

May 15, 2016 at 9:17 am

#1879136
RE: Tally OH! An Improved SQL 8K “CSV Splitter” Function

TomThomson (5/14/2016)
Jeff Moden (5/14/2016)
IMHO, no. It shouldn't return a NULL when the delimiter is NULL. It didn't find any NULLs as delimiters and, just like not finding 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)

May 15, 2016 at 8:45 am

#1879135
RE: Tally OH! An Improved SQL 8K “CSV Splitter” Function

Alan.B (5/13/2016)
Something I don't understand:
SELECT * FROM dbo.DelimitedSplit8K('xxx,d','');
Returns the whole string. This makes sense, the function found 0 occurrences of the delimiter.
SELECT * FROM dbo.DelimitedSplit8K(NULL,',');
Returns a NULL. This makes...
--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)

May 14, 2016 at 10:12 am

#1879098
RE: Are the posted questions getting worse?

Eirikur Eiriksson (5/13/2016)
Jeff Moden (5/13/2016)
jasona.work (5/13/2016)
So at the Detroit SQL PASS meeting last night, got to put faces to the names of those shining beacons of SQL knowledge and 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)

May 13, 2016 at 1:01 pm

#1879030
RE: Are the posted questions getting worse?

jasona.work (5/13/2016)
So at the Detroit SQL PASS meeting last night, got to put faces to the names of those shining beacons of SQL knowledge and all things pork chop launching,...
--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)

May 13, 2016 at 11:13 am

#1878981

Viewing 15 posts - 17,686 through 17,700 (of 59,102 total)