SQL Server Newbies

• Topics

  Started by

  Posts

  Last post

• Need help with a query ALL rows in column must meet condition

  Hi I need help with this query I only want the query to return rows that ONLY have ABC, DEF, GHI, b…

  rourrourlogan

  3 replies

  9 years, 11 months ago

  By: J Livingston SQL

• Selecting everything that doesn't exist based on a result set for each result of a different set.

  Hi all, This is my first post so bare with me, I'm a newbie. What I'm trying to do is this: I h…

  JimiHaze

  2 replies

  9 years, 11 months ago

  By: JimiHaze

• replace same more then one character in one column sql query

  Replace same more then one character in one column in sql. Data column: 'BLACKHEATH 0AA BLACKHEATH…

  mr.addikhan

  15 replies

  9 years, 11 months ago

  By: Luis Cazares

• How to find the first, last and the Highest (Peak Value) in a list

  Hi all, I have a column in a table which holds list of values. I would like to find the first value…

  ITU_dk2012

  46 replies

  9 years, 11 months ago

  By: Lynn Pettis

• Splitting Parent Table Data into Several Tables

  Hi, I'm in the process of putting data from a large table into several smaller tables. In the proce…

  cajun_sql

  2 replies

  9 years, 11 months ago

  By: cajun_sql

• Count How Many Users are Logged IN Per Day

  deleting topic....

  danny.delgado 65386

  4 replies

  9 years, 12 months ago

  By: danny.delgado 65386

• how to find out last refresh date

  Hi all, We're using SAN level replication to create a copy of production on daily basis. Is there a…

  RightOnTarget

  1 replies

  9 years, 12 months ago

  By: SoHelpMeCodd

• trapping error

  Hello, I would like to implement a logic that will allow me to switch to prod server if replication…

  RightOnTarget

  1 replies

  9 years, 12 months ago

  By: SoHelpMeCodd

• Merging Data from two source into one destination table

  How do I merge data from two source tables into one destination table? (Note that the two source …

  EMtwo

  2 replies

  10 years ago

  By: Y.B.

• Data base testing sql query

  HI I am a part of database testing team. I have imported a text file (for example -tables.csv file)…

  anusuyashivhaani

  4 replies

  10 years ago

  By: anusuyashivhaani

• UDF to Sort Column Values into one Concatenated Key Field

  Hello - New to SQL Server. Have a lot of MS Access experience and know how to do this task in Acce…

  BoricuaSC

  21 replies

  10 years ago

  By: x

• First date of the Month (to date on Range basis)

  Hi Team, Help to get the Sql Query e.g when execute on 8/15/2015 get the records from 8/1/2015 to…

  smer

  15 replies

  10 years ago

  By: Jeff Moden

• Comparing two tables to find matching column names or missing columns and datatype

  Comparing two tables (on the same database) to find matching column names or missing columns which …

  azdeji

  12 replies

  10 years ago

  By: johndbdeveloper

• When FORCED Parameterization does not work

  Hello! Here is the situation: - the database has the Parameterization set to FORCED - if i run a qu…

  ioana-477197

  4 replies

  10 years ago

  By: Grant Fritchey

• Restore only changed

  Hi all! I am programming using a pretty big SQL DB. Every time i want to check my programming, I ha…

  Edvard Korsbæk

  5 replies

  10 years ago

  By: Grant Fritchey