SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Insert data into Table variable but need to insert 1 or 2 rows depending on data

  Hi I am writing a query to return some production data. Basically i need to insert either 1 or 2 ro…

  rooty1964

  1 replies

  11 years, 2 months ago

  By: ScottPletcher

• How do we generate csv with custom data?

  It might be an old question but wanted to see, if we have any latest techniques (other than bcp). S…

  sarath.tata

  3 replies

  11 years, 2 months ago

  By: sarath.tata

• Querying Last Quarter's data

  We have this query that pulls number of days worked from the current Quarter to Date. (SELECT C…

  kgomez 94889

  1 replies

  11 years, 2 months ago

  By: ScottPletcher

• Arithmetic overflow error converting nvarchar to data type numeric.

  hello when i run the following sql query: "update table set price = price * 1.1 " i get the followi…

  duro654321

  10 replies

  11 years, 2 months ago

  By: Don Bernstein

• Sql query need to be updated as group by

  Dear Team, I have a query: select [@abc_prj_att].U_Empid as 'SAP ID',OHEM.U_IQId as 'Iqama No', isN…

  mohammedaala

  4 replies

  11 years, 2 months ago

  By: mohammedaala

• SSIS Expression on getting the specific files

  Hello, I am developing the SSIS and stuck on copying specific files. 1. We receive CSV file to our …

  Tamrak

  1 replies

  11 years, 2 months ago

  By: Alvin Ramard

• Resolving Data Drift

  Hi All, First let me apologize that this is a broad question, but it's legitimate none the less. We…

  Xedni

  4 replies

  11 years, 2 months ago

  By: Xedni

• Last Table READ and WRITE

  Hi there - How would I find the last read/write dates for all the tables within a database. Thanks…

  arrjay

  6 replies

  11 years, 2 months ago

  By: Grant Fritchey

• Restore to Point in Time DURING Differential Backup

  We have a 1TB Database. Our backup strategy looks like this. Weekly Full backups - Saturday 10pm. …

  lbrady

  8 replies

  11 years, 2 months ago

  By: lbrady

• Trying to insert results from sp_spaceused (tablename) into different table.

  Hi SQL gurus I am trying to track space of a table of Adventureworks and like to insert into a tabl…

  Dan121

  6 replies

  11 years, 2 months ago

  By: Dan121

• Storing Images in Database

  Hi, I want to store Images as binary data in SQL table and compare it each time with a image file I…

  SQL.AP

  4 replies

  11 years, 2 months ago

  By: Lowell

• splitting paramarray into groups of four with an offset

  ok here's an interesting one that just hit my workspace. i'm getting a file that essentially has a …

  Lowell

  2 replies

  11 years, 2 months ago

  By: mister.magoo

• Remove the double quote

  Hi, i have a SQL select syntax as below 0 AS SalaryMin, 2088 AS SalaryMax, 2088…

  kennyhuang0108

  7 replies

  11 years, 2 months ago

  By: Jeff Moden

• SQL Server 2008 Error Log

  I am getting 2 to 3 error messages per minute about Error: 512 (Subquery returned more than one res…

  para40tn

  7 replies

  11 years, 2 months ago

  By: SQLRNNR

• Test if each subset meets requirements

  CREATE TABLE #tblTemplateBlocks ( TemplateID int, BlockID int, Orde…

  webskater

  9 replies

  11 years, 2 months ago

  By: webskater