sqlfriends (3/8/2012)

---

SQLKnowItAll (3/8/2012)

---

So, when you tell SSIS to use SQL Server Agent Account it is not using the domain account that you assigned to authenticate the service, it is using...

Who said the OP is using SSMS? Could be any 1 of many 3rd party GUIs.

So, when you tell SSIS to use SQL Server Agent Account it is not using the domain account that you assigned to authenticate the service, it is using the SQL...

Check out Jeff Moden's splitter to do this: http://www.sqlservercentral.com/articles/Tally+Table/72993/

SQLKnowItAll (3/8/2012)

---

sqlfriends (3/8/2012)

---

Separate, it is not a windows group. It is actually what they call a Virtual Account. As far as I know, you cannot see which domain users...

Is exactly the same as scripting:

SELECT

Product,RDate,Quantity,OnHand,NumberofDates

FROM #Final

WHERE X

See, it doesn't make sense. ...

Until you give me better data and a better sample, I can not help you. Right now, your...

sqlfriends (3/8/2012)

---

Separate, it is not a windows group. It is actually what they call a Virtual Account. As far as I know, you cannot see which domain users are...

Like this?

INSERT INTO table2

SELECT contacttypeid, contacttypeid, datas

FROM table1

OR

CREATE TABLE table2 (accountid int identity(1,1), contacttypeid int, datas varchar(50))

INSERT INTO table2 (contacttypeid, datas)

SELECT contacttypeid, datas

FROM table1

ORDER BY contacttypeid

Ok, given what you have given me I guessed at sample data....

er.sivaganesh (3/8/2012)

---

i show u the output how it should come

accontid contacttype ...

Ok, well the good news is that it works. So the remote server is allowing the connection and the data properties are set correctly. I can't help too...

Domain account assigned to MSSQLSERVER service is placed into group NT SERVICE\MSSQLSERVER

Domain account assigned to SQL Server Agent service is placed into group NT SERVICE\SQLSERVERAGENT

This is why you MUST only...

junkid1376 (3/8/2012)

---

Hi,

I am newbee and i need help in writing a stored procedure that calculates holding period for my securities (stocks). I have two tables, the first table (trade_table) contains...

I'll be here! 😉