SQL Server Newbies

• Topics

  Started by

  Posts

  Last post

• A batch file that produces a csv file

  I'm not sure which forum I needed to post this question in so I decided to start here. I've created…

  J M-314995

  3 replies

  14 years, 4 months ago

  By: Jeffrey Williams

• Multiple "Top 1"'s

  I have a table containing kWh's where each new row increments in value every 1 minute so the data o…

  brett.y

  2 replies

  14 years, 4 months ago

  By: Jeff Moden

• Use of Cursor

  Hi Having searched for 'Using an Update Cursor in SQL' and only receiving replies that state that a…

  terrykzncs

  7 replies

  14 years, 4 months ago

  By: Jeff Moden

• Row to Colums - please help a Newbie

  Hi, Please help - I have tried to find a solution but with no success - I have the below data: Empl…

  vilonel

  7 replies

  14 years, 4 months ago

  By: Jason Selburg

• Retrieving Data

  FIRSTNAME LASTNAME CHECK DATECHECK NO AMOUNT Mickey Mouse4/20/201110001 …

  kdford10

  8 replies

  14 years, 4 months ago

  By: Jeff Moden

• Order of Tables in a Query

  Hi I know that SQL joins tables from left to right, but in what order should we join tables for the…

  terrykzncs

  14 replies

  14 years, 4 months ago

  By: Gail Shaw

• Multiple OR's and a single AND

  Please forgive my ignorance i bet there is an easy way to this but I cant figure it out. I am runn…

  xxxxxx

  18 replies

  14 years, 4 months ago

  By: Duncan Pryde

• How do they do that?

  Wondering if someone could shed some light. I regularly imoprt data fom a flat file to a table. P…

  xxxxxx

  3 replies

  14 years, 4 months ago

  By: Chrissy321

• little help required

  Hi, I was hoping I could get a answer to my stupid question. I have this query: SELECT DISTINCT …

  xxxxxx

  1 replies

  14 years, 4 months ago

  By: Johan Bijnens

• Creating a new View - Combining columns

  Dear all, I'm fairly new to SQL. I have created a new view (nominal_narratives), which contains th…

  matt_scott1984

  5 replies

  14 years, 4 months ago

  By: Ninja's_RGR'us

• Some kind of DR / backup solution ???

  Hi, I have been asked to provide some sort of disaster recovery for our payroll system which has da…

  davegoree

  13 replies

  14 years, 4 months ago

  By: jitendra.padhiyar

• Dbcc indexdefrag

  Hi Am new to sql serever .. i hv a backp of my prod db ..i need to do defrag the undex fo my prod d…

  yentha.valla

  3 replies

  14 years, 4 months ago

  By: John Mitchell-245523

• How can I trace if data is being removed

  Hi, Background: We have an app built on a SQL server database with a web interface front end. The f…

  maverickza

  6 replies

  14 years, 4 months ago

  By: maverickza

• Hide column data from a 3rd party reporting app??

  Hi - Is it possible to hide the data in a column from a 3rd party reporting application? I cannot …

  reefshark

  6 replies

  14 years, 4 months ago

  By: sachnam

• Conversion failed when converting the varchar value int.

  Hi I have data in a table which is laid out awkwardly. I think I have a solution using a CASE state…

  paul.beattie

  2 replies

  14 years, 4 months ago

  By: paul.beattie