UPDATE tableA
SET Colname = tableB.Column FROM tableA , tableB
WHERE tableA.COLID = tableB.COLID
HOpe this will help you as i understand.... Thankyou
MrMob
Last Activity: Sep 5 '13, 10:17 AM
Joined: Jan 6 '10
Location:
-
Adding Active Directory User as Sql server users
Dear
i want to add active Directory users to as Sql server 2005
users and sql authenticated users..
so that i don't have to create users twice for sql server 2005 as well.
and that userid and password can be use to login from the sql server 2005 also
Best possible replies
are most Welcomed..
Thankyou.. -
I have heard of some Malware doing to stop that ping request.
I suggest you dowload the COMBOFIX its a tool it will help you.
to solve your Problem..Leave a comment:
-
make the Share Folder from the window server what ever it is and the Then add the user on the security Tab of the folder To whom you want to Authenticate ...
Thankyou..Leave a comment:
-
Adding Active Directory User as Sql server users
Dear
I have Window server 2008 as High end server As domain..
and i have more than 200 users on AD(Active Directory)
And again i have sql server 2005 ...
so what i want is i want to add all the Active Directory user as Sql server Authenticated users. on sql server 2000
Your help will be Very much Appriciated..
Thankyou.. -
Sql pivoting dynamically
Below is the table Data
DOA POL Prem SA
2010-07-18 00:00:00.000 6 32829.00 554000.00
2010-07-20 00:00:00.000 9 63786.00 1053000.00
2010-07-21 00:00:00.000 9 31681.00 704000.00
2010-07-22 00:00:00.000 1 292514.00 5806000.00
2010-07-25 00:00:00.000 2 17924.00 326000.00
I WANT IT AS:
Dynamic Pivoting..
YEAR 07/18/2010 07/20/2010 07/21/2010... -
How to protect folders and contents from active directory centrally?
Dear SIr.
I want My Important Files to be Password protected from the Active Directory centrally..
Window server 2003
When ever the User tries to copy the Folder and its contents its should as for the administrator Password..
Help me to Protect My Documents..
Thankyou.. -
How to setup replication between different Domains?
Dear,,
I have differnt Domain and i want to do replication... in sql server2000 i went through different guides.. but couln't find any to help me..
----------
Help to do resolve.... -
How to setup real time data replication to head office SQL Server
I have more than 20 Branches Client SQL server 2000 and I want to do replication to the Head Office
How could i do it..
HOw could i do transactional Replication to the Head Office Sql Server 2000
I have register every of the Client to Sql Enterprise Manager.
I want to have real time data replication to head office Sql server.
Can i have any Step wise Process to
DO It..
Best Regards.... -
Accessing The Router
Can i access the Fortigate Router From
MSDOS..
Help me Work dos with Fortigate.. -
how to call dll file from sql server 2005
Thanks For the POST
Richard..
I will be Happy Enough i get any Clue to use
the Dll File and it Function..
iN sql server 2005
with some good Examples..
Thankyou..
Your Follower..
MrMob...Leave a comment:
-
how to add in column on each day to as on day...
Plz Sir..
WIll you Little Elaborate more clearly with some life good Examples..
I would be glad Enough to solve it..
Thankyou.
Your Disciples..Leave a comment:
-
how to add in column on each day to as on day...
Hellow Sir,
when i group with DATE from the Table it shows this result...
DATE Amount
04/01/2009 100
04/03/2009 200
04/04/2009 300
04/05/2009 400
04/06/2009 500
04/08/2009 -700
04/09/2009 800
04/10/2009 1000
04/12/2009 200
04/13/2009 50
04/14/2009 200
04/15/2009 300
04/16/2009 400
04/17/2009 500
BUT... -
SQL SHOWING DAY TO DAY IN HAND Transaction...
when i group by from the Table it shows this result...
DATE Amount
04/01/2009 100
04/03/2009 200
04/04/2009 300
04/05/2009 400
04/06/2009 500
04/08/2009 -700
04/09/2009 800
04/10/2009 1000
04/12/2009 200
04/13/2009 50
04/14/2009 200
04/15/2009 300
04/16/2009 400
04/17/2009 500
BUT i need to get the Result as Below...... -
no the Packages don't get affected what ever the OS environment is...OfCourse until it is a Window environment.Leave a comment:
-
How to call DLL file from sql server 2005
How to call a DLL file from sql server 2005
and how to use it function.... using sql server 2005 -
SQL SHOWING DAY TO DAY IN HAND Transaction...
when i group by from the Table it shows this result...
DATE Amount
04/01/2009 100
04/03/2009 200
04/04/2009 300
04/05/2009 400
04/06/2009 500
04/08/2009 -700
04/09/2009 800
04/10/2009 1000
04/12/2009 200
04/13/2009 50
04/14/2009 200
04/15/2009 300
04/16/2009 400
04/17/2009 500
... -
Update a thousand rows with specific value
I would like to update thousand of Rows with its specific value
Suppose i have a table XYZ and ABC
XYZ contains Code,Name,RegDa te And ABC also Contains the same
but the Value of RegDate of XYZ is Different than that of ABC..
i want to update XYZ's RegDate Value From the value of RegDate of table ABC
at once...
update XYZ set RegDate= -
Well That was not a Good Response
I asked any of you if we can Call a DLL FUNCTION.. on the sql Server 00/05 and how to use it.
Yes i have .DLL File which sends sms i want to call that to SQL server to USE IT..
and OFCOURSE i know SMS and SQL both starts... with CapitaL S...
and LEAVE THE REST ME... I WILL DO IT MYSELF...
Yeah and i too Know that They BOTH are apple and orange. I too like them .. whatEver...Leave a comment:
-
i want to send sms from SQL SERVER 2000 or 2005
Can i send SMS From sql server 00 or 05 ..
Can i call DLL FUNCTION IN SQL SERVER 00 or 05 ..
and how to use it..
if Please help me do this..
No activity results to display
Leave a comment: