Jeff Moden

Forum Replies Created

Viewing 15 posts - 54,631 through 54,645 (of 59,089 total)

RE: NEWID() structure

NEWID() won't guarantee it... it's only guaranteed at the full 32 characters.
What's wrong with this?
SELECT CAST(CAST(0x0013020061675035 AS BIGINT)+1 AS VARBINARY)
If you find the largest item in the column, just add...
--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)

October 12, 2007 at 10:20 pm

#741775
RE: Determine field names of stored proc return

I only see the column names being returned... no data types...
--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)

October 12, 2007 at 10:04 pm

#741774
RE: Extracting Text From varbinary(max) field

Notice, the answer above was almost as short and useful as the question... if you want a real answer, could you provide just a wee bit more info about what...
--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)

October 12, 2007 at 9:45 pm

#741773
RE: Extracting Text From varbinary(max) field

Absolutely... 😉
--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)

October 12, 2007 at 9:43 pm

#741772
RE: Seperate digits

If you want something slick to split addresses and validate them at the same time, look into a product called "ZP4".
--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)

October 12, 2007 at 9:36 pm

#741771
RE: Are #temptables unique?

Christopher Klein (10/12/2007)
Just a pre-coffee question but are tables defined as #temp unique to a particular instance of being called?
Say I have a stored procedure that builds up a #temp...
--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)

October 12, 2007 at 9:26 pm

#741770
RE: Unstring text field?

What datatype is the column, really? Is it TEXT, VARCHAR, NVARCHAR, or ???
--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)

October 12, 2007 at 9:22 pm

#741769
RE: create an insert statement

Thought I'd post something folks can play with... could easily be turned into a proc... can be easily modified for an Insert/Values instead of an Insert/Select. With a little forethought,...
--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)

October 12, 2007 at 9:14 pm

#741768
RE: create an insert statement

Nigel Rutter (10/4/2007)
Doesn't need to use a cursor, it can be replaced by:
SELECT @InsertQuery = @InsertQuery + column_name + ',' from ##Temp_Generate
Hope Jeff M doesn't see...
--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)

October 12, 2007 at 8:32 pm

#741767
RE: Use sp_MSforeachtable to gen COUNT(*) for each table in MyDBname

dobrzak (4/6/2006)
I don't think that it is possible with sp_MSforeachtable, but why don't use systems table, eg.:
SELECT object_name(id), rows
FROM sysindexes
WHERE indid...
--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)

October 12, 2007 at 8:11 pm

#741766
RE: How can I tell if I have the latest SQL Server updates?

SELECT @@VERSION
Then, check the Microsoft site for the build number...
--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)

October 12, 2007 at 7:54 pm

#741765
RE: Generating Dates

That nice little cross-join you included as a derived table sure did the trick.
--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)

October 12, 2007 at 6:51 pm

#741763
RE: Converting a FoxPro Procedure to SQL

Now, that's what I'm talking about! Nice job, Kirk!! And, thanks for posting your 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)

October 12, 2007 at 6:03 pm

#741760
RE: Filling in numbers

You bet... thanks for the feedback, Greg.
--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)

October 12, 2007 at 6:00 pm

#741759
RE: is this a good trigger?

No, no... Unless I'm totally misreading this, a good ol' fashioned partitioned view will do all of that without the overhead of triggers and the extra table. It'll 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)

October 12, 2007 at 5:51 pm

#741758

Viewing 15 posts - 54,631 through 54,645 (of 59,089 total)