Account Options

  1. Sign in
The old Google Groups will be going away soon, but your browser is incompatible with the new version.
Google Groups Home
« Groups Home
microsoft . public . sqlserver . programming
This is a Usenet group - learn more
Find or start a Google Group about programming.
Group info
Language: English
Group categories: Not categorized
More group info »
Active older topics
4 new of 4 - Apr 24
12 new of 12 - Apr 13
2 new of 2 - Mar 28
2 new of 2 - Mar 28
2 new of 2 - Mar 26
2 new of 2 - Mar 26
1 new of 1 - Mar 26
25 new of 25 - Mar 23
7 new of 7 - Mar 22
8 new of 8 - Mar 11
Discussions
View:  Topic list, Topic summary Topics 1 - 10 of 181651  Older »
Description: Microsoft SQL Server newsgroup.
 

Want to compare records in 2 databases. 
  I have two databases Database1 and Database2 Both databases have a table called acctsub The values in the table are CPNYID ACCT SUB USER1 USER2 I want to compare the two databases and see which distinct(CPNYID,ACCT,SUB) values are in Database1 but not in Database2. I am looking the UNIQUE (CPNYID,ACCT,SUB) Combos that are in one database but not in the other database.... more »
By Sammy Singh  - May 22 - 2 new of 2 messages    

Constants in session level 
  Hi! We have more frequently used constants in another database. For example: "Current_User" which represent the current logged user id. We used it in my triggers, queries, etc. I plan to port this in MS SQL server, and I want merge all users to logical level (to roles), for not use database level (real ms users).... more »
By durumd...@gmail.com  - May 22 - 4 new of 4 messages    

reduce audit table 
  I have an audit table of which one of the columns is named [when] and defined as datetime somebody has neglected doing maintenance on this table for several years now and it has grown to a huge proportion I have a script that will delete entries older than a specified date. due to the large amount of entries, it is recommended to only delete around one... more »
By Cathy  - May 14 - 4 new of 4 messages    

Convert row data to column 
  Hi Everyone, I have a table as follows S. No. Month 1 Jan 1 Feb 1 Mar 2 Apr 3 Jun 2 Jul 3 Aug I want the result as follows: S. No. Month 1 Jan, Feb, Mar 2 Apr, Jul 3 Jun, Aug The s. No. should contain unique values after concatenation of month.... more »
By Manoj Kumar  - May 11 - 4 new of 4 messages    

Help with XML update 
  I have an xml document stored in a table column that has inaccurate times in the date fields I 'd like to update all LineStartTime and LineEndTime values in the document by 15 seconds so, for instance, 2012-02-01T00:07:00 becomes 2012-02-01T00:07:15 (long story as to why it needs to be this way; it's out of my hands). There can be 1 to many transactions and each transaction can have 1 or more line entries.... more »
By gepetto_2...@yahoo.com  - May 4 - 3 new of 3 messages    

copy one DB to another 
  when my company adds a new client I need to copy an existing database into a new database. mostly table schemas and stored procs plus several lookup tables that will include the data contained in them. I would like to automate this process. where's a good place to start? tia, mcnewsw8
By mcnewsxp  - May 3 - 3 new of 3 messages    

FIGLI DI PUTTAN-ASSASSNI PAOLO BARRAI E MASSIMO DORIS HAN FATTO UCCIDERE DAVID ROSSI MPS. GLI HAN FATTO TAGLIARE LE VENE E VOLARE DALLA FINESTRA. PER UNA GUERRA DI SEO CHE VI ERA FRA IL GRUPPO MPS E I NAZI-ASSASSINI ENNIO E MASSIMO DORIS MEDIOLANUM 
  PRESSO TERRIFICANTEMENTE CRIMINALE FINTER BANK LUGANO, CHIASSO, ZURICH E BAHAMAS, DI SCIACQUONE DI SOLDI MAFIOSI E, PARREBBE PURE SCIOCCANTEMENTE PEDOFILO GIOVANNI DEI CAS DA RANCATE IN NOVEZZANO ( [link] ), RICICLAVANO E RICICLANO OCEANI DI SOLDI ASSASSINI DI COSA NOSTRA, CAMORRA, NDRANGHETA, COME STRA RUBATI DA LL, LEGA LADRONA, E PDL, POPOLO DI LADRONI:... more »
By assassinomauriziobarb...@hotmail.co.uk  - Apr 27 - 1 new of 1 message    

Convert rows into a "string of columns" 
  Using MSSQL 2008 R2 this query: SELECT tblusers.id FROM tblusers WHERE tblusers.name = 'smith' gives me a few rows: id 123 678 987 How do I convert that column into a string containing a coma separated list of the id's? Example: 123,678,987 Thanks
By and...@webmail.co.za  - Apr 24 - 3 new of 3 messages    

I have a trigger that I need to run on all application databases that are in the domain.database(Table.Coloum) of a SLSYSTEM Database, Dont want to do it manually 
  I have a trigger that I need to run on all application databases that are in the domain.database(Table.Coloum) of a SLSYSTEM Database So if I do a select databasename from domain on the system database I get the 250+ Application database name. So I want to run a Trigger SQL Script on each of the 250+ application databases.... more »
By Sammy Singh  - Apr 16 - 2 new of 2 messages    

Need: Senior Dev with experience on SQL Server Programming - Libertyville IL - 6 Months 
  The following requirement is open with our client. Title : Senior Dev with experience on SQL Server Programming Location : Libertyville IL Duration : 6 Months... more »
By ku...@asciigroup.com  - Apr 16 - 1 new of 1 message    

1 - 10 of 181651   « Newer | Older »

XML