SQL Server Newbies

• Topics

  Started by

  Posts

  Last post

• Delete old rows from all tables in a database

  We use SQL to log lots of values from our process plant (a power station) which can be pulled back …

  JamesGibb

  7 replies

  14 years, 10 months ago

  By: Jeff Moden

• SSRS --The server doenot exist

  Hi all, I have created a SSRS report and want to deploy it in our test server. So i did select prop…

  srilu_bannu

  11 replies

  14 years, 10 months ago

  By: srilu_bannu

• What other ways is there to do this?

  hi.. Doing this With MyTable AS (SELECT <fields> FROM <table>) IF @var1 = 1 BEGIN …

  Digs

  7 replies

  14 years, 10 months ago

  By: PaulB-TheOneAndOnly

• Running index based on previous row

  IF OBJECT_ID('TempDB..#mytable','U') IS NOT NULL DROP TABLE #mytable CREATE TABLE #myTable( num INT…

  Digs

  9 replies

  14 years, 10 months ago

  By: ChrisM@Work

• How to calculate difference in value from previous row

  IF OBJECT_ID('TempDB..#mytable','U') IS NOT NULL DROP TABLE #mytable CREATE TABLE #myTable( …

  Digs

  9 replies

  14 years, 10 months ago

  By: Johan Bijnens

• BCP Help

  Hello All I am running a BCP command to create a csv file from a SQL table, but when I am outputtin…

  bicky1980

  12 replies

  14 years, 10 months ago

  By: bicky1980

• Transpose rows into columns

  I have a situation I have two tables First Id DateTime TAGA TagA_Qualyty TAGB TagB_Qualyty 1…

  jeff.henrique.tatsoft

  14 replies

  14 years, 10 months ago

  By: Dave Ballantyne

• Unistall Instance (and other issues)

  I just discovered that I have an instance each of SQL Server 2005 Express and SQL Server 2008 Expre…

  goodguy

  3 replies

  14 years, 10 months ago

  By: Meet George Jetson

• SQL QUERY

  SELECT "TASKS"."HOURS", "TASKS"."WO_NUM", "TASKS"."DEPT_NUM", "TASKS"."REQUEST", "TASKS"."CLSDDATE"…

  davidshephard

  6 replies

  14 years, 10 months ago

  By: davidshephard

• Difference between Backupbuffer and BACKUP I/O wait stats

  Hello, Maybe it's a big noob question, but can anybody tell me the difference between the Backupbuf…

  tim.hartman

  2 replies

  14 years, 10 months ago

  By: tim.hartman

• Need to return exceptions data from a one-to-many

  I've been struggling and procrastinating with this for days and so any help is greatly appreciated.…

  SSSolice

  6 replies

  14 years, 10 months ago

  By: WayneS

• FTP Task

  Hi all, I have to create a ssis package to send files to oracle via http://FTP.since i am new to th…

  itskumar2004

  3 replies

  14 years, 10 months ago

  By: itskumar2004

• Lock request time out period exceeded.

  Hi, We have an application and we are receiving the below error msg from SQL Server 2005 [font="Cou…

  DCF

  4 replies

  14 years, 10 months ago

  By: DCF

• Error in using SQLXMLBulkLoad

  Hi All, I am using SQLXMLBulkLoad to insert records into a existing db (SQL Server 2005) but I am g…

  sharma.brijesh

  5 replies

  14 years, 10 months ago

  By: sharma.brijesh

• Help with Query

  I have three tables, persons ,cases and caseActivities. Each person have a case and each case have …

  SQLNeophyte

  8 replies

  14 years, 10 months ago

  By: SanDroid