Viewing 15 posts - 1,201 through 1,215 (of 1,220 total)
Of course I find it an hour later. http://qa.sqlservercentral.com/columnists/dcorey/netlibencryptionizerreview.asp
-----
[font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]
March 16, 2005 at 10:06 am
Go to the site's search page at http://qa.sqlservercentral.com/search/turbo.asp and look for 'encrypt'. There's a lot of hits that might steer you in a productive direction. I thought there was a...
-----
[font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]
March 16, 2005 at 8:59 am
As a general suggestion since several viable solution approaches have been described, you can get yourself into an indecipherable mess if you try to do the conversion and the aggregation...
-----
[font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]
March 14, 2005 at 11:08 am
I don't know if this would perform better in QA, but it's worth a shot:
Set @SQL = 'select DOCKEYID from DOCKEY'
+ ' where DOCNBR = ' + @Docno
exec @rval = @sql
For a...
-----
[font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]
March 11, 2005 at 9:29 am
Definitely wrap it in a view, or you'll be doing CASTs for the rest of your life. I assume you're not doing updates on the date field, that could be...
-----
[font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]
March 11, 2005 at 9:17 am
Though you have a solution, there's an excellent TechNet article at http://support.microsoft.com/default.aspx?scid=kb;en-us;139444. I had such a problem at a previous job that I created a multi-step SQL script that...
-----
[font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]
March 11, 2005 at 9:05 am
I don't think this is your issue, but there is a condition where a transaction can get hung up and sql server thinks there is something going on and won't...
-----
[font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]
March 3, 2005 at 9:01 am
I used isql extensively for a payroll system that had pretty complicated validation conditions that couldn't easily be enforced through triggers and keys, so I wrote a series of isql...
-----
[font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]
March 3, 2005 at 8:49 am
I prefer not to use the money data type, I use decimal instead. I've had some funky stuff happen in the past with Access and Crystal Reports formatting the field...
-----
[font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]
March 3, 2005 at 8:37 am
Definitely don't use nvarchar if you can use varchar, the "N" means it's unicode, storing two bytes for every byte of data. You need the N series of text datatypes...
-----
[font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]
March 3, 2005 at 8:33 am
Off the top of my head....
select 'Duplicate', acctid, Status
from accounts
where status = 'hold'
and acctid in (
select acctid
from accounts
where status = 'billed')
Maybe something along these lines. With your...
-----
[font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]
March 3, 2005 at 8:28 am
I think triggers will be your best bet. I've seen similar things, and I would think that in such a situation that you're not going to do cascading updates/deletes, so you...
-----
[font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]
March 3, 2005 at 8:23 am
Books that I think should be on any SQL Server DBAs shelf, both by Microsoft Press:
Inside SQL Server 2000, by Kalen Delaney
Microsoft SQL Server 2000 Administrator's Companion, by Garcia/Reding/Whalen/DeLuca
You can...
-----
[font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]
February 15, 2005 at 11:51 am
Got it!
I got a push in the right direction from a local mail list and got it working. I added the ability to specify a sort order as a third...
-----
[font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]
February 10, 2005 at 3:11 pm
I've received a suggested solution from a local email group using Dynamic SQL:
CREATE PROCEDURE [dbo].[YourSproc]
@table1 varchar(100),
@field1 varchar(100)
AS
SET NOCOUNT ON
Declare @SQL varchar(500)
select *
from %EdTableName%
where
'table1' in [EdTableName]
AND 'field1' in [FieldToTest]
...
-----
[font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]
February 10, 2005 at 10:06 am
Viewing 15 posts - 1,201 through 1,215 (of 1,220 total)