Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: ESquared
  • Content: Threads
  • Order by date
  1. ESquared

    Copy array elements using CopyMemory

    I'm transposing a 2-dimensional Variant array (subtype String) and would like to speed it up using CopyMemory to copy string pointers instead of actually making copies of all the strings. (Of course, if you have a better suggestion, I'm quite open to other ways to accomplish this task.) So...
  2. ESquared

    Retrieve the SQL Error Number from a SOAP Exception

    I am using C# with framework 2.0, but I don't need working code, just some info about the SoapException object returned when using web services to run SSRS reports. If the SQL Server creating the report encounters an error, I do get the exception and can see all sorts of information. However...
  3. ESquared

    Programmatic Report Generation

    In one week I am supposed to come up with the following: Using an existing, working, parameterized SSRS report, 1) Check for work to do. If work is found, go to step 2, otherwise pause for one minute and repeat step 1. 2) Run the report using the two parameters in the work found in step 1...
  4. ESquared

    What's up with SSIS?

    I tried my first SSIS package today, and it was a very unpleasant experience. I can understand that it takes time to learn something new, but this seems like a joke. Up until the point where I created a package and ran it on my own local computer, things weren't too bad. But trying to deploy it...
  5. ESquared

    Determine the group a Windows Authentication user is authenticating as

    I figured out how to do this a month or two ago, and now I can't find it again. Let's say I grant everyone in the Windows Security Group "Department A" general access to a server and to one database on that server. Next, let's also say that I grant another Windows Security Group access to the...
  6. ESquared

    Spare Yourself Some Pain

    Ever heard of a runaway F5? This is when you intend to highlight only a small section of SQL code but you miss for some reason and when you hit F5, the entire script you have loaded runs instead of just the small part you tried to highlight. It's not enough to put a syntax error at the top of...
  7. ESquared

    Poorly Worded

    While on hold today, I heard "... we value the importance of your call ..." Think about it. Instead of telling your loved ones "you are important to me" just tell them "Your importance is valuable to me!" Of course, you could say this to your enemies, too.
  8. ESquared

    Char columns wasting space in your database?

    If you want to know how much space is being wasted in a database by using char instead of varchar (or nchar instead of nvarchar), I wrote a full stored procedure for you to do just that which you can get at SQL Waste Land.
  9. ESquared

    IE - style an anchor's child elements using a:hover

    For some reason I expected this to work: <style type="text/css"> a:hover span { color:red; } </style> <a href="">some text and <span>a span</span></a> But it didn't work. And I was going to ask a question about it. But in playing with it, I found out something interesting. You can style...
  10. ESquared

    Yet Another Another Way to Say Green

    My company, which I'll call California Hospice (the initials are correct) is holding a contest to come up with a creative name other than "Going Green" for a planned environmental friendliness campaign that will run for more than six months. An example of a name they already use is CHIP...
  11. ESquared

    SQL Teaser

    What output will be given by the following query? select len(a), len(b), convert(varchar(10), a), convert(varchar(10), b), ascii(substring(a, 2, 1)), ascii(substring(b, 2, 1)) from ( select a = convert(varbinary(10), convert(varchar(10), 'a')), b = convert(...
  12. ESquared

    Functions that only object detect once

    I have this somewhat unformed idea about how random javascript code I see in the wild could change for the better. I'm not sure if there's any real performance improvement to be had, but this idea appeals to me really strongly from an elegance and efficiency perspective. And I admit I think it's...
  13. ESquared

    SQL Challenge

    Compete to give the most efficient query that returns a column grouped by key based on the most recent date of another column. I will run your queries against a 359,000 row table I have on a production server. This table records certain information about certain occurrences. CREATE TABLE...
  14. ESquared

    Weird Execution Plan in SQL 2000

    I have a table with 62,037,506 million rows in it, call it BigTable. I am investigating a column, call it SequenceNumber. I just want to see some typical sequences. So I run a query: select top 100 * from BigTable order by ParentID, SequenceNumber This takes forever and I finally kill it...
  15. ESquared

    Praying to the Porcelain God

    A while back when I was playing Rollercoaster Tycoon, I got inspired by the roller coaster name "The Vomit Comet" to try to come up with my own euphemisms for throwing up, to name some of my custom-built high-intensity rollercoasters. This thread is for you to share any euphemisms you know...
  16. ESquared

    Alternative to position:fixed

    Since IE doesn't support position:fixed properly, it's difficult to add a title/top bar at the top of the screen but have all the rest of the content on the page scrollable using the main scrollbars. If you have a solution to make IE respect this (ver 6 and up) I'd appreciate it. However, I...
  17. ESquared

    User should be able to login but cannot

    So I have this SQL 2000 server I've granted access to the Windows Group MyDomain\AllUsers. Security access: Grant access Default database: ADatabase Server Roles: <none> Database access: Permit in ADatabase as public role. In ADatabase I have a User: Name: MyApplicationUser Login: MyDomain\All...
  18. ESquared

    Use code from another project

    I thought I could load multiple projects in VB6 and use code from one project in another. But it appears that's not possible. I can create a project group with multiple projects showing and choose the startup project, but when I try to, say, declare a class variable of a class defined in the...
  19. ESquared

    Determine Virtual Path for Current Application/Site Root

    This started out as a question, but I figured out an answer so here goes. If you have this problem, read down: How does one determine the virtual path for the current application root (or site root if there is no application)? I have a web project that on the test server is an application of...
  20. ESquared

    Reverse of GetRows? (Array to Recordset)

    Is there a way to stuff a two-dimensional variant array into a recordset, basically the opposite of GetRows? Or do I have to do this (pseudocode): Set Rs = New ADODB.Recordset Rs.Fields.Append Name1, Type, Length Rs.Fields.Append Name2, Type, Length Rs.Open For LBound(Array) To UBound(Array)...

Part and Inventory Search

Back
Top