Viewing 15 posts - 21,316 through 21,330 (of 26,490 total)
I started to reformat your code so I could read it better, and unfortunately you have some logic errors in WHERE clauses. I'm going to leave it as an...
April 28, 2009 at 11:45 am
A seat of the pants change I'd make would be the clustered index on this table:
CREATE TABLE [dbo].[tbl_ProviderCoverage](
[tpcID] [numeric](18, 0) IDENTITY(1,1) NOT NULL ,--PRIMARY KEY but non clustered
[tpcGCProviderID] [numeric](18,...
April 28, 2009 at 11:18 am
GSquared (4/28/2009)
;with T2 as
(select row_number() over (partition by Table1Key order by EventDate desc) as Row,
Table1Key,
EventDate,
EventText
from dbo.Table2)
select *
from dbo.Table1
left outer join T2
on Table1.ID...
April 28, 2009 at 11:07 am
Just to add, don't hesitate to ask for help. Just be sure to give us all the information we need to be of help when the time comes.
April 28, 2009 at 10:24 am
tpepin (4/28/2009)
Lynn Pettis (4/28/2009)
I see several broken guantlets on the ground.
Peter's explaination has already convinced me that set operations would be better. In my case, it wasn't...
April 28, 2009 at 10:17 am
Because you are using the MAX aggregate in the select statement you need a group by clause, try the following:
SELECT
C.ID AS client_eng_id,
...
April 28, 2009 at 10:10 am
I see several broken guantlets on the ground. As I asked for before, give us requirements, DDL for the staging tables and destination tables, processing rules for the data,...
April 28, 2009 at 10:00 am
You can drop your current function dbo.tvfGetNumbers and replace it with this:
create function dbo.tvfGetNumbers
(
@startnum tinyint
)
RETURNS TABLE
AS
return
(select @startnum as number union
select @startnum...
April 28, 2009 at 9:52 am
LMeyer (4/28/2009)
The field I want to add is ClientBuckets.Cinvlastinv (Last date of Invoice...
April 28, 2009 at 9:23 am
Were there any changes in the recovery model used by the databases during that time? If there was a change from FULL to SIMPLE and back to FULL, then...
April 28, 2009 at 9:19 am
I'm slightly confused, what are you trying to accomplish with this code?
April 28, 2009 at 9:13 am
I can't help you with winscp as I haven't used that particular product. You might try a search on SSC for winscp as i do remember seeing a few...
April 28, 2009 at 9:02 am
jo.owens (4/28/2009)
April 28, 2009 at 8:40 am
Kurt W. Zimmerman (4/28/2009)
April 28, 2009 at 8:16 am
Jeff,
I knew you'd have a bit to say here when you read it. I modifed his table def for RawData to match the def in his cursor routine.
Scott,
Yes, your...
April 27, 2009 at 10:26 pm
Viewing 15 posts - 21,316 through 21,330 (of 26,490 total)