Also, there's a City code that can get involved depending on the level of detail you want to show. For interational calls, the first 1-3 digits can be the...

Gail,

The country "Code" has to match the first 1 to 3 digits of either the ANI or the Dial_Digits. You wouldn't know that unless you've worked with Telephony Rating...

jitendrapatil2006 (4/14/2008)

---

sorry for the post as i am new to this forum therefore i made this mistake. I am reading a CSV file which contains the whole data, on reading...

Yes... SQL Server Triggers are different than a lot of other RDBMS. In Oracle, for instance, you would do just as you have done except your would add "FOR...

Ok... I admit it... I'm being a bit nasty... A "Senior Software Engineer" should know this. 😉

Not true... you can use a TEXT datatype as a parameter.

LEN does not include trailing spaces... try the same thing with DATALENGTH.

I see what you posted and I'm still not sure what you want. Can you be a bit more descriptive, please?

Cool... if that's what you actually wanted.

The spit function works just fine and doesn't miss a thing. If, however, you don't have the data in the table to match, an INNER JOIN may give the...

ORDER BY in an UPDATE is only possible in a subquery and then you would have to use TOP.

All that not-with-standing, I wish the OP would post some data and...

As Barry has shown, ROLLUP should do it. For more information, lookup GROUPING under CUBE in Books Online.

An indexed view will usually blow...

Heh... why sure it is... it'll...

Thanks, SQLBlue. :blush: Very happy it does what you want and I sure do appreciate the compliment... you made my weekend. 🙂