Search results for query: *

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...

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"...

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?

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?

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.

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...

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

I have a simple network. Class C, 192.168.8.0/24. I am running out of IP address and need to change to a class B to provide more host nodes. Here is my question as one who is not a network guru, Can I just change the subnet mask to /16 without changing the 192.168. to 172.16.? Thanks.

I have written a stored procedure and want to export the values of several variables to see what they are durning execution. In VBS I would just use a MSGBOX. This would pause the program and show me the values. How do I do something similiar in MS SQL 2005? Or how do I write the values to a...

I want to display information if there is a duplicate in one field. I know how to find the duplicate by using GROUP By and HAVING but how do I get other information to show up? DATA: AAPL AAPL 1000 ABT AAPL 1100 BBVY STUB 1200 CCDG AWER 1200 Desired OUTPUT: AAPL AAPL 1000 ABT...

Using the Replace command with a set. I have a single column that I want to return partial values from. Example 000270 KS EQUITY 123456 US EQUITY 345612 CORP CUSIP The select statment should return 000270 KS (notice how I cant look for the first space) 123456 345612 right now I'm using a...

I have a table with 3 fields. These fields contain duplicate entries for two of the fields. This SQL statement produces these results. SELECT * FROM MULTCLAS WHERE TICKER = 'TLP' TLP XZ PRT TLP XZ SHL What I want is an sql query that procudes: TPL XZ PRT SHL Any help...

I want to keep a computer(A) from accessing another computer(B) on the network. It has to be by IP address. I tried putting an entry in the route table of computer A to route packets destined to B to 127.0.0.1 but that did not work. Any ideas?

I want to display 0x2C6D1A in a datagridview. The system is trying to display System.Byte[] instead. How can I display the binary value?

Trying to return data to a DataGridView from an SQL2005 query. The first element is what I'm having an issue with. select convert(varbinary, emailkey) as uid, emailaddress from emailaddress If I leave off the "convert(varbinary, emailkey) as uid" it works perfect. With it on I get a very...

How can I convert one element in this array to uppercase as it is being written to a file? I want dr(1) in Upper Case. I tried vbUpperCase(dr(1)) but it gives me an error. Dim sw As New System.IO.StreamWriter("F:\myfiles\" & Format(Now, "MMddyy") & ".tmp") 'Loop through each DataRow in the...

Instead of using If (variable = "one" or variable = "two" or variable = "three") then Is there a way in VBA for Excel to say If variable exists in ("one","two","three") then

I read a CSV into a DataSet that contains digits that should be stored as String. Example.. adus,088606108,12.00 When I read the data back using the following code strMsg = ds.Tables(0).Rows(1)(1) It drops the leading 0 and becomes 88606108 Reading this line adus,05545e209,12.00 becomes...

I just cant make sense of this. if I use this code: msgbox = left(s_Line,pos-1) I get the value that I want if I use this code: rating = left(s_Line,pos-1) I get an error message Invalid procedure call or argument:'left' Any ideas?

Trying to automate a daily task. By how much have directory sizes changed. Code currently. (works perfect but has to be run manually to fill %1 var) @echo off setLocal EnableDelayedExpansion set /A value=0 FOR /R %1 %%I IN (*) DO set /A value=!value!+%%~zI @echo %1: !value! I have a file...