Jeff Moden

Forum Replies Created

Viewing 15 posts - 17,146 through 17,160 (of 59,101 total)

RE: Bulk insert with format file - handling quotation mark text qualifiers in header row

vinaypandey28 8266 (8/5/2016)
Hi Jeff,
I am facing difficulty when column row is not having any text qualifier but data rows have.
what would be the format file structure in this case.
--Data file...
--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)

August 5, 2016 at 10:51 am

#1894103
RE: Add New Column with RowID

Nusc (8/4/2016)
This is not an issue. This whole thing has been solved.
Two way street here, please. What is the solution you ended up 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)

August 4, 2016 at 6:48 pm

#1893966
RE: Count the occurrence of word in a Resume Table

shambhavi13 (8/3/2016)
I have a table called Resume with columns in Text, Word and PDF format. I enabled Full Text Search on the table and able to search the keyword through...
--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)

August 3, 2016 at 9:59 pm

#1893663
RE: How to get rid of implicit conversions ??

vsamantha35 (8/3/2016)
Thats Awesome Eirikur Eiriksson. Other thing, it came into my mind looking at the Execution Plan, I see sort and the Merge join is happening.
Is there an way,...
--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)

August 3, 2016 at 7:02 pm

#1893657
RE: How do we avoid junk in the VARCHAR fields ?

Luis Cazares (8/1/2016)
Maybe like this? Why do you have different validations for names and other values?
UPDATE [MEMBER].[IMP_MEMBER_INT]
SET
[ContactLastName] = CASE WHEN...
--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)

August 3, 2016 at 5:50 pm

#1893655
RE: Deadlock - due to Temp Tables?

Luminary1975 (8/3/2016)
The reason I'm asking is I appear to have the correct cumulative fix applied and I just got a deadlock on a temp. table... :crying:
Now THAT'S a horse 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)

August 3, 2016 at 5:01 pm

#1893653
RE: Deadlock - due to Temp Tables?

Luminary1975 (8/3/2016)
Hello;
Thanks for your reply, but I don't believe the cause in the article is clear.
This issue occurs because the two sessions that are used to execute the stored...
--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)

August 3, 2016 at 3:31 pm

#1893637
RE: Deadlock - due to Temp Tables?

Luminary1975 (8/3/2016)
Hello;
Can anyone explain this issue in any more detail? Is it just an issue with Lock Manager or is it an issue with tempDB.
I cannot believe that there 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)

August 3, 2016 at 8:46 am

#1893508
RE: Substring from RIGHT

Smendle (8/3/2016)
Jeff Moden (7/20/2016)
Smendle (7/20/2016)
Jeff Moden (3/4/2016)
John Mitchell-245523 (3/4/2016)
REVERSE the string, use SUBSTRING, and then REVERSE it again.
John
Got code?
Something like this?
With MyCTE(val)
AS
(
SELECT '9.0.0832.1032' UNION ALL --need to get the 32...
--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)

August 3, 2016 at 8:37 am

#1893501
RE: A twist on recursive query

michael.lock@aer.ca (8/2/2016)
Hello, and thank you to all of the respondents. I actually didn't think I was going to get anything, it had been a few days. I'm actually...
--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)

August 2, 2016 at 8:45 pm

#1893396
RE: A twist on recursive query

CELKO (8/1/2016)
Adam Mechanic had an improved technique. The only downside was that if the adjacency list had a cycle, it was bitch to find. The old stack algorithms could be...
--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)

August 2, 2016 at 8:43 pm

#1893395
RE: delete spamming Account please

Steve Jones - SSC Editor (8/2/2016)
Yes, and it's a fraction of the total posts each day. While it seems like a lot if you get the emails, it's not
It may...
--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)

August 2, 2016 at 8:24 pm

#1893394
RE: How to Run Scheduled Jobs in Azure SQL Databases

As a bit of a sidebar, I think that any system that allows for the use of a password "in the clear" is a really bad idea no matter 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)

August 1, 2016 at 5:49 pm

#1893095
RE: Datediff not recognised

Luis Cazares (8/1/2016)
Use the SSIS syntax.
DATEADD("dd", DATEDIFF("dd", (DT_DATE) "1900-01-01", GETDATE()) - 1, (DT_DATE) "1900-01-01")
Or, use a stored procedure to do the actual work and have SSIS call 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)

August 1, 2016 at 5:11 pm

#1893092
RE: login through machine name

tariq (8/1/2016)
Can user login to SQL Server using machine name instead of user login ID? I can create login with us\machinename$ but cannot get into SQL Server.
I seriously consider never...
--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)

August 1, 2016 at 5:10 pm

#1893091

Viewing 15 posts - 17,146 through 17,160 (of 59,101 total)