Can you post your batch script? May the Almighty God bless us all! www.empoweredinformation.com
The number of IFs is driven by the number of actual conditions you need to handle on the data. I would suggest to focus more on the readability,...
If this will be an ongoing job and you don't have any copy on the remote site. I would recommend that you do the quick initialization by exporting...
It will be better for everyone if we can see the code, this helps us understand if we are talking the same context of the "code". We can keep...
I am not sure if this is correct but I think you want to have another column for the primary key and not the SolisID. By assigning a REFERENCE...
Can you specify what type of insert is running (batch/single, application/trigger/stored procedure) and what's the performance issue (ddl or read)?...
Is the table being used somewhere else or it is just yours?<br /><br />If you are worried just about the space and speed (not the uniqueness), then...
If you don't mind, here is my suggestion:<br />If you have a chance from scratch and you don't have any business constraints, i suggest to use the...
set the connection timeout to 0 (for infinite value) or set the timeout to acceptable value (you decide what is acceptable value to you). You can...
I am not sure if this is what you need. I tried to simplify the query so the idea is communicated clearly and you may confirm if this what you want....
What kind of match and margin of error do you allow? Double Metaphone is good when you need better quality than soundex but it will cost performance...
<blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote">Hm, is jethrojaw =...
You can't manage the database structure in real-time. You have to employ version control and control log in your dev team. Here's an idea to...
or in .Net, you can use the DirectoryEntry and DirectorySearch (System.DirectoryServices namespace). May the Almighty God bless us all!...
not sure what version/sp you are using. However, when I run the following: if (select object_id ('dbo.testing')) IS NOT NULL DROP PROCEDURE...
Just to share the solution to others: DECLARE @FullPathFileName VARCHAR(2000), @FileName VARCHAR(2000) SET @FullPathFileName =...
Check the statement. He select the recordset into a temp, delete the original based on the temp, insert the "new" value from the temp. Technically...
How can you tell if you're not using the allocated bandwidth? May the Almighty God bless us all! www.empoweredinformation.com
You need to access the WMI objects which is either through VB script or non-SQL application. From the application, you can then populate the data...
If you are using it in a OS Batch command, try using the PRINT instead. DECLARE @Data VARCHAR(8000) SELECT @Data = @@VERSION PRINT LEFT(@Data,...
Separate names with a comma.
