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

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

tasklist /FI "SESSIONNAME eq Console"

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

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);

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

can I get an example?

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

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

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.

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

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.

Opps.. nbtstat only works with windows. Try pinging the server then do arp -a <ipaddress> This will return the mac address of a Linux box.

To remotely find the MAC address: from a DOS prompt type nbtstat -a <ipaddress of system>. It will return the MAC address.

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