Viewing 15 posts - 556 through 570 (of 628 total)
Since you state DTS I assume you are doing this on SQL 2000?
Dan
If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.
May 4, 2010 at 12:46 pm
Every element in a server instance can have a different collation. We have one table olne that has 7 different collations.
Dan
If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.
May 4, 2010 at 12:20 pm
I would think you just need to break you date down into date parts and use that in you grouping.
So lets say you have a record set with the type...
Dan
If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.
May 4, 2010 at 10:46 am
There ae files although this process was not written with a great deal of common sense.
I would love to be able to read the file and in fact my...
Dan
If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.
April 30, 2010 at 9:51 am
Thanks to everyone for the replies. It helps alot to know what others are doing.
Dan
If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.
April 30, 2010 at 7:08 am
The sad part is that is the best explanation I could find ont he subject.
Dan
If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.
April 27, 2010 at 3:14 pm
HEre is a blog post that atleast might get you part of the answer
http://sqlblog.com/blogs/kalen_delaney/archive/2006/09/06/186.aspx
Dan
If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.
April 27, 2010 at 3:00 pm
It might look something like this.
Assuming you have some sort of key field. we will call it pkey
I would select this into a temp table
select
involved,
case
...
Dan
If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.
April 27, 2010 at 2:44 pm
sorry posted on wrong thread
Dan
If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.
April 27, 2010 at 2:39 pm
It looks like you forgot the "_" in the field name in your trigger.
Dan
If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.
April 27, 2010 at 2:36 pm
Here is a link to another forum where they apear to have atleast a similiar issue. Hope this is helpful.
Dan
If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.
April 27, 2010 at 2:31 pm
I would look at the linked server object in management studio. that will allow you to look at all the information in one window and might give you an...
Dan
If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.
April 27, 2010 at 2:06 pm
Is this a pre 2005 instance?
Dan
If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.
April 27, 2010 at 2:03 pm
We use reporting services scripter. you can download it from here
http://www.sqldbatips.com/showarticle.asp?ID=62
Dan
If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.
April 27, 2010 at 2:02 pm
never mind I read you initial description wrong. I did not see the s the first time. those names are way to similiar. lol
Dan
If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.
April 27, 2010 at 1:56 pm
Viewing 15 posts - 556 through 570 (of 628 total)