Jeff Moden

Forum Replies Created

Viewing 15 posts - 34,246 through 34,260 (of 59,099 total)

RE: Transform rows into columns in sql server 2005 ...

First, especially since you're relatively new to this forum, please study the article at the first link in my signature line below for how to post data in a readily...
--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 17, 2011 at 4:52 pm

#1312563
RE: Table level backup

JeffRush (4/17/2011)
I've most often seen this technique used prior to doing manual data manipulation on the source table so you have an easily accessible copy of the original data.
Also, using...
--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 17, 2011 at 3:17 pm

#1312556
RE: Need Urgent Help with Capacity Report Script

If you do backups on a regular basis (and you SHOULD), you can check the backup history tables in MSDB to get some data to determine growth over a fairly...
--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 17, 2011 at 2:47 pm

#1312551
RE: reading text datetime value with OPENROWSET and MICROSOFT.ACE.OLEDB12.0 changes datetime value

Adrian Heald (5/7/2010)
A little more information on this one.
If I use the MICROSOFT.JET.OLEDB.4.0 driver I get the same problems.
If I use ODBC, Driver={Microsoft Excel Driver (*.xls) it works fine.
Hi Adrian,
I...
--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 17, 2011 at 12:45 pm

#1312531
RE: Urgent-------Export all tables in a schema to multiple textfiles in a pipe delimited format

That'll work. Thanks for sharing.
--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 16, 2011 at 11:39 pm

#1312491
RE: hierarchyid traversing the tree.

If you take a look at the hierarchy ID column you posted, it's just numbers that represent the "layers" of the URL. Your problem is now how to put...
--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 16, 2011 at 10:20 pm

#1312489
RE: How it can be done..

amitsingh308 (4/8/2011)
the table definition is
create table tbtemp (temp varchar(50))
My table contains only one column and information store in this table as follow
Hii Every body
I retriving data from database 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 16, 2011 at 10:06 pm

#1312488
RE: How it can be done..

amitsingh308 (4/8/2011)
Thank you its working but I can not modify table defination
Sorry for the bad news but there's nothing you can do because there's nothing in the table to guarantee...
--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 16, 2011 at 10:04 pm

#1312487
RE: ISNUMERIC Question

Following OPC's and Lamprey's lead on this, please see the following article which explains a bit about ISNUMERIC...
http://www.sqlservercentral.com/articles/IsNumeric/71512/
--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 16, 2011 at 9:51 pm

#1312486
RE: Need Hiarachy of date

Ysaias Portes-QUI Group (4/8/2011)
Hi,
You can simply create a loop that can iterate through all the different dates.
You can find more documentation on MS website. http://msdn.microsoft.com/en-us/library/ms178642.aspx
Please let me know if 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)

April 16, 2011 at 9:46 pm

#1312485
RE: Need Hiarachy of date

latitiacasta (3/30/2011)
Hi All,
I need sql query for date hiarachy. for eg. when i pass @startdate and @enddate , @startday is my day1 then 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 16, 2011 at 9:42 pm

#1312484
RE: datetime => how to have complete date with 00:00:00.000

The only time BETWEEN works fine with dates is when you have whole dates with no times. Since BETWEEN is inclusive of both operands, you have to be real...
--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 16, 2011 at 9:27 pm

#1312482
RE: Find previous date in a series

stevet 20325 (4/11/2011)
Well maybe I misspoke. The cutoff date is in the table, on each record. But there is no distinct column for Previous cutoff date. You'd...
--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 16, 2011 at 9:17 pm

#1312481
RE: Generate records based on field value in DB table's records

adel.mutlak1 (4/8/2011)
Many thanks for your swift responses guys
I will have a go at both solutions and will let you know progress ind due course.
Hopefully it will be fine.
A
It's been more...
--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 16, 2011 at 9:12 pm

#1312479
RE: Urgent-------Export all tables in a schema to multiple textfiles in a pipe delimited format

santu4bth (4/13/2011)
Friends,
Please help me!
I have 3 schemas in a database and each schema has about 300 tables.Business is asking to export all (900 tables) to text files ie. each table...
--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 16, 2011 at 9:09 pm

#1312478

Viewing 15 posts - 34,246 through 34,260 (of 59,099 total)