LOVE the pic Lowell!! Your code rocks too, btw.

Oh, and I would like to request that the OP makes whomever designed that system to drop and give me 20!!!...

That sure would seem to be the process to me also, but like you I don't know that that is documented explicitly anywhere. Edge cases like that usually don't...

Lowell, you are a better man than I this morning (or perhaps my caffeine hasn't fully kicked in yet)! Without sample output I can't make heads or tails of...

Web search is your friend. I searched Google for the words

ssms login other domain user

and came up with a number of references to using the windows Run As...

mpradeep23 (2/10/2014)

---

Hi

i have table called t1

with column name offers with data as

"entitlementwrapper" : [ {

"Type" : "Factory Warranty",

...

Do you really think you gave us enough to go on with that short one-liner to be able to assist you?? No table structures, no query, no error message...

1) Balu, you were asked explicitly what version of SQL Server you were running this on. You posted to a SQL 2012 forum, and the code provided DOES WORK...

mpradeep23 (2/10/2014)

---

hi

i need out put as

type ...

This should be possible and is easy enough to test out once you have the 3 serves in a Windows Server Failover Cluster, which is a required starting point anyway....

Jeff Moden (2/9/2014)

---

THAT's JSON? Shoot... that's just...

Please provide several sample sets of data and the corresponding table output you expect (with column data types). That's JSON, yes?

gregory.perry2 87972 (2/8/2014)

---

I have a 1 table Transactions table

1) in this table I have the following fields

StoreNumber, CustNo, TransactionAmt, Date

I need to find out the following:

1)The sum of transactions by...

You MUST have SOMETHING on that table to use as a filter. Without that you can't possibly be getting meaningful output.

If the data does not contain a date field...

caippers (2/6/2014)

---

I'm trying to run counts for dates prior to today's date. I want to run a count from a table from the day before.

Here is what I...

Perhaps the apostrophes in the data is monkeying with something? And is it the datetime field -200 that is causing the integer error?