Phil Parkin

Forum Replies Created

Viewing 15 posts - 5,806 through 5,820 (of 13,874 total)

RE: Data clean up

Jim Bishop - Wednesday, March 15, 2017 10:11 AM
Thanks for the reply Thom,
Distinct won't work because I need to have the MIN of...

March 15, 2017 at 10:14 am

#1933285
RE: More "ACE" driver frustrations. Large Integers loading as exponentials

Thom A - Wednesday, March 15, 2017 9:13 AM
Hmmm, frustrating that it doesn't replicate at your end then. Out of interest how are...

March 15, 2017 at 10:01 am

#1933281
RE: More "ACE" driver frustrations. Large Integers loading as exponentials

Thom A - Wednesday, March 15, 2017 8:39 AM
Should of stated actually, but i'll double check, the problem was in the ClaimNumber column,...

March 15, 2017 at 9:04 am

#1933267
RE: More "ACE" driver frustrations. Large Integers loading as exponentials

Thom A - Wednesday, March 15, 2017 7:17 AM
Hi Phil,
Hopefully this is everything you need. please do tell me if you need anything...

March 15, 2017 at 8:33 am

#1933261
RE: Single quote for cross apply to use dynamic DBname

There's a technique to this.
1) Start with your original SQL & do a global replace of ' with ''.
2) Put a single ' at the start...

March 15, 2017 at 6:00 am

#1933213
RE: More "ACE" driver frustrations. Large Integers loading as exponentials

Thom A - Wednesday, March 15, 2017 2:52 AM
It does look like in my post, sorry. i was making the topic again...

March 15, 2017 at 5:42 am

#1933210
RE: More "ACE" driver frustrations. Large Integers loading as exponentials

Thom A - Tuesday, March 14, 2017 10:36 AM
Thought you might be the one to reply Phil ;). And ha, you don't...

March 14, 2017 at 12:19 pm

#1933114
RE: Are the posted questions getting worse?

drew.allen - Tuesday, March 14, 2017 10:15 AM
I applied for a job yesterday, and they sent me a SQL test to take. I...

March 14, 2017 at 10:25 am

#1933069
RE: More "ACE" driver frustrations. Large Integers loading as exponentials

Thom A - Tuesday, March 14, 2017 9:28 AM
Ok... well I just made a topic and I never appeared, that's really really annoying...
I'm...

March 14, 2017 at 10:21 am

#1933067
RE: Refresh table data from Prod to UAT

SQL!$@w$0ME - Monday, March 13, 2017 10:43 PM
Phil, I don't need a database refresh. Just looking for best options to copy/sync table data...

March 14, 2017 at 5:48 am

#1933010
RE: Refresh table data from Prod to UAT

SQL!$@w$0ME - Monday, March 13, 2017 4:19 PM
Hello Folks,
What is the best approach to refresh UAT table from Production. Tables have foreign...

March 13, 2017 at 5:18 pm

#1932976
RE: SSMS Issues with Intellisense and switching query windows

Here's mine:
I've never even stopped to think about why they quote IE version in this list. I have 11.576 installed.

March 13, 2017 at 4:14 pm

#1932971
RE: SSMS Issues with Intellisense and switching query windows

bartedgerton - Monday, March 13, 2017 3:59 PM
Does anyone else experience constant problems with switching between multiple query windows and having text...

March 13, 2017 at 4:05 pm

#1932966
RE: Excel Import - Truncation Error

ZZartin - Monday, March 13, 2017 1:54 PM
homebrew01 - Monday, March 13, 2017 12:27 PM
A...

March 13, 2017 at 2:23 pm

#1932958
RE: Prevent Loading bad data into Table from excel spreadsheet

komal145 - Monday, March 13, 2017 11:31 AM
Yes, Script task need to validate the excel file columns and if everything is good...

March 13, 2017 at 12:38 pm

#1932944

Viewing 15 posts - 5,806 through 5,820 (of 13,874 total)