SQL Server Newbies

• Topics

  Started by

  Posts

  Last post

• Problem using Import Wizard on a flat file

  Hi Folks, I am having problems using the Import Wizard on a flat file. The task should be quite st…

  chris_taylor5000

  3 replies

  15 years ago

  By: torpkev

• filtering with a alias

  Hi, i was trying filtering a query with an alias, but it doesn't work select a,b, (select count(*) …

  Cristian Maidana-360609

  5 replies

  15 years ago

  By: Cristian Maidana-360609

• Partitioning question

  Is Partitioning supported in SQL Server 2005 Standard edition Thank you, Pradeep

  PradeepVallabh

  1 replies

  15 years ago

  By: PaulB-TheOneAndOnly

• Update Beginning Inventour with Ending Inventory from previous Record

  Here's my senario, I have a table that is updated everyhour with the previous hours data.. Anyway …

  stevenplee

  1 replies

  15 years ago

  By: Dan.Humphries

• Import to SQL from VFP table programmatically

  I'm getting an error pointing to the last ')'; however, that may not be the real problem. Anyone kn…

  jesuslives01

  6 replies

  15 years ago

  By: jesuslives01

• Display Dates with leading zero

  Hi all I have date data that is stored as integers in 3 sperate columns e.g. IntYear (2009), IntMo…

  cdex3-408940

  2 replies

  15 years ago

  By: cdex3-408940

• THANK YOU SQL SERVER CENTRAL!!!!

  I like to thank everyone in SQL Server Central for your excellent articles, giving advices on best …

  le_billy

  5 replies

  15 years ago

  By: WayneS

• I need help reducing redundant records

  Can anyone tell me where my error is, this query should be retreiving one data set for each "OCC_Ti…

  grasspicker61

  5 replies

  15 years ago

  By: Steve Jones - SSC Editor

• Error on creating a stored procedure

  Hi, I have the stored proc that I am creating but recive an error : Msg 102, Level 15, State 1, Li…

  s_shah-977123

  2 replies

  15 years ago

  By: s_shah-977123

• Capture the name of the "current" table as a field on a Union query

  Hello, all. I receive, routinelly, Excel files that I have to import into my DB. I have to populate…

  LHumberto

  3 replies

  15 years ago

  By: LHumberto

• Primary Filegroup

  Hi, I' m relativly new as SQL Server DBA. I've question about standard installation of a SQL Server…

  DBASam

  6 replies

  15 years ago

  By: Johan Bijnens

• What are the daily DBA administrator tasks

  I have been IT field more than 10 years now -- mostly Networking and Server administration (both Li…

  zakariye88

  8 replies

  15 years ago

  By: zakariye88

• how to get the results of a subquery as a commaseparated list

  We have a database which contains informations about files. Each file can have from zero to unlimit…

  Karl-452938

  10 replies

  15 years ago

  By: Jeff Moden

• scheduling stored procedure after every 30 min

  i am using sql 2008 and i want to schedule a stored procedure . i want my sp to run after every 30 …

  scottichrosaviakosmos

  2 replies

  15 years ago

  By: VastSQL

• scheduling stored procedure after every 30 min

  i am using sql 2008 and i want to schedule a stored procedure . i want my sp to run after every 30 …

  scottichrosaviakosmos

  1 replies

  15 years ago

  By: WayneS