SQL Server Newbies

• Topics

  Started by

  Posts

  Last post

• Help with Case Query

  Hi, I meant Cursor Query and not Case in the Topic Header! I need to identify a list of items from …

  jacques.spies

  8 replies

  13 years, 9 months ago

  By: jacques.spies

• Primary with Null value

  How can I set PK columns to allow null or blank?

  wertyui

  15 replies

  13 years, 9 months ago

  By: Eric M Russell

• Extracting month from Date PL/SQL

  I have to provide month_of_date in my query, I tried following function in Oracle but it gives me e…

  daveap

  2 replies

  13 years, 9 months ago

  By: Lynn Pettis

• FTP a file using ssis where file name is comepletly dynamic

  Hi Folks, Need a help, I have a business requirement to genrate a CSV file with following name INDU…

  shrey.sheth

  3 replies

  13 years, 9 months ago

  By: Lynn Pettis

• SQL Select statements and joins

  if I have follwing code: select I.OID, I.segment,, MAX(CASE WHEN S.SUBSCRIPTION_TYPE = '5' THEN …

  daveap

  3 replies

  13 years, 9 months ago

  By: Jared

• Appending

  Hi, I am very new to SQL server managment 08 r2. I have done some things with SQL before in Oracle …

  sl01

  6 replies

  13 years, 9 months ago

  By: Jared

• Copy a database, then test its restore...

  We have multiple instances of SQL Server 2000, 2005 and 2008. We want to test our restore process f…

  jralston88

  7 replies

  13 years, 9 months ago

  By: CapnHector

• SQL 2005 Table keeps being deleted

  Hi Guys, Sorry for the basic question, I have an issue in SQL 2005 where a table keeps going missin…

  Mints

  5 replies

  13 years, 9 months ago

  By: Eric M Russell

• multi user in sql server

  hi how to access multi user in remote desktop connection of ms server.plz give any idea. i wan…

  selvakumar.sms

  4 replies

  13 years, 9 months ago

  By: Lynn Pettis

• Database Connection Interrupted

  Last night I had application users reporting an error that there database connection had been inter…

  lamason

  3 replies

  13 years, 9 months ago

  By: Robin Sasson

• Update / Edit Query

  Hi Guys, I am currently working on a website that deals with sales of products. For one of my pages…

  anonymousmofo123

  6 replies

  13 years, 9 months ago

  By: vinu512

• Want to see percentage of results over a particular level - real newbie

  Hi, I've made a report from a report model supplied by our software providers and want to be able t…

  yvonne.jackson

  5 replies

  13 years, 9 months ago

  By: Xedni

• columns in sql select statements affecting the number of rows

  Please see the query below .if I include the end_date in my select statement, my records counts are…

  daveap

  3 replies

  13 years, 9 months ago

  By: SGT_squeequal

• Temp Tables in a Trigger

  Hi, I have been told it's bad to use temp tables in a trigger but not given much of an explanation.…

  SeaShell99

  1 replies

  13 years, 9 months ago

  By: Gail Shaw

• TimeStamp Data type to record transaction time

  SQL Server Timestamp Data type

  pmwagne

  7 replies

  13 years, 9 months ago

  By: pmwagne