Jeff Moden

Forum Replies Created

Viewing 15 posts - 37,606 through 37,620 (of 59,072 total)

RE: Checking expiry dates in a table

I don't believe that it needs to be quite that complex. Unless I'm somehow missing the big picture, something like the following should do...
SELECT * FROM dbo.YourTable
...
--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)

July 16, 2010 at 9:55 pm

#1194462
RE: Insert data into one table column with multiple values of another table column

juanpablosiller (7/16/2010)
Hi,
I came to the conclusion that I could insert first the name values and then copy the values of one column to the other, the thing is that they...
--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)

July 16, 2010 at 9:41 pm

#1194459
RE: 64-bit MS SQL 2008 ... is it worth it?

It would be better if MS made the realization that folks will still need to I/O with MS Office products even on 64 bit machines. As a side bar,...
--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)

July 16, 2010 at 8:55 pm

#1194454
RE: All Joins at once, or only when View is queried?

My answer would be... try it. Check the actual execution plans of both methods and the load it puts on resources using SQL Profiler.
--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)

July 16, 2010 at 8:50 pm

#1194452
RE: OPENROWSET mysteriously stopped working

ZenDada (7/16/2010)
This worked last week:
select top 1 a.* from
OPENROWSET('SQLOLEDB','myServer';'myLogin';'myPassword',
'SELECT * FROM myDB..myTable') AS a
Now I get errors:
OLE DB provider "SQLNCLI10" for linked server "(null)" returned message "Login...
--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)

July 16, 2010 at 8:45 pm

#1194451
RE: Insert data into one table column with multiple values of another table column

This should do it... (untested)
INSERT INTO TABLE1
(Name, Age)
SELECT 'JIM' AS Name,
Age2 ...
--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)

July 16, 2010 at 8:39 pm

#1194450
RE: Something like a running total...

marty.seed (11/10/2009)
I figured out how to do it for the weekly total rows...
=iif(InScope("Date2"), sum(Fields!Sales.Value), last(Fields!Sales.Value))
Now the conundrum lies in trying to total the total columns correctly
Hi Marty,
Did you ever get...
--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)

July 16, 2010 at 5:33 pm

#1194442
RE: Generating SubTotals using GROUPING

Nice job, Sunil. I especially liked the fact that you compared what some folks go through with multiple queries (in one form or another) and the simplicity of WITH...
--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)

July 16, 2010 at 5:32 pm

#1194441
RE: Generating SubTotals using GROUPING

Eric L Hackett (7/13/2010)
How would one go about grouping by dates, i.e. month, year?
So a query from 12/30/2009 thru 1/2/2010 would have something similar to this.
Meter Day ...
--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)

July 16, 2010 at 5:28 pm

#1194440
RE: Expire rather than Delete records in a table

How about WHERE EndDate <= GETDATE(). That way you can "future date" expiration dates and never have to worry about them.
--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)

July 16, 2010 at 4:58 pm

#1194434
RE: COPY SQL QUERY

Ram:) (7/16/2010)
I think still I didn't give much information about my problem..
Here is the clear information..
I have around 50 database with same schema..
I have one additional database to store 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)

July 16, 2010 at 4:56 pm

#1194432
RE: COPY SQL QUERY

seth delconte (7/16/2010)
Jeff Moden (7/16/2010)
seth delconte (7/16/2010)
I think there's a way to do that other than running Profiler to record the queries...
Cool... what is it?
Typo...I meant I DON'T think there'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)

July 16, 2010 at 4:52 pm

#1194431
RE: Performance on Views that span databases on multiple servers

Ummmm... cross server joins are quite a bit different than cross database joins. I try to avoid cross server joins whenever possible. In fact, I've gone out of...
--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)

July 16, 2010 at 4:44 pm

#1194427
RE: ssis problem in T-Sql

riajain9 (7/14/2010)
Hi everyone,
I have a strange requirement in SSIS, that I wanted to share with you all, and need some idea on how can I implement it...
I have to associate...
--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)

July 16, 2010 at 4:02 pm

#1194418
RE: COPY SQL QUERY

seth delconte (7/16/2010)
I think there's a way to do that other than running Profiler to record the queries...
Cool... what is it?
--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)

July 16, 2010 at 3:37 pm

#1194402

Viewing 15 posts - 37,606 through 37,620 (of 59,072 total)