Jeff Moden

Forum Replies Created

Viewing 15 posts - 34,951 through 34,965 (of 59,099 total)

RE: date for 15th Feb 12.00 a.m

Pink123 (2/23/2011)
Hi,
How would represent date for 15th feb 2011 12 a.m in the same format as getdate() does?
will it be something like this in sql server 2005
'2011-02-15 00:00:00.000'
Please help
Thanks,
The following...
--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)

February 23, 2011 at 4:20 pm

#1290679
RE: Help needed to decode comma delimited string and insert into tables

Ok... thanks. I'll be back.
--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)

February 23, 2011 at 3:38 pm

#1290670
RE: Help needed to decode comma delimited string and insert into tables

JJH82 (2/22/2011)
hi kumar20, the script cannot process some name characters, e.g. '&', '<'
',2 Column_Names "FIELD_NAME" "READ_FLG" ,2 Old_Column_Values "Rural & Remote" "N" ,2 New_Column_Values "" ""'
'+2 Column_Names "ATTRIB_VALUE" "SCORE" +2...
--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)

February 23, 2011 at 6:46 am

#1290351
RE: Help needed to decode comma delimited string and insert into tables

JJH82 (2/21/2011)
yes, it does
, 8 Field_Name "1" "2" "3" "4" "5" "6" "7" "8"
thank you in advance
Ok... thanks... I'll try to take a stab at this tonight.
--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)

February 22, 2011 at 7:10 am

#1289842
RE: How to summarise, listing on same line

timotech (2/21/2011)
Hi Guys, I got it, this is the code i used, works ok
Very cool. Congrats and thanks for posting your final solution! 🙂
--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)

February 21, 2011 at 4:58 pm

#1289655
RE: Help needed to decode comma delimited string and insert into tables

Just a quick question, JJH82... does the number right after each coma identify how many elements there are for a given section?
--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)

February 21, 2011 at 4:31 pm

#1289650
RE: Help needed to decode comma delimited string and insert into tables

JJH82 (2/21/2011)
I appologise for the troubles I caused.
Here is a detailed structure of the source data:
1. the length of each row of string is not fixed
2. the data contained 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)

February 21, 2011 at 4:24 pm

#1289649
RE: drop temp table in dynamic SQL

deeby (2/20/2011)
I'm importing excel data into SQL using SQLOLEDB, building up and then executing a command string with multiple OPENROWSET instructions.
I want to use a temporary table within the command...
--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)

February 21, 2011 at 4:01 pm

#1289646
RE: drop temp table in dynamic SQL

Craig Farrell (2/21/2011)
Deeby, can you post your actual code? It may have to do with your methodology.
If I'm right, you're getting something like the results of this:
SELECT 'abc' 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)

February 21, 2011 at 4:00 pm

#1289644
RE: Pivot Query with 2 aggregated functions combined?

Darundo (2/21/2011)
Before anyone asks, I did use search before deciding to post this but I didn't find anything to solve what I was looking for.
I have data that I want...
--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)

February 21, 2011 at 3:34 pm

#1289638
RE: Getting Up To Speed on SQL Server Denali

Most of the companies that I've worked for stay behind the bleeding edge by at least a service pack or two. Some stay close to a full version behind...
--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)

February 21, 2011 at 3:28 pm

#1289637
RE: Number of rows processed by a cursor

If it's in a separate "batch", you can probably get a fairly good idea of the rowcount using SQL Profiler. It won't be as perfect as putting a counter...
--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)

February 21, 2011 at 3:23 pm

#1289634
RE: Are the posted questions getting worse?

jcrawf02 (2/21/2011)
Jeff Moden (2/21/2011)
jcrawf02 (2/21/2011)
Jeff Moden (2/21/2011)
WayneS (2/20/2011)
For those going to SQL Saturday #69 in Philly, I'll be presenting @ 2:15. I'm getting pretty excited about this!
Click here for 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)

February 21, 2011 at 3:20 pm

#1289632
RE: Varchar and the data dictionary

nico van niekerk (2/20/2011)
I agree, but I don't think that there is more data to move. If a varchar(255) contains only 10 characters, say, it will only be 10+2 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)

February 21, 2011 at 3:08 pm

#1289630
RE: How to tune/speed up a procedure

gregory.anderson (2/18/2011)
Been searching on how to concatenate rows into a single field and I found a link to a recursive CTE for unknown number of rows to concatenate,...
A recursive...
--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)

February 21, 2011 at 3:02 pm

#1289629

Viewing 15 posts - 34,951 through 34,965 (of 59,099 total)