SQL Server Newbies

• Topics

  Started by

  Posts

  Last post

• getting the sum

  Hi, I have sales type and under which i have sales for diff products and Calims under which i have…

  cpinky01

  4 replies

  15 years ago

  By: Jeff Moden

• Running SQL Script - Make certain text mandatory

  I have the following code, which shows on an ASP page. This script is ran each time a specific data…

  BruceWayne1985

  3 replies

  15 years ago

  By: Lowell

• Primary key on City Table

  Hello, I have a table of cities which include CityName, CountryCode (PK), ProvinceCode (PK). Initia…

  dtopicdragovic

  10 replies

  15 years ago

  By: Brian O'Leary

• Restoring a specific file group

  Can i restore a specific file group in SQL Server 2005???(Instead of whole backup) Regards, Pradeep

  PradeepVallabh

  1 replies

  15 years ago

  By: Steve Jones - SSC Editor

• Error converting data type varchar to float.

  Hi My Table is: CREATE TABLE NewCDN ( [Agent] char(30), [Target_Id] char(7), [Performance] varchar…

  NoviceJatt

  5 replies

  15 years ago

  By: NoviceJatt

• SSIS Project Documentation

  Hi, My SSIS project is almost done. Any suggestions,guidelines, tools ,samples and stuff for docume…

  sql_freak

  1 replies

  15 years ago

  By: Andrew Gothard-467944

• Please Help me improve this SPROC!!! It runs too slow!

  I use this Sproc to load data based on a month passed in by the user. Because there is a large amou…

  gregory.perry2

  23 replies

  15 years ago

  By: emily-1119612

• Group By problem

  Hi All, I have a problem extracting the latest job from a table of jobs ... The table structure is …

  shaunb

  2 replies

  15 years ago

  By: Philipp Post

• Creating new Database for a large Enterprise

  Hello All, I need some help with creation of DB for a Bank ERP software (Its having near about 300 …

  djdhere

  10 replies

  15 years ago

  By: Brandie Tarvin

• Using Openrowset to select from Excel sheet with space in name

  Hi, I'm trying to import from an excel spreadsheet but am getting an error when i try and import fr…

  scg1889

  4 replies

  15 years ago

  By: scg1889

• Database Column Encyption

  How Do I Encrypt Datbase Column? Can any body explain it in details, I am really new to this encypt…

  mandavli

  3 replies

  15 years ago

  By: Elliott Whitlow

• comparison expressions in SSRS parameter

  I have created a report with a parameter that passed "qty on hand" The end users would like to be …

  stevenplee

  3 replies

  15 years ago

  By: David Marble

• executing dynamic SQL

  I'm stumped. I want to write a function where in I pass a value that is looked up. The looked up va…

  kdfischer

  4 replies

  15 years ago

  By: kdfischer

• top 5 in each group

  Hi I have table with these column cw,q_number,count I need top5 count in each group. I use this q…

  radekhatle

  3 replies

  15 years ago

  By: radekhatle

• I cannot find Command Window in SSMS

  Hello, I'm debugging some t-sql code, I can view locals, watches etc. and I've closed command windo…

  butters1982

  4 replies

  15 years ago

  By: jvanderberg