Viewing 14 posts - 1 through 14 (of 14 total)
Thank you, I even understood it
December 28, 2015 at 9:31 am
Thanks everyone for the responses. I can see that although it is possible I think I should separate the statements for simplicity and speed. I appreciate how everyone came together...
April 29, 2015 at 7:20 pm
I sure sparked a topic, I would like to say sorry but I loved every bit of "Back and forth" as I learned much from this.
Thanks everyone who gave...
June 2, 2014 at 1:35 pm
DOH!
Thank you all and thanks Lynn!
May 13, 2014 at 9:47 am
When I ran this code it update ALL the records to the same value.
(These are the real table, field names)
WITH BaseData as
(SELECT vendorno, count(DISTINCT checkno) AS ChkCount
FROM checks...
May 13, 2014 at 9:08 am
Thank you MM, I was able to get the counts, but I wanted to update the results table with the counts. This is where I am having the issues.
May 12, 2014 at 7:22 pm
We started out on VM but the performance was horrible. I think we have a better environment now but I am still a bit scared to move it back. As...
April 30, 2014 at 3:18 pm
This was exactly what I needed. The task is now accomplished! Thank you!
February 17, 2012 at 11:05 am
What I meant by installing drivers was that I need to create a DSN using an ODBC for each workstation that needs to access the data. Its easier to use...
August 28, 2010 at 9:05 am
Yes, you need to supply your login information when using SQLCMD. Here is a sample from something I have done recently.
sqlcmd -S\Dbserver -U sa -P password1 -s, -W -i c:\apinvoice.sql
This...
April 6, 2009 at 12:39 pm
I am sorry to add that I have posted 3 questions on this site and so far I have not gotten one reply. I thought it was me.
November 13, 2008 at 8:40 pm
NICE!! Much faster and much cleaner to read. I have to do this for 40 different tables that all reference the same PR1_EmployeeMaster table. You have made my task a...
April 17, 2008 at 9:05 am
Thaks for the help. I am a programmer and kknow the connections strings, but it wasn't working. Sometimes you doubt yourself when you don't get the desired results.
The problem...
April 17, 2008 at 8:11 am
THANK YOU!!!
That worked perfectly. I love it when things work out.
January 29, 2008 at 12:49 pm
Viewing 14 posts - 1 through 14 (of 14 total)