Topics
Started by
Posts
Last post
I have the following: INSERT INTO TableB VALUES(COL1, COL2,....) OUTPUT INSERTED.COL1 INTO AUDITTab…
5 replies
Hi all I have a date which is in a text file which looks like this '25/02/12 11:39:34' I have been …
3 replies
Hello everyone I am working on a problem where I need to compare the data in two tables. I can have…
6 replies
Good day Gents, I have been trying on how to do this but i seems cant to think well of how to get t…
4 replies
This must be much simplier than I'm making it... I have an unique idenifier for a person, and a spa…
3 replies
I want to call all of my heading from table A and call my select statements from Table B. TABLE A I…
7 replies
Guys, I have a requirement as follows: CREATE TABLE #temp (CallDate DAtetime, Talktime INT, ID INT,…
4 replies
Hello all. I am trying to select computer names from a number of tables and display them ordered. …
6 replies
I have task in hand to clean up production database by deleting unused objects. i am thinking to us…
3 replies
I am looping through all the databases for a table and trying to insert data into two columns in th…
16 replies
I have read a few posts on how to shrink TempDb but I am not even sure if "Shrink" is what I need t…
20 replies
Hi all. Database newbie. I have a one off requirement to rename all our computers on the domain. …
4 replies
Hi, Say I have the following A list of codes in a temp table ‘A’ ‘B’ ‘P’ ‘V’ ‘X’ ‘Y’ ‘Z’ And I have…
30 replies
I need a query to show all tables in a database sorted by last datetime queried ordered oldest firs…
13 replies
How can I accomodate DUP keys where Case Sensitive values should distinguish the 2 rows. Example, I…
5 replies
Viewing 15 topics - 4,171 through 4,185 (of 10,647 total)
You must be logged in to create new topics.