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!

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

Recent content by egodette

  1. egodette

    Deprecated Left OuterJoin

    I have a Crystal Report written in 2002 that uses a ttx data source. The left outer join is noted in the sql query as "*=". I have just upgraded to MSSQL 2016 and it does not recognize *=. How do I update the outer join without completely rewriting the report? (Example: AND...
  2. egodette

    How to handle directory names with spaces

    I fixed it. FOR /F "delims=" %%i in
  3. egodette

    How to handle directory names with spaces

    The below code works perfect except if the folder has spaces in the name. This small program looks for file names that are duplicated with different extensions. example -- document.pdf document.tif FOR /F %%i in ('dir /b /s *.pdf') do ( IF EXIST "%%~dpni.tif" ( echo "%%~dpni.tif"...
  4. egodette

    Nested Query

    The correct answer is.... (Thanks everyone for your input) DECLARE @sql varchar(MAX); SET @sql = ''; SELECT @sql += 'SELECT * FROM ' + QUOTENAME(o.name) + '; ' FROM sys.objects o INNER JOIN sys.columns c ON o.object_id = c.object_id WHERE c.name = 'TICKER'; EXEC (@sql);
  5. egodette

    Nested Query

    I didn't give a very good example. SELECT name FROM sysobjects where id in (select id from syscolumns where name like 'TICKER') results in (to show only 3 of the 64 there are) CASHFLOWTICK CDAEMON CDJOURN now I want select * from CASHFLOWTICK select * from CDAEMON select * from CDJOURN
  6. egodette

    Nested Query

    can I get an example?
  7. egodette

    Force SELECT to file.

    sqlcmd -U<user> -P<password> -S<server> -d<database> -I<sql query from input file> -o<output file>
  8. egodette

    Excel 2007 Row indicator changed

    It must be from custom programming. I don't know of any way to change the column header color.
  9. egodette

    Nested Query

    This query SELECT name FROM sysobjects where id in (select id from syscolumns where name like 'TICKER') produces the list of tables that contain a column called TICKER. Now I want to see all the data from each table. Select * from (the result from the above query) Any ideas?
  10. egodette

    PST to EML

    I'm looking for a conversion tool to change PST to EML. I have about 800 PSTs that need converting and I dont want to select them one at a time. Anyone know of a conversion utility that will do one then grab the next one in a directory?
  11. egodette

    measure the amount of change of data at the block level

    Anyone have any ideas on how I can measure the amount of change of data at the block level. I have 2 files that are the same size but some of the data inside is different. I need to know the size/amount of change.
  12. egodette

    More efficient query

    That is the same as a subselect. I figured it out using a Left Outer join where A is NULL Thanks..
  13. egodette

    More efficient query

    I have a table with 2 columns A and B. Column A is unique and B will contain multiple entries of column A. Example Column A Column B 10 10 11 10 12 13 Without using a subselect how can I find entries in B that are not in A as above(13)? I dont what to use a...
  14. egodette

    Set of variables

    Looking for a way to see if a value exists in a set of variables. Example. if x="gb" or x="au" or x="eu" then I would like to say if x in ("gb","au","eu") then

Part and Inventory Search

Back
Top