SQL Server Newbies

• Topics

  Started by

  Posts

  Last post

• Adding data to multiple excel sheets

  Hi Guys I have a package that imports data from multiple text files in a folder and inserts them in…

  jmlsauls

  3 replies

  14 years ago

  By: jmlsauls

• DBMail, SQL Agent, Maintenance Plans, and sending an attachment to a specific email list...

  Hello - I have a process that I am trying to automate through SQL Server 2008 R2 via DBMail and SQ…

  SQL_ME_RICH

  1 replies

  14 years ago

  By: BuntyBoy

• Need Query Help....

  Hi, I have table EmpID EmpName MgrID 1 Indraneel NULL 2 Natraj …

  indraneelandhavarapu-866099

  4 replies

  14 years ago

  By: Arjun Sivadasan

• SA password not getting changed

  I have tried to change SA password using login who was having sa rights... I tried through SSMS. by…

  Sgar...

  4 replies

  14 years ago

  By: Sgar...

• query for sorting startdatetime and enddatetime

  How to create a query for my problem? example : ID stardatetime …

  californication2704

  19 replies

  14 years ago

  By: Gail Shaw

• Sort by AM/PM

  Hello SQL World, I am having issues with sorting a time column by AM/PM. My column has the times li…

  Marv_SQL

  5 replies

  14 years ago

  By: Sean Lange

• ola hallengren CheckDB help

  Hi, Im trying out the ola.hallengren.com scripts for indexing and db integrity. Getting to run dbc…

  Staggerlee

  1 replies

  14 years ago

  By: Ola Hallengren

• Bulk Insert with Dates

  Hi All, I have a bulk insert procedure which i use a fair amount. It does the job well. (below) How…

  Rixxe

  9 replies

  14 years ago

  By: Rixxe

• BCP Error :(

  Hi I am trying to create a bcp command to export data from a sql server table to text file I have …

  Sgar...

  2 replies

  14 years ago

  By: Sgar...

• newby wants to create a sequencial Alpha numeric value

  I would like to know if anyone has experience creating an auto alphanumeric row identifier. I am w…

  johnwh-1128731

  4 replies

  14 years ago

  By: johnwh-1128731

• Pull out month and year

  Im using the below quiery to get the first day on the previous month. If I run it now I get the re…

  xxxxxx

  10 replies

  14 years ago

  By: Jeff Moden

• Combine these 2 UPDATE scripts

  I would like to combine 2 conditional update scripts into 1 if possible. They are below. One upda…

  lgoolsby 86333

  1 replies

  14 years ago

  By: Ninja's_RGR'us

• Combining results into one data row

  Hi I've developed a stored proc in SQL 2005 that produces results for each customer based on variou…

  francis.rider

  2 replies

  14 years ago

  By: francis.rider

• Inserting summarized data

  Hi everyone. I have a store procedure that has a summary query that return 4 rows but only inserts …

  troe_atl

  42 replies

  14 years ago

  By: troe_atl

• I want to list all user databases size in central managemnet server

  I tried in many ways...but its showing for only one instance..... Can anyone please specify exact …

  Sgar...

  3 replies

  14 years ago

  By: Sgar...