Viewing 15 posts - 766 through 780 (of 844 total)
Maybe some kind of electrical shock device, like a tazer, I could use on the plane when the person in front of me decides to lean their seat back into...
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
December 13, 2013 at 7:39 am
I thought about the Samsung watch/phone, but you have to have carry around the smart phone. At least that is what I understood. I just want the watch to...
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
December 13, 2013 at 7:18 am
Without more detail it is hard to help, see Sean's post.
As I said I would think the union's would work but without data to test it I can't be sure....
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
December 12, 2013 at 10:05 am
What results are you getting? There is syntax errors in your posted SQL, commas before the from, I assume you removed some fields for the post.
Formatting the SQL will...
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
December 12, 2013 at 9:14 am
I recently worked on a process that had about 10 different fields I needed to check, all were had 'Y' or 'N' as the value. If any one of...
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
December 12, 2013 at 7:36 am
I was also having problems last month getting mine, I went in and unchecked the button to get the newsletter and saved it. Then went back in later and...
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
December 11, 2013 at 2:52 pm
Just an FYI if you are using the CONVERT with 112 you don't need the REPLACE statement the 112 does not return the results with the slashes(yyyymmdd).
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
December 11, 2013 at 10:29 am
Steve Jones - SSC Editor (11/21/2013)
below86 (11/21/2013)
Currently we don't really have anything in place to do...
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
November 21, 2013 at 10:46 am
yayomayn (11/21/2013)
In SQL 2012 you have the...
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
November 21, 2013 at 9:47 am
This speaks to a bigger question I have at times. "What all uses this table?" It would be nice to know every SSIS package, .SQL file or stored procedure...
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
November 21, 2013 at 9:08 am
We have ours stored as .dtsx files on our server. I can use a Ultra Edit to search just the *.dtsx files for the table name I'm looking for.
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
November 21, 2013 at 8:49 am
Version Control? What is this novel idea you speak of? Just joking. 🙂
Currently we don't really have anything in place to do this here. I would love...
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
November 21, 2013 at 8:06 am
Thanks, Gail. That is what I was thinking but wanted some else's opinion.
If I execute the stored procedure from the bat file will I still be able to direct...
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
November 12, 2013 at 8:44 am
Koen Verbeeck (10/30/2013)
below86 (10/30/2013)
...osql -S %1 -E -d %2 -i "%3%4.sql" -o "%3%4.log" -b
...
Just for your information:
osql is deprecated (and it has some issues. I remember it not working with...
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
October 30, 2013 at 1:33 pm
We have the following in a bat file:
REM This BAT file uses the userid and password of the account that is running the BAT file.
REM %1 = SQLServer name
REM %2...
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
October 30, 2013 at 10:57 am
Viewing 15 posts - 766 through 780 (of 844 total)