[SQL] Query regarding Writing a report using the file sysstem data processing extensions
Hi Experts.I have some problem in SQL server reporting services 2000.I am doing with FILE SYSTEM DATA PROCESSING EXTENSIONS i have done all the things correctly.like copying the .dll file to 3 folders, writing some code in XML file which was given on net and on books.after that it is showing me the File Sysytem Information in combobox But when i am trying to select this Data typeNow problem occursBut some how i managed it...i have selected windows AuthenticationBut when i am writting in query designer \\MyServer\MySharethen it is giviing errorsome time it is saying that there is error near to \.and some time it is saying that connection can not be made please check the connection string. I am doing all this on my local system So if any body have any idea what to write in query designer and what these errors indicates please help me RegardsDinesh Tiwari Talk is cheap. Use Yahoo! Messenger to make PC-to-Phone calls. Great rates starting at 1¢/min.
Re: [SQL] Query regarding Writing a report using the file sysstem
Hi, Dinesh Tiwari, Dinesh Tiwari wrote: > I have some problem in SQL server reporting services 2000. [...] > So if any body have any idea what to write in query designer You use the MS SQL Server and the MS Query Designer? It seems that you got to the wrong list for that problem, the list here is specific to problems for the PostgreSQL Server. You should ask someone who supports the products you use, you won't go to a Ferrari shop and want them to solve the problems with your Toyota neither. Most of us simply don't know how to help you, as they did never touch the MS SQL software, and the rest is unlikely to like doing it at this place. A further tip: You should include the exact wording of your error messages, and possibly more details of your setup (versions, pathes etc.). And, usually, the MS Knowledge Base and other support material that's accessible for registered MS developers knows the answer for most problems, I've been told by our Windows Gurus here. HTH, Markus -- Markus Schaber | Logical Tracking&Tracing International AG Dipl. Inf. | Software Development GIS Fight against software patents in Europe! www.ffii.org www.nosoftwarepatents.org ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster
Re: [SQL] unique rows
On Wed, Sep 20, 2006 at 22:18:04 -0700, TJ O'Donnell <[EMAIL PROTECTED]> wrote: > I want to make a table that has unique rows - no problem. > Create Table x (smarts Varchar Unique); > > I have input data that has many duplicates and until now > I was creating a temp table allowing duplicates, and then > Insert into x (smarts) select distinct smarts from tmpx; > This is now failing when I have hundreds of millions of > rows, running out of temp space (while trying to sort to > accomplish the distinct?) Another option would be to do a select with a GROUP BY instead of DISTINCT. That would allow for a hash aggregate plan (don't forget to analyse the temp table first) which would use less memory. ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org
