Jeff Moden

Forum Replies Created

Viewing 15 posts - 36,151 through 36,165 (of 59,102 total)

RE: Convert ASCII strings to the number value groups?

Never mind... can't wait for an answer. Here's 95% of the solution. All you have to do is figure out how you actually want to format the 0-255...
--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)

November 3, 2010 at 7:12 pm

#1246354
RE: Convert ASCII strings to the number value groups?

Here's the hard part... what do you want to display for the value aA¦
--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)

November 3, 2010 at 6:45 pm

#1246352
RE: Convert ASCII strings to the number value groups?

SQL Dummy-659258 (10/27/2010)
the ascii function stops at 127.
Actually, it doesn't. You just can't pass the ASCII function more than one character at a time.
--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)

November 3, 2010 at 6:13 pm

#1246343
RE: Just How Does SQL Server Define A Unique Index

JC-3113 (10/13/2010)
Hi luckus_g
it is not an issue to change it
i am in just testing creating tables and indexes and importing data right now
so i can start over after i make...
--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)

November 3, 2010 at 5:56 pm

#1246339
RE: Week Part

Marv-1058651 (11/2/2010)
Is there a way I can group a return set of data, by Month, and Week?
I am trying to get a result set that looks similar to...
--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)

November 3, 2010 at 5:51 pm

#1246338
RE: Please help me....Though this might sound silly

UPDATE xyz
SET @b-2 = ''
You're updating a variable there... not a column. You also have no criteria in the UPDATE so you'll be updating the whole table. Lookup...
--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)

November 3, 2010 at 4:14 pm

#1246324
RE: Need a Help in Importing CSV file into DB

Saravanan_tvr (11/3/2010)
Thanks Now working fine, But In CSV file format, if one field like Product
descriptions having Multiple Comma Inside, but our SQL splitting them in to multiple column,
but We...
--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)

November 3, 2010 at 4:03 pm

#1246321
RE: Most efficient parsing of Juniper syslogs in SQL?

If you don't want to or can't go third party or .Net, a Tally Table splitter could be the way to go here with some pretty high efficiencies. Any...
--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)

November 3, 2010 at 3:54 pm

#1246316
RE: Calculate number of moths between two days?

I believe everyone is missing the requirements a bit on this one. The op wants to know how many months are in each year of a multi-year range...
--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)

November 3, 2010 at 3:31 pm

#1246310
RE: drop the all tables

raistlinx (11/3/2010)
The OP asked for a way to easily clear out the tables.
Nope. Go back and look. The OP asked how to drop all the tables.
--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)

November 3, 2010 at 3:12 pm

#1246303
RE: Percentage value not appearing

akhlaq768 (11/3/2010)
Thanks, how do I CAST a column called [Student] so it will work?
Replace the "665" with the column name.
--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)

November 3, 2010 at 11:52 am

#1246198
RE: Are the posted questions getting worse?

GilaMonster (11/3/2010)
Jeff Moden (11/3/2010)
GilaMonster (11/3/2010)
....since I won't be at PASS?
Crap. You're one of the folks I wanted to meet.
Sorry, I thought you knew. It's not exactly been a secret.
You're...
--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)

November 3, 2010 at 7:47 am

#1245992
RE: Are the posted questions getting worse?

Roy Ernest (11/3/2010)
Just wanted to give an update. Things are much better now. It did not rain much. The sky is still totally covered with cloud. Still raining but not...
--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)

November 3, 2010 at 7:45 am

#1245991
RE: Are the posted questions getting worse?

Grant Fritchey (11/3/2010)
BrainDonor (11/3/2010)
I wouldn't say that. There's still a week of voting and the down votes make changes happen quick. Someone can vote up another guy and vote me...
--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)

November 3, 2010 at 7:20 am

#1245974
RE: Are the posted questions getting worse?

GilaMonster (11/3/2010)
....since I won't be at PASS?
Crap. You're one of the folks I wanted to meet. You're on my bucket list.
--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)

November 3, 2010 at 7:14 am

#1245968

Viewing 15 posts - 36,151 through 36,165 (of 59,102 total)