Jeff Moden

Forum Replies Created

Viewing 15 posts - 50,791 through 50,805 (of 59,102 total)

RE: Selecting list of month numbers between two dates

I'm not sure what you mean by find all "month numbers" or "i want all the months inbetween to be listed"... do you want to find the first of every...
--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)

May 3, 2008 at 9:53 am

#810430
RE: Tally Table

Nicely done, Matt! I guess my only exception to what you said is that I use it to "replace loops" all the time. Although.... I'll agree that it's...
--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)

May 3, 2008 at 1:17 am

#810414
RE: cursor through user databases the SEQUEL

Simon... take a peek at the following URL...
http://www.sqlservercentral.com/Forums/Topic494388-145-1.aspx#bm494619
Same technique can be used in SQL Server 2000 using VARCHAR(8000) with some limit, of course.
--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)

May 3, 2008 at 1:05 am

#810411
RE: Problem with Inserting Values into a Table

This is a double post... please post any replies at the following URL...
http://www.sqlservercentral.com/Forums/Topic494354-338-1.aspx
--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)

May 3, 2008 at 12:59 am

#810410
RE: Fetch Row by Row with out using cursor

I haven't tried it, but I believe your problem is in the following code...
DECLARE @MaxRecipeId as INT
SELECT @MaxRecipeId = MAX(RecipeId )
FROM Recipe Where LocationId =1
It should...
--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)

May 3, 2008 at 12:57 am

#810409
RE: Using Temporary tables

I don't suppose you did a search on "running total" or anything like that... 😉
There's a lot of ways to solve the running total problem in SQL Server... they're all...
--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)

May 3, 2008 at 12:50 am

#810408
RE: Dynamic SQL Requirements

Here's the proof...
DROP TABLE jbmtest
go
SELECT TOP 1000000
RowNum = IDENTITY(INT,1,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)

May 3, 2008 at 12:47 am

#810407
RE: Dynamic SQL Requirements

And, I gotta tell you, 2ⁿ for CHAR, VARCHAR, and NVARCHAR size doesn't make a bit of difference because row size isn't any multiple of 2n (ie. 8060) and neither...
--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)

May 3, 2008 at 12:39 am

#810406
RE: Excel vs. Access vs. SQL Server

I'd have to say a lot of that depends on two things...
1. How important is the data? In other words, do you actually want the data to 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)

May 3, 2008 at 12:33 am

#810405
RE: Running Total variable resolution

No, the order is predictable especially if you supress parallelism with MAXDOP... please see the following article...
http://www.sqlservercentral.com/articles/Advanced+Querying/61716/
... and just say "NO" to cursors 😛
--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)

May 3, 2008 at 12:17 am

#810404
RE: Cursor not working

Heh... yeech... you can use a cursor, if you like... here's your's with the fix...
DECLARE @MyCmd VARCHAR(100)
declare @database nvarchar(128)
declare mycursor CURSOR LOCAL
FOR select name from master.dbo.sysdatabases where dbid>5
OPEN mycursor
fetch...
--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)

May 3, 2008 at 12:01 am

#810403
RE: How to import data from a CSV file?

Yes there is... you will need to build a BCP Format File, but it's worth it for the sheer speed of Bulk Insert...
The format file would look something like this...
8.0
4
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)

May 2, 2008 at 11:20 pm

#810399
RE: Parsing a cell into multiple rows

Hi Bill,
I'm a little confused by the data you've posted. Take a look at the URL I carry in my signature line... providing data and table info in 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)

May 2, 2008 at 8:43 pm

#810396
RE: cursor through user databases the SEQUEL

Simon_L (5/1/2008)
Jeff Moden (5/1/2008)
Ok... thanks... just trying to figure it all out... I think that's the last piece. I'll see what I can do tonight.
thanks Jeff appreciated 🙂
Sorry, Simon......
--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)

May 2, 2008 at 8:41 pm

#810395
RE: SQL Server Project

Not with 60 points in 79 visits, you haven'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)

May 2, 2008 at 8:37 pm

#810394

Viewing 15 posts - 50,791 through 50,805 (of 59,102 total)