Jeff Moden

Forum Replies Created

Viewing 15 posts - 13,426 through 13,440 (of 59,095 total)

RE: PRIME NUMBERS

TheCTEGuy - Tuesday, December 12, 2017 6:13 AM
USE test;
GO
/*Tally table is the table with single column having no.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)

December 13, 2017 at 5:47 am

#1971930
RE: PRIME NUMBERS

unas_sasing - Tuesday, December 12, 2017 7:54 PM
Hai all,
thank you for helping me,
Yes I would like to reverse from a result set 2,3,5,7,11,13,17,19,23,29,...
--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)

December 13, 2017 at 5:27 am

#1971927
RE: Quick and Dirty DR Solution Using Robocopy

barettojames99 - Tuesday, December 12, 2017 9:50 AM
There are too many things to take into consideration while working with robocopy and 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)

December 12, 2017 at 5:23 pm

#1971871
RE: Find and count Incomplete records in a table

eyejay - Tuesday, December 12, 2017 10:41 AM
Hi Jeff,
Many thanks for "shifting gears". Your tweaking of Steve's original solution is very useful....
--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)

December 12, 2017 at 5:20 pm

#1971868
RE: Tempdb

giri10488 - Tuesday, December 12, 2017 4:20 PM
But it happens with me i have done on so many servers & resolve 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)

December 12, 2017 at 5:14 pm

#1971867
RE: PRIME NUMBERS

unas_sasing - Tuesday, December 12, 2017 4:32 AM
Dear all,
I have SP :

CREATE proc [dbo].[usp_FindPrimes] (@opt tinyint, @ResultCount int)
as
set ROWCOUNT ...
--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)

December 12, 2017 at 3:56 pm

#1971858
RE: How to Automate the closing of a window?

sqlnoob2015 - Monday, December 11, 2017 12:36 PM
What is the best way to automate the clearing out of an error message 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)

December 12, 2017 at 3:00 pm

#1971845
RE: Advice for Newcomers

Alan.B - Tuesday, December 12, 2017 1:51 PM
Do what you love and the money will come; nobody is awesome at stuff they...
--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)

December 12, 2017 at 2:44 pm

#1971841
RE: Advice for Newcomers

drew.allen - Tuesday, December 12, 2017 12:44 PM
Jeff Moden - Tuesday, December 12, 2017 12:41 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)

December 12, 2017 at 1:46 pm

#1971837
RE: Advice for Newcomers

1. Learn enough about the problem you're trying to solve to actually be able to ask a question about it.
2.. You're not "entitled". Eventually, you have to learn 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)

December 12, 2017 at 12:41 pm

#1971824
RE: Bulk insert into table from csv

jaryszek - Tuesday, December 12, 2017 8:23 AM
Columns in CSV were in different order then columns in my SQL tables...
Jacek
I've had 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)

December 12, 2017 at 12:39 pm

#1971822
RE: Tempdb

giri10488 - Tuesday, December 12, 2017 12:00 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)

December 12, 2017 at 7:54 am

#1971744
RE: Bulk insert into table from csv

jaryszek - Tuesday, December 12, 2017 12:05 AM
hi Guys,
thank you for helping me!
Problem was very simple! From QlikView imported data was 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)

December 12, 2017 at 7:46 am

#1971741
RE: Find and count Incomplete records in a table

Steve Jones - SSC Editor - Tuesday, December 12, 2017 2:09 AM
Nice enhancement, Jeff. I knew someone might come up with 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)

December 12, 2017 at 7:43 am

#1971739

Viewing 15 posts - 13,426 through 13,440 (of 59,095 total)