SSIS_Project Location Filter

Harsh

unread,

Dec 8, 2012, 11:37:43 AM12/8/12

to anand_septe...@googlegroups.com

Hey Guys!!!

Below is the Query I used to split Location column into 2 individual columns City & State. Let me know If you have any questions.

City : [Pos_Comma_Loc.] > 2 ? SUBSTRING(Location,1,[Pos_Comma_Loc.] - 1) : [Pos_Comma_Loc.] < 1 && LEN(Location) > 3 ? Location : "TBD"

State: TRIM([Pos_Comma_Loc.] > 1 ? SUBSTRING(Location,[Pos_Comma_Loc.] + 1,LEN(Location)) : [Pos_Comma_Loc.] < 1 && LEN(Location) <= 3 ? Location : "TBD")

Anu Yerokun

unread,

Dec 20, 2012, 10:29:52 AM12/20/12

to anand_septe...@googlegroups.com

hey guys, how many questions are on the 070-448 exam?

NICKESHA NIXON

unread,

Dec 20, 2012, 10:31:37 AM12/20/12

to anand_septe...@googlegroups.com

50

On Dec 20, 2012 9:29 AM, "Anu Yerokun" <ayer...@gmail.com> wrote:

hey guys, how many questions are on the 070-448 exam?

--

Anu Yerokun

unread,

Dec 20, 2012, 10:32:08 AM12/20/12

to anand_septe...@googlegroups.com

sweet!! thank u

--

kishanchandra golla

unread,

Dec 20, 2012, 11:14:53 AM12/20/12

to anand_septe...@googlegroups.com

65 questions, not more than that for sure

Sent from Kishan's iPhone 4S

On Dec 20, 2012, at 9:29 AM, Anu Yerokun <ayer...@gmail.com> wrote:

hey guys, how many questions are on the 070-448 exam?

--

Anu Yerokun

unread,

Dec 20, 2012, 11:26:24 AM12/20/12

to anand_septe...@googlegroups.com

as long as it is not 200

--

Reply all

Reply to author

Forward