Viewing 15 posts - 9,421 through 9,435 (of 9,720 total)
Stuff isn't working for me. It's complaining that my subquery is returning more than 1 value.
I guess I am going to have to do this the hard way. I really...
September 18, 2007 at 12:00 pm
Except that still doesn't give me percentages. I can't find a function that does.
Any thoughts?
September 18, 2007 at 11:18 am
You have to default any variables that you might potentially not receive from outside the stored procedure. However, you can't actually use the DEFAULT keyword with variables that are passed...
September 18, 2007 at 11:11 am
Yes, you have the right idea, but your SP WHERE clause is wrong.
You can't use the WHERE clause to match the variables you are passing into the SP to each other. ...
September 18, 2007 at 6:56 am
JV,
Have you ever used SSIS before? What about DTS? If you've never used either, I recommend getting an SSIS book. If you've used DTS but not SSIS, you might be...
September 18, 2007 at 6:30 am
You know, it occurs to me that you might be heading in the wrong direction. Especially as some of your row results turn out to be column headers, but the...
September 18, 2007 at 5:49 am
First, do you have FULL Text Indexing set up on your SQL Server?
The CONTAINS keyword only works with that. Same as FREETEXT, CONTAINSTABLE and FREETEXTTABLE.
Secondly, you have to code your...
September 18, 2007 at 5:40 am
Have you checked out the new PIVOT operator in Books Online?
I'm just learning it myself, so I can't give you a lot of information. Though I'm not sure you can...
September 18, 2007 at 5:19 am
Paul,
Well, I'm good and stumped here. The only thing I can think of is that maybe there's a hidden newline character somewhere in the date field, but I'm not...
September 18, 2007 at 3:59 am
Steve,
Maybe they are just using it in a colloquial sense, but there are a lot of people who would take the word "Snapshot" literally. So I decided just to stick...
September 17, 2007 at 2:26 pm
I don't recommend a snapshot, actually. If the Developers are going to be constantly developing against a DB, a better practice would be to do a nightly restore of production...
September 17, 2007 at 10:38 am
Ariadne,
Remember also, that if you automate your backups via the Litespeed Enterprise console, it can self verify without you having to "wait until it's done" and running that extended sproc.
September 17, 2007 at 10:33 am
Actually, there's sound reason to move your SQL Server install to another drive. If you have multiple drives, put your OS on the C: drive and then the SQL Server...
September 17, 2007 at 10:31 am
DateTime collation issues shouldn't affect a character field, so it's a little strange to me...
What's the code you're using for the Bulk Insert? What delimiters are being used in the...
September 17, 2007 at 10:14 am
Paul,
What size is the character field you're using in your staging table? You don't mention that.
Also, if it's importing as a character field, but syntax erroring on the Convert, you...
September 17, 2007 at 8:06 am
Viewing 15 posts - 9,421 through 9,435 (of 9,720 total)