Jeff Moden

Forum Replies Created

Viewing 15 posts - 16,651 through 16,665 (of 59,067 total)

RE: sql query to display a trailer record at the end in txt file (using batch file)

patilpallavi16 (10/10/2016)
USE [St]
GO
/****** Object: StoredProcedure [dbo].[P_tnvin] Script Date: 10/10/2016 13:35:45 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
create PROCEDURE [dbo].[P_tnvin]
AS
BEGIN
SET NOCOUNT ON;
Create Table TmpTNVINInfo
(
VINRecord...
--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)

October 11, 2016 at 11:23 pm

#1906023
RE: Prod vs Dev execution mystery

Yuri55 (10/11/2016)
Have a really strange case when same UPDATE statement (part of SP) runs on Prod sql server for few hours while on Dev one- under minute. Prod sql...
--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)

October 11, 2016 at 10:03 pm

#1906021
RE: Locking a table while being refreshed

BI_Dev (10/11/2016)
Hi,
Is it possible to block all users from querying a table while it's being refreshed (truncate/insert into) by a maintenance job? I'm not a DBA but would like...
--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)

October 11, 2016 at 9:55 pm

#1906020
RE: Create Job Server

Deny Christian (10/11/2016)
Hello Experts,
I'm New to this Forums,
Kindly need advice about
Integrity-->backup-->reorganize-->rebuild index-->clean up
I want to make job schedules based on these criteria.
whether to separate or can be made 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)

October 11, 2016 at 9:43 pm

#1906017
RE: SQL Export to CSV Problem

jay-125866 (10/11/2016)
I am using the following code to mail out a CSV file. When total number of characters in a row is more than 250(or so), the text was moved...
--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)

October 11, 2016 at 9:20 pm

#1906015
RE: How to force column explicitly to string type before we export to excel

Phil Parkin (10/6/2016)
Eric M Russell (10/6/2016)
Jeff Moden (10/5/2016)
komal145 (10/5/2016)
i have check other tables and do lot of stuff to get this point . So , i have to do it...
--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)

October 11, 2016 at 8:51 pm

#1906014
RE: Bingle is my Senior DBA

andrew gothard (10/11/2016)
pdanes (10/8/2016)
I don't know about for the net in general, but for this forum, maybe Steve could institute some sort of marking for people that know what 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)

October 11, 2016 at 9:02 am

#1905920
RE: How to Upgrade T-SQL Skills

Talib123 (9/27/2016)
Hi All,
I'm a production DBA and have been for a good while.
I can query, join filters but how do I get my T-sql skills to a developer\Report writer...
--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)

October 11, 2016 at 8:42 am

#1905913
RE: Are the posted questions getting worse?

Grant Fritchey (10/10/2016)
This was an... interesting? ... read. Weird location. I've never heard of this person. I think this is their only SQL writing. It's just odd.
No need to pile...
--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)

October 10, 2016 at 8:32 pm

#1905805
RE: Are the posted questions getting worse?

drew.allen (10/10/2016)
Brandie Tarvin (10/10/2016)
Grant Fritchey (10/10/2016)
This was an... interesting? ... read. Weird location. I've never heard of this person. I think this is their only SQL writing. It's just odd.
No...
--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)

October 10, 2016 at 8:26 pm

#1905804
RE: How to divide money between two participants

mcfarlandparkway (10/10/2016)
I have two tables one is temporary and another is main dbo employee
In the main table I have added a column called fullamount. Basically this fullamount column is coming...
--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)

October 10, 2016 at 3:52 pm

#1905792
RE: Are the posted questions getting worse?

Eirikur Eiriksson (10/9/2016)
Who deleted the thread on stuffing overlapping intervals?
😎
Looks like the automatic spam hider had a ball there. I can still see it but it is marked as...
--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)

October 10, 2016 at 9:40 am

#1905693
RE: Are the posted questions getting worse?

Eirikur Eiriksson (10/8/2016)
Ouch ...biting the tongue....
😎
We all know the reason for the given answer... she simply doesn't know any better method even after she's been shown how to avoid loops...
--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)

October 8, 2016 at 2:48 pm

#1905537
RE: t-sql 2012 cursor

wendy elizabeth (10/8/2016)
I used this loop since I was trying to determine how to solve my problem.
Understood and appreciated. The question now, though, is... do you understand how 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)

October 8, 2016 at 2:36 pm

#1905536
RE: Bingle is my Senior DBA

kenambrose (10/8/2016)
Answer the newbie/basic questions with links? then all you need is a standard suite of links you can reuse over and over again. And the poster will...
--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)

October 8, 2016 at 2:20 pm

#1905535

Viewing 15 posts - 16,651 through 16,665 (of 59,067 total)