Jeff Moden

Forum Replies Created

Viewing 15 posts - 39,331 through 39,345 (of 59,098 total)

RE: Transposing repeating sets of rows into colums

wiernyjacek (3/15/2010)
These are fake names, so no private information is sent here. However I analysed the file again and it looks like the age is not always given, so 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)

March 15, 2010 at 2:23 pm

#1134062
RE: Facing Problem With Bulk Insert

karthik -450760 (3/15/2010)
Thanks for the reply Steve... The output file format vaires everytime. Please let me know if your code works for the below scenario that I face.. I have...
--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)

March 15, 2010 at 2:20 pm

#1134061
RE: Facing Problem With Bulk Insert

steve-893342 (3/15/2010)
Yes it should always work up to the first INSERT query viz
INSERT #ConnectivityTest
SELECT BulkColumn
FROM OPENROWSET (
BULK 'C:\ConnTest.txt',
FORMATFILE = 'C:\grasshopper2.fmt',
FIRSTROW = 1
) AS Z
--WHERE NOT BulkColumn...
--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)

March 15, 2010 at 2:16 pm

#1134060
RE: Facing Problem With Bulk Insert

steve-893342 (3/15/2010)
Jeff makes the point about BULK INSERT being quite restrictive because you have to match up the column list and you cannot manipulate the individual columns very easily. OPENROWSET...
--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)

March 15, 2010 at 7:14 am

#1133678
RE: Duplicating a record within a table

Paul White (3/14/2010)
Jeff Moden (3/14/2010)
Heh... user defined columns :sick:... that's the real problem. 😉
True. I worked with an application once that shared a schema across all customers...and any customer...
--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)

March 15, 2010 at 6:41 am

#1133656
RE: select all field except field wich have NULL value

Paul White (3/14/2010)
sinamora (3/14/2010)
thanks for all. it's very help me 🙂
Looks like Jeff isn't getting his answer.
Heh... Diodes, check valves, and one way streets are useful tools... just not on...
--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)

March 15, 2010 at 6:38 am

#1133652
RE: If I increase the Memory allocated, Will the query run faster.?

Joy Smith San (3/12/2010)
I've found that when I had to use linked servers, OPENQUERY provided much faster results.
It's amazing..! Open query is too fast...to be precise, it fetches data...
--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)

March 15, 2010 at 6:31 am

#1133643
RE: How to check if indexing is running?

Ajit-297150 (3/15/2010)
Ya it rebuild index. When we use the DBCC DBREINDEX 'tablename', it takes some time to rebuild it. And if in the mean time if a user queries 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)

March 15, 2010 at 6:27 am

#1133637
RE: please help me to develop this query

madhuri-425013 (3/15/2010)
Hi,
Thanks for your suggestions. I am posting the output of the results which needs to come.
my table contains below data
tbl1
-------
name dt
xxx 01-Apr-2010
xyz 02-May-2010
abc 01-Mar-2010
results should come like below
name dt
xxx...
--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)

March 15, 2010 at 6:14 am

#1133627
RE: Normalization

Kevin Butterworth (3/15/2010)
That way the location could be used to return the gender, allowing compliance with California style legislation as it spreads around the world.
Heh... Avoid needing to be compliant...
--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)

March 15, 2010 at 6:01 am

#1133611
RE: Stored Procedure Problem Help!

Heh... you must really be bored, Paul. 🙂 It does show, however, what a PITA a Cursor is compared to the simple Set-Based methods.
--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)

March 15, 2010 at 5:50 am

#1133606
RE: Is it possible...

Eoin (3/15/2010)
That's what's known in the business as a "Scream Test"
Heh... I didn't have a name for it but that'll do perfectly. 🙂
--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)

March 15, 2010 at 5:41 am

#1133601
RE: Calculating total working hours exclude launch, smoking...and etc times

You're welcome... the only thing that's left is doing a "SUM" by day and the midnight "split". The SUM can be done easily (sorry, don't know why I didn'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)

March 15, 2010 at 5:38 am

#1133600
RE: select random records but for each category

But not too complicated...
SELECT TOP (1)
...
--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)

March 14, 2010 at 10:58 pm

#1133519
RE: Stored Procedure Problem Help!

My feedback would be that you shouldn't learn how to use a Cursor until you've really learned and understand Set-Based progamming.
--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)

March 14, 2010 at 10:34 pm

#1133512

Viewing 15 posts - 39,331 through 39,345 (of 59,098 total)