Just thinking off the wall for a moment, would a stored procedure with a case statment containing the values be quicker? If the procedure is called often, it would be cached so execution time would be quick. There are no I/O issues so there is no need to think about an index. I think that […]
2003-06-25
Check your authentication methods. Open up Enterprise Manager, expand your SQL Server group, and Right-Click on the server. Select Properties from the drop-down menu, and select the Security tag. Now, since it appears that you are using name/password security, make sure that you are using both SQL Server and Windows authentication. If you are not […]
2003-06-23
1 reads
Thanks Guarddata! The later section regarding your template seems to be the solution I need to adopt. I guess I'm still a little confused about the first, simpler question though- In the instances where one needs just a single transaction (no nesting), there will obviously be only one each of the BEGIN, ROLLBACK and COMMIT […]
2003-06-20
1 reads
First let me say this. I HATE USER DATATYPES! OK, now that I got that off my chest. 🙂 User datatypes are a nice easy way to model databases. Especially if you are working in something like Er/Win or Embarcadero. But in my opinion they are more trouble than they are worth in the actual […]
2003-06-19
I'm sorry I misunderstood your ?. No I did not execute that string exactly. I will try that. But I do know in access when I tried to remove @MedRecNum and just put the value in it gave an error stating the variable needed to be filled in. I will try your suggestion in the […]
2003-06-19
The thing is that I'm not updating anything. I just have a view through a linked server to an Oracle table that selects rows with conditions. It's a straight Insert as Select into an SS7.0 table. I don't really have any admin rights into the Oracle db.
2003-06-19
2 reads
you may want to change the way you are recreating your table. try creating the target table schema with your additional identity column first, then move the data using 'insert into' command. hope this helps
2003-06-18
1 reads
quote: Alerter is a Service in Windows 2000 and I believe XP but don't have a machine installed readily available. Service was the keyword. I know where to look now. Thanks! Cheers, Frank
2003-06-18
Alerter is a Service in Windows 2000 and I believe XP but don't have a machine installed readily available.
2003-06-18
I'll go with Antares686 suggestion, thus version II Select Calc.StudentNr,Calc.ColSum/Calc.FieldCnt From ( Select StudentNr, ( ISNULL((CASE When ST1Q1 = 'N' Then Null ELSE ST1Q1 End),0) + ISNULL((CASE When ST1Q2 = 'N' Then Null ELSE ST1Q2 End),0) + ISNULL((CASE When ST1Q3 = 'N' Then Null ELSE ST1Q3 End),0) + ISNULL((CASE When ST1Q4 = 'N' Then Null […]
2003-06-17
“Could you help me, we deleted the database’s transaction log file and now that...
I had a couple of clients who were moving content from development catalogs to...
By Steve Jones
Recently I was trying to use a connection string to connect in SSMS. There...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers