Viewing 15 posts - 391 through 405 (of 582 total)
No point in unique clustered index on composite key with a surrogate? Don't be too hard on yourself, there might be a point sometimes. It's just not necessarily a good...
Tim Wilkinson
"If it doesn't work in practice, you're using the wrong theory"
- Immanuel Kant
June 1, 2006 at 5:36 am
I wouldn't use dynamic SQL for production code, especially non-trivial data retrieval or concatenating parameters from the front end. But I would draw a distinction between production (application) code and administration (utility)...
Tim Wilkinson
"If it doesn't work in practice, you're using the wrong theory"
- Immanuel Kant
June 1, 2006 at 5:32 am
>any of the variants looking at the metadata
what variants?
Tim Wilkinson
"If it doesn't work in practice, you're using the wrong theory"
- Immanuel Kant
June 1, 2006 at 5:10 am
Sergiy, some data is 'a mess'. Some data refers to its own processing. Someone somewhere has a legitimate reason for doing what I describe. So the answer to the question...
Tim Wilkinson
"If it doesn't work in practice, you're using the wrong theory"
- Immanuel Kant
June 1, 2006 at 4:49 am
You'd only be interested in the INSERT order if there was a identity column. Sergiy, are you saying that this won't work and new records might be 'incorrectly' numbered?
Tim Wilkinson
"If it doesn't work in practice, you're using the wrong theory"
- Immanuel Kant
May 31, 2006 at 7:52 pm
But you can't do it setwise, of course.
MS have deprecated use of READTEXT with text pointer saying it will be phased out, and recommended using SUBSTRING instead. Does anyone...
Tim Wilkinson
"If it doesn't work in practice, you're using the wrong theory"
- Immanuel Kant
May 31, 2006 at 7:43 pm
[EDIT: THIS FIRST PARA WAS WRITTEN WITHOUT READING THE PREVIOUS POSTS PROPERLY] If that doesn't do it, I'd be surprised, but if not, can you see any difference between the showplan...
Tim Wilkinson
"If it doesn't work in practice, you're using the wrong theory"
- Immanuel Kant
May 31, 2006 at 6:16 pm
Just out of interest, is the problem with the 30K text values just a performance issue, are your embedded 'rows' > 8K, or is a variable overflowing, or none of...
Tim Wilkinson
"If it doesn't work in practice, you're using the wrong theory"
- Immanuel Kant
May 31, 2006 at 5:53 pm
Funny, I always thought it was disallowed. Maybe it was in v6.5 or 7 and I never realised they had changed it? The matter's not really documented, so I don't...
Tim Wilkinson
"If it doesn't work in practice, you're using the wrong theory"
- Immanuel Kant
May 31, 2006 at 5:17 pm
a
BP_At_Time = b.BP_Code
Tim Wilkinson "If it doesn't work in practice, you're using the wrong theory"
- Immanuel Kant
May 31, 2006 at 4:56 pm
Here's one way, using pure SQL. I've had to guess at your table structures and some other things.
c.FullName Tim Wilkinson "If it doesn't work in practice, you're using the wrong theory"
- Immanuel Kant
May 31, 2006 at 4:07 pm
Looks like you have some import files stuck in your DB. You want to extract them and use an import process: bcp out, bcp in. Or perhaps ask the DTS...
Tim Wilkinson
"If it doesn't work in practice, you're using the wrong theory"
- Immanuel Kant
May 31, 2006 at 3:19 pm
I'll have a go: when you use a GROUP BY clause, you specify that you only want one row returned for each distinct combination of values in the fields specified...
Tim Wilkinson
"If it doesn't work in practice, you're using the wrong theory"
- Immanuel Kant
May 31, 2006 at 3:11 pm
You mean one SET clause, one FROM clause and one WHERE clause. You can have as as many JOINs as any other...
Tim Wilkinson
"If it doesn't work in practice, you're using the wrong theory"
- Immanuel Kant
May 31, 2006 at 2:40 pm
>How do i create a .bat file with t-sql?
What do you mean? How to create the actual OS file, or how to generate windows shell script?
Tim Wilkinson
"If it doesn't work in practice, you're using the wrong theory"
- Immanuel Kant
May 31, 2006 at 2:25 pm
Viewing 15 posts - 391 through 405 (of 582 total)