Jeff Moden

Forum Replies Created

Viewing 15 posts - 24,001 through 24,015 (of 59,102 total)

RE: How do you add a constraint for a VARCHAR(10) column to checks the Date format as yyyy/mm/dd

Sean Lange (4/2/2014)
vanessa4biz (4/2/2014)
I have tried:
ALTER TABLE dbo.tablename
ADD CONSTRAINT DF_Date_format
check (SDate LIKE '%[1-2][0-9][0-9][0-9]/[0-1][0-9]/[0-3][0-9]%')
******But this does not work for VARCHAR data type...
--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)

April 2, 2014 at 3:56 pm

#1702653
RE: A Questionable Trigger

Hugo Kornelis (4/2/2014)
The UPDATE ... FROM used in the trigger is a highly dangerous construction that, if I had my way, would have been deprecated a long time ago already.
I'm...
--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)

April 2, 2014 at 3:16 pm

#1702648
RE: A Questionable Trigger

Carlo Romagnano (4/2/2014)
In sqlserver 2008 r2 the update doesn't return any resultset and no error message.
(2 row(s) affected)
(2 row(s) affected)
What I'm missing?
Same here.
--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)

April 2, 2014 at 3:12 pm

#1702646
RE: Get the hierarchy orders(top to bottom) of the table

yuvipoy (4/2/2014)
Just want the parent table name ,key name, child table name ,child key in the order
parent name,key name, child name ,child key
p1 k1 p2 k2
p2 k2 p3...
--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)

April 2, 2014 at 2:55 pm

#1702640
RE: Ideal table for Memory Optimization ?

Koen Verbeeck (4/2/2014)
GilaMonster (4/1/2014)
In-memory OLTP (hekaton) is for heavy concurrent load (tens of thousands of concurrent connections with thousands of inserts/sec). The advantage is the lock-less, latch-less optimistic concurrency. It's...
--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)

April 2, 2014 at 2:48 pm

#1702638
RE: Automate Sliding Window Partition Maintenance: Part III

Thanks, Hugh. I appreciate the feedback.
--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)

April 2, 2014 at 2:38 pm

#1702635
RE: Stairway to Advanced T-SQL Level 5: Storing Data in Temporary Tables

dataman777 (3/19/2014)
What is the difference and implications of utilizing #TempTableName and @TempTableName ?
See the following:
http://www.sqlservercentral.com/articles/Temporary+Tables/66720/
--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)

April 2, 2014 at 2:04 pm

#1702624
RE: Flexible Recursive Level Splitting - One column per level

I see that no one has jumped in on this even though you've provided readily consumable test data.
First, my response will act as a "bump" and, second, if no one...
--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)

April 2, 2014 at 12:39 pm

#1702598
RE: Help need in Avoiding Loop

born2achieve (4/2/2014)
Hi Jeff,
Yes you correct. i always start to write algorithm before i write logic.
Here is my algo,
1. Get the records from users_transaction table group by user id where 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)

April 2, 2014 at 7:37 am

#1702462
RE: SQL Server 2014 Developer Edition - availability for download ?

Heh... waiting for SP1. 😉
--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)

April 2, 2014 at 12:03 am

#1702325
RE: Get the hierarchy orders(top to bottom) of the table

Ok... so what's the structure of the tables for the emp->mgr relationship?
Shifting gears, because of all the tables you have involved, you really need to read 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)

April 1, 2014 at 11:51 pm

#1702324
RE: SQL Transpose / Pivot - Help

AarionSSQL (4/1/2014)
PS: The attachment has a screenshot of the tables described below which is easier to read
Hi All,
I am stuck on finding a solution to transpose source data from 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)

April 1, 2014 at 11:41 pm

#1702323
RE: Automate Sliding Window Partition Maintenance: Part III

I wouldn't have used PoSH for any of this but this is a nice series you've put together. Thanks for taking the time.
Shifting gears a bit, the title 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)

April 1, 2014 at 11:23 pm

#1702321
RE: Are the posted questions getting worse?

TomThomson (4/1/2014)
GilaMonster (4/1/2014)
I haven't. Had a online friend years ago (when newsgroups were still a thing) who acted like Haskell was the second coming. Put me off a bit.
F# 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)

April 1, 2014 at 11:09 pm

#1702320
RE: sp_send_dbmail has formatting off on datetime when directing output to csv file

Does it have to be an attached file or can it just be a nicely formatted email message that someone could copy and paste into Excel?
--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)

April 1, 2014 at 10:58 pm

#1702318

Viewing 15 posts - 24,001 through 24,015 (of 59,102 total)