David Burrows

Forum Replies Created

Viewing 15 posts - 3,016 through 3,030 (of 3,544 total)

RE: How to split records into a temp table?

Personally I would not use spt_values. I would create temp table containg int column containing values from 1 to max number of days between dtTripStart and dtTripEnd and join that...
Far away is close at hand in the images of elsewhere.
Anon.

October 6, 2003 at 6:59 am

#477171
RE: SELECT from all tables in the database

create table #temp (tablename varchar(250),[col_name] varchar(250),[col_date] datetime)
exec sp_MSforeachtable @command1 = "insert into #temp select '?',[col_name],[col_date] from ? where datepart(year,[col_date]) = 2003"
select * from #temp
drop table #temp
Far away is close at hand in the images of elsewhere.
Anon.

October 6, 2003 at 6:35 am

#477164
RE: How old are you?

quote:
think it gets easier...
Just more frustrating!
Ah! but they're not teenagers yet
Far away is close at hand in the images of elsewhere.
Anon.

October 3, 2003 at 2:04 am

#476919

RE: How old are you?

quote:
babysitting is much harder then working

And it doesn't get easier the older they get...

Far away is close at hand in the images of elsewhere.
Anon.

October 2, 2003 at 9:29 am

#476808

RE: How do I show row data as a single field?

SELECTa.fk,a.dat+ISNULL(', '+b.dat,'')+ISNULL(', '+c.dat,'') as combined_dat 

FROM(SELECT fk,MIN(pk) as pk FROM tablea GROUP BY fk) x 

LEFT OUTER JOIN (SELECT fk,MAX(pk) as pk FROM tablea GROUP BY...

Far away is close at hand in the images of elsewhere.
Anon.

October 2, 2003 at 8:05 am

#476765

RE: SQL aggregates including missing dates

quote:
I shouldn't reply when I don't have enough time to think about what I'm writing

Far away is close at hand in the images of elsewhere.
Anon.

October 2, 2003 at 7:05 am

#476746

RE: SQL aggregates including missing dates

Two things,

Firstly, the where clause is restricting your selection based on invoices when it should be on temp_date_table, eg

where tt.invoice_date between '9/1/2003' and '9/30/2003'

Secondly,...

Far away is close at hand in the images of elsewhere.
Anon.

October 2, 2003 at 6:35 am

#476735

RE: "Ghost Cleanup"? Configuration?

To confirm your observations, found this on TechNet

quote:
When you delete rows, pages, or extents in your database, SQL Server can mark...

Far away is close at hand in the images of elsewhere.
Anon.

October 2, 2003 at 6:10 am

#476726

RE: White Board, Flip Chart, or Notepad?

Another nice topic Andy. I have used all types in different ways in different situations. I must admit I tend towards whiteboards for their versatility and either tranfers the contents...

Far away is close at hand in the images of elsewhere.
Anon.

October 2, 2003 at 2:22 am

#476696

RE: xp_cmdshell fails and returns 255

Ummm, forgot about that. Either use a separate connection or check to see if your logic can be changed.

In some of my apps I do similar where I do multiple...

Far away is close at hand in the images of elsewhere.
Anon.

October 1, 2003 at 2:42 am

#476500

RE: Receiving Results Set in Body of email

Without seeing the proc code, it looks like it sends the contents of the @body parameter as the body of the email and not the results of the query.

xp_sendmail is...

Far away is close at hand in the images of elsewhere.
Anon.

September 30, 2003 at 6:31 am

#476351

RE: Bulk Insert from CSV problem

As far as I know bulk insert and bcp will not remove quotes. DTS gives you the choice. Alternatively write a query after the bulk insert to update columns removing...

Far away is close at hand in the images of elsewhere.
Anon.

September 30, 2003 at 6:06 am

#476349