The problem is that your table names are in a table and that is why you are using cursors. How many 'Volume_Control.tblFilenames_' tables are there and what size are they (rows). Is the number fixed or variable. If you want all the results in one recordset then the use of a temp table would be […]
2003-12-19
2 reads
Matt, 1st thing I see is you have "WHERE" twice in one WHERE CLAUSE.... "where on_contract <=" should be "and on_contract <=" As far a formatting the post, I use the "#" tool on the "post edit toolbar". This is {CODE} insert block. It also seems to be much better if I put an added […]
2003-12-19
1 reads
I reworked the join, though I think you meant the active_units table and not the active_units_static, I almost got it 100% sytaxally working with one error saying Line 18: Incorrect syntax near 'EOMDates' I am not seeing anything wrong near line 18 which is right after the cross join. I do believe there are a […]
2003-12-19
1 reads
Thanks for your suggestions. This is a wonderful group with everybody giving such prompt responses. Thanks David, the exec enclosing the cursor works. But I have been toying with the idea of creating a temp table as jxflagg and Gary have suggested. Would a temp table be better as far as performance goes ? Is […]
2003-12-19
1 reads
Change the cursor2 declare to this declare @sql nvarchar(4000) set @sql = ' DECLARE cursor2 CURSOR GLOBAL DYNAMIC FOR SELECT sum(file_size_bytes) , Lseries from ' + @filename + ' group by Lseries FOR READ ONLY ' exec(@sql)
2003-12-19
1 reads
Eoin and Greg Thanks for your replies. I actually tried out Gregs script first before I saw Eoin's one. It worked, very well. Eoins script looks very similar. Thank you both. Eamon Edited by - eamonroche on 12/19/2003 03:51:11 AM
2003-12-19
1 reads
And, when the above answer doesn't work, use CHAR(13) + CHAR(10), which is a CR (carriage return) followed by a LF (line feed). Note: Some computer systems use only a "newline", which is CHAR(10).
2003-12-18
In the real world, the situation you describe is common. You've never had a problem because most of the data in those varchar columns happens to be far smaller than the maximum allowable. Tables created through DTS to import data into end up with varchar(255) columns by default. One of the recent worst practices articles […]
2003-12-17
1 reads
quote: Antares, do you mean if I join a bunch of tables together that collectively exceed the row limit & try to sort them it wouldn't work? This doesn't seem right. Or do you mean only if I first combined rows (String Concatenation)? If you create a join of tables with a column list that […]
2003-12-10
As described it would appear you are still violating the license. The license is to allow you to connect. If you connect without the Microsoft software but with something else, you still connect. If you plan to do so without a license, just use Query Analyzer anyway, you are no MORE in violation. Edited by […]
2003-12-08
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...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
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