By the way, just looked at the thread you posted and I feel that there should NOT be two lookup tables in that situation; statuses of court cases are the same logical types of entity, are they not? "OPEN PENDING TRIAL", "CLOSED CONVICTED", etc (assuming these are actual possible statuses), could all go into a […]
2003-12-05
2003-11-24
From http://support.microsoft.com/default.aspx?scid=kb;en-us;812915 quote: A supported fix is now available from Microsoft, but it is only intended to correct the problem described in this article. Only apply it to systems that are experiencing this specific problem. This fix may receive additional testing to further ensure product quality. Therefore, if you are not severely affected by this […]
2003-08-27
Is there a way for me to save this information? The load on the server is lighter overnight when its run and that's the time I'd like to have knowledge of processing times.
2003-07-29
1 reads
You can use a C XML Parser to convert the array to XML, but I don't see any value in storing the XML in SQL Server. You'll just add bloat to the fields, and there isn't any gain in searching ability (AFAIK) by having the data represented in XML. If you already have the mechanisms […]
2003-07-29
1 reads
Actually, a thought has just occurred, and I'll have to rely on your saged advice again. Is there any way of turning these arrays into XML to store into SQL, which could perhaps then in turn be searched on????
2003-07-29
1 reads
no problemo. just a script I thought of this morning...worked great (surprisingly...) -- Cheers
2003-07-28
thanks for that info Jpipes...I'm going to use it for my requirement of getting filenames and dates...this is better than my previous "parsing mechanism"....
2003-07-28
2003-07-28
OR, another way, just to show you examples... CREATE TABLE #temp (OutputText NVARCHAR(1000)) -- INSERT INTO #temp EXEC sp_executesql N'exec master.dbo.xp_cmdshell ''dir c:\MSSQL7\Binn''' -- SELECT RIGHT(OutputText, CHARINDEX(' ', REVERSE(OutputText))) FROM #temp WHERE PATINDEX('%<DIR>%', OutputText) = 0 -- Make sure no directories AND CHARINDEX('/', SUBSTRING(OutputText, 1, 5)) > 0 -- Make sure has a date -- […]
2003-07-28
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
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