SQL Server Newbies

• Topics

  Started by

  Posts

  Last post

• Nvarchar(Max) vs text in sql server 2000

  Good Afternoon Guys, i am currently using the varchar(Max) in storing a large chunk of string in th…

  Stylez

  2 replies

  12 years, 11 months ago

  By: Stylez

• correct syntax for a nested select statement using the SUM function

  I need to write a query to add up the bills sent to each client in a specific time period. Each cl…

  sjerromeharris

  3 replies

  12 years, 11 months ago

  By: ChrisM@Work

• How to loop through dataset to identify and flag duplicates

  Hi, I have a job on to identify duplicate leads in a single dataset based on whether or not the cre…

  iain.nelson

  4 replies

  12 years, 11 months ago

  By: iain.nelson

• Cannot insert data into SQLServer table linked in MSACCESS db

  Dear all, I am trying to configure an MSACCESS db to link a table from SQL server and enable the us…

  dimsandwich

  10 replies

  12 years, 11 months ago

  By: mayuri312

• Write a query to get the detail data from the summary data

  I have the function which gives the summary data. Now I want the detail data from that summary data…

  deepeshdhake

  1 replies

  12 years, 12 months ago

  By: Lynn Pettis

• column to calculate the balance stock dynamically

  I have a table as shown below and would like to have the balance quantity which should be dynamica…

  mathewspsimon

  19 replies

  12 years, 12 months ago

  By: Dwain Camps

• ODBC - connection to sublist failed.

  I used the Access upsize wizard to split my database. I still wish to use the Access for the fronte…

  jane.frasier

  1 replies

  13 years ago

  By: Sean Lange

• Maintenance Cleanup Task can't delete trc files

  Hi, I've created a maintenance plan with a Maintenance Cleanup Task as a subplan. In this Maintenan…

  allamiro

  4 replies

  13 years ago

  By: louislamour2673

• Restore database problem in SQL 2008

  Error encountered: RESTORE HEADERONLY is terminating abnormally. (Microsoft SQL Server, Error:3241)…

  gracey

  1 replies

  13 years ago

  By: Ant-Green

• convert xls templates into rdl files

  Hi, I'm given my report requirements (Labels, layout, columns, tables) as an excel template which I…

  usman.ghani2

  1 replies

  13 years ago

  By: haigemini

• Longest running queries/processes in SQL.

  Hi Guys, I need a script to identify the longest running queries/processes in SQL. Thanks in advanc…

  gracey

  3 replies

  13 years ago

  By: 2ndHelping

• Changing Windows Domain on SQL Server 2005

  Hi Folks The powers that be around here are about to change the domain name that a windows 2003 r2 …

  JC-3113

  5 replies

  13 years ago

  By: Stuart Davies

• Automate alerts for database blockings.

  Hi Everyone, Just want to ask if anyone have "script" or jobs that will automatically check databas…

  gracey

  2 replies

  13 years ago

  By: Dwain Camps

• Domain Error

  Hello. Executing the following; select power((((12*5.26)-69.26)/100),1.58) i got the following erro…

  igngua

  2 replies

  13 years ago

  By: igngua

• Error getting when importing data from Excel Sheet to Sql Server 2008

  Hi All, I want to import data from Excel Sheet to Sql Server 2008 DB. For that i created 2 columns …

  venkidesaik

  1 replies

  13 years ago

  By: Ant-Green