Viewing 15 posts - 2,131 through 2,145 (of 2,862 total)
Dev (1/29/2012)
Just for curiosity, did you open the CSV file in notepad or some text editor? IIRC Excel won’t show the single quotes but text editors will do.
This...
January 29, 2012 at 9:05 am
I think that PaulB gave you a good hint:
When you eliminate grouping by the date, you get counts for one set only and all duplicates of b within that set...
January 28, 2012 at 6:07 pm
A single quote at the start of a cell is used to force text format. This is necessary to prevent unintended conversion of values that could be interpreted as numeric,...
January 28, 2012 at 5:27 pm
I will be glad to help, if you follow the posting guidelines.
Please post your DDL and sample data.
January 28, 2012 at 5:06 pm
I could not have ge this done during working hours, I had to take on it on Saturday and got it right.
Thanks, Stewart!
January 28, 2012 at 4:51 pm
elvinkhatri (1/26/2012)
Here's are the connection strings:DRIVER=SQL Server;SERVER=CLER-SQL;UID=sqluser;;APP=Microsoft Data Access Components;WSID=VM-PAB;DATABASE=DMD
DSN=DTrac;UID=sqluser;;APP=Microsoft Office 2003;WSID=SHP;DATABASE=DMD
Sorry, Vinkhatri, I am afreaid I am not able to help you with this one: I do not have...
January 27, 2012 at 12:21 pm
I got a Jetta, 149k miles and going strong. It ised to do 32 mpg on a highway, now it is down to 28.
January 26, 2012 at 3:46 pm
For a responsible answer I would have to see your connection string(s).
However, as a rule of thumb, make sure that Mode=Read and MaintainConnection=False.
January 26, 2012 at 3:37 pm
In my experience, the most important piece for work with computers are good glasses, and an optometrist checkup once a year.
Personally, I never settle for the second best.
January 26, 2012 at 3:15 pm
Steve Jones - SSC Editor (1/25/2012)
. . . As long as developers were accessing data only, I think you are fine. However, I would still clarify with MS on this.
Steve
As...
January 25, 2012 at 11:16 am
Email <>, Executive Assistant to <>, and ask her to forward your question to whoever can answer it.
Please don't forget to stress that you are writing only after you have...
January 25, 2012 at 9:23 am
jvkondapalli (1/24/2012)
Hello gurus,
I need your comments on the table partitioning we implemented in our environment.
we have a pk column (INT), Partitioning column(Datetime), fkcolumn (INT), few other varchar columns
We created a...
January 24, 2012 at 7:19 pm
TheSQLGuru (1/24/2012)
January 24, 2012 at 7:10 pm
SQL Kiwi (1/24/2012)
Steve Jones - SSC Editor (1/24/2012)
But you can ski?
I tried snowboarding once (in a supervised inside environment[/url]) and that was enough to convince me that I have no...
January 24, 2012 at 6:43 pm
Steve Jones - SSC Editor (1/24/2012)
SQL Kiwi (1/24/2012)
and it's summer here and not-so-summer in Seattle/Bellevue/Redmond.But you can ski? Maybe down the street in Bellevue 😉
. . .
That was a...
January 24, 2012 at 6:36 pm
Viewing 15 posts - 2,131 through 2,145 (of 2,862 total)