SQL Server Newbies

• Topics

  Started by

  Posts

  Last post

• Selecting from four columns in different table

  how can we select from TabLa A,Table B Table C and Table D Table 1 has columns A B C ( A is the f…

  SQLTestUser

  3 replies

  14 years, 11 months ago

  By: SQLTestUser

• Is there any easy way to find out how many times a function is called in a procedure

  I also need to find out how often the function is used on the server

  cdurose

  6 replies

  14 years, 11 months ago

  By: sturner

• Insert duplicate records into an alternative table

  Insert duplicate records into an alternative table I need an insert script that selects records fro…

  Maina-456685

  4 replies

  14 years, 11 months ago

  By: Maina-456685

• DTS

  how to move data from DTS to SSIS? If u upgrade 2000 server to 2005 server?

  bala2

  1 replies

  14 years, 11 months ago

  By: Gail Shaw

• SQL Query of last records(timestamp) for Distinct CategoryId's in same table.

  I have a table of Activities. Table Activities: Id Int Identity CategoryId Int Activity nvarchar(25…

  slacoste

  6 replies

  14 years, 11 months ago

  By: VinceV

• Get listing of all login accounts for an instance(Windows auth. and Sql Server auth.)

  How can you get a list of all the accounts for an instance? Is it also possible to get a listing of…

  rmatthias001

  4 replies

  14 years, 11 months ago

  By: rmatthias001

• I inherited this report. Its way above my head!!

  Hello SQL Gods! I inherited this report. I just started to learn SQL, and it’s a way above my head.…

  davidskreczko

  2 replies

  14 years, 11 months ago

  By: davidskreczko

• Reading filesystem and populating the table

  Hi I am trying to create a SSIS package that read the filesystem and populates a table with the f…

  shashi_1409

  2 replies

  14 years, 11 months ago

  By: shashi_1409

• Sql report - inactive suppliers

  Hi all, I'm writing a report on inactive suppliers, just not sure how to approach it correctly. I'm…

  dallas-1069889

  3 replies

  14 years, 11 months ago

  By: dallas-1069889

• Putting together into one script

  Hi Everyone, I need help in putting together this 4 part of script into one script so I can load in…

  S7

  3 replies

  14 years, 11 months ago

  By: Shanalise

• Function

  Can a function update data? Example: Update mytable set fld = fld + 1 Mike

  mike 57299

  3 replies

  14 years, 11 months ago

  By: Shanalise

• selecting values from two columns with values that enclose each other

  I have two tables. Table 1 has 3 columns with values in only 2 columns: from tocode 23 34 46 6…

  otanii

  4 replies

  14 years, 11 months ago

  By: otanii

• SQL Server File Placement Best Practice

  Hi everyone, I new to SQL Server (currently working with Oracle). I've been tasked with setting up…

  oracle_dba_newbie

  17 replies

  14 years, 11 months ago

  By: george sibbald

• SQL Server 2008 Database - data coming from three different systems

  Hi all, I am building a solution in SQL Server 2008 using SSIS services. I need your expert advice…

  vpatel1981

  3 replies

  14 years, 11 months ago

  By: Alvin Ramard

• How to get unique value from a records from multiple columns

  I have an issue that i'm trying to figure out. I have a record set, see example below, that is a l…

  mbender

  8 replies

  14 years, 11 months ago

  By: Brandie Tarvin