Viewing 15 posts - 1,441 through 1,455 (of 2,647 total)
sqlfriends (3/8/2012)
SQLKnowItAll (3/8/2012)
March 8, 2012 at 2:43 pm
piotrka (3/8/2012)
ckellyWhere did you get the screen shots ? It doesn't look like SSMS
Who said the OP is using SSMS? Could be any 1 of many 3rd party GUIs.
March 8, 2012 at 2:22 pm
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...
March 8, 2012 at 2:20 pm
Check out Jeff Moden's splitter to do this: http://www.sqlservercentral.com/articles/Tally+Table/72993/
March 8, 2012 at 1:42 pm
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...
March 8, 2012 at 1:39 pm
SELECT
Product,RDate,Quantity,OnHand,NumberofDates
FROM #Final
WHERE CASE
WHEN NumberofDates >1 THEN (OnHand - Quantity) >=0
ELSE ' '
END
Is exactly the same as scripting:
SELECT
Product,RDate,Quantity,OnHand,NumberofDates
FROM #Final
WHERE X
See, it doesn't make sense. ...
March 8, 2012 at 1:31 pm
er.sivaganesh (3/8/2012)
from table one we are getting contacttype int value only
Until you give me better data and a better sample, I can not help you. Right now, your...
March 8, 2012 at 1:25 pm
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...
March 8, 2012 at 1:20 pm
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
March 8, 2012 at 1:16 pm
er.sivaganesh (3/8/2012)
bala is the sample insert data for table 2 depend upon contact type 1
Ok, given what you have given me I guessed at sample data....
March 8, 2012 at 12:52 pm
er.sivaganesh (3/8/2012)
accontid contacttype ...
March 8, 2012 at 12:46 pm
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...
March 8, 2012 at 12:44 pm
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...
March 8, 2012 at 12:37 pm
junkid1376 (3/8/2012)
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...
March 8, 2012 at 12:27 pm
Viewing 15 posts - 1,441 through 1,455 (of 2,647 total)