SQL Server Newbies

• Topics

  Started by

  Posts

  Last post

• find table relationships

  Hi, Is it possible to take two tables and see how they are connected? I have an application name li…

  PHXHoward

  7 replies

  13 years, 9 months ago

  By: PHXHoward

• Need help with calculation

  Some background: My client is using a tool that stores original budget values and then allows a use…

  MattieMich7

  3 replies

  13 years, 9 months ago

  By: MattieMich7

• Time Computation Challenge

  Hi guys, can you help me with my homework? Let say I have @startTime and @endTime both datetime var…

  mhike2hale

  11 replies

  13 years, 9 months ago

  By: Cadavre

• Assigning variables in Where Clause

  I came across the following query for AdventureWorks Database. DECLARE @productName VARCHAR(100) SE…

  jignesh209

  3 replies

  13 years, 9 months ago

  By: Devendrakumar

• when to use update statistics sql server 2005

  when to use update statistics sql server ???

  aby_dvd

  3 replies

  13 years, 9 months ago

  By: Divine Flame

• Sql stored procedure to compare two table and update data in one table if we r having non matching records

  Hi All, I need nelp to write stored procedure , pls guide me on this : Requirement : Having two ta…

  getalok_akg

  1 replies

  13 years, 9 months ago

  By: okbangas

• Stored Proc in MS ACCESS Database Project With MS SQL Server 2008R2

  This may be an easy answer to this question but I'm not staying focused enough to have any luck, I…

  Mrfixit1170

  3 replies

  13 years, 9 months ago

  By: Mrfixit1170

• Requesting Your Recommendation: TRANSACTION ISOLATION LEVEL Setting

  Background: We have a 3rd party ERP system (Amtech), database is SQL Server 2008 R2. Our ERP vendor…

  EdA ROC

  5 replies

  13 years, 9 months ago

  By: EdA ROC

• SUM WITHIN SUM

  Great day guys! I am using Access and I just want to know if it is possible to use SUM statement wi…

  omi_real

  16 replies

  13 years, 9 months ago

  By: derek.colley

• Case Statement and ISNULL problem

  Hi, I'm having an issue with a case statement: Select Case When ISNULL(DateOfLicense1,convert (dat…

  mic.con87

  7 replies

  13 years, 9 months ago

  By: mic.con87

• SQL for Converting Field Type CHAR to Date Format 'YYYY-MM-DD'

  Hi, I'm pulling data over from a SQL server into my Salesforce org via an Informatica Cloud app. I …

  jonathanmreynolds

  1 replies

  13 years, 9 months ago

  By: Possinator

• Need help creating a new table from rows of existing table

  Identifierpriority accountnumber 12345619999999999 12345618888888888 123456500000000…

  steveg-941384

  3 replies

  13 years, 9 months ago

  By: steveg-941384

• Leaving a contract project

  This may not be an appropriate forum for this post, but I need some suggestions. Here goes... My l…

  stevenplee

  8 replies

  13 years, 9 months ago

  By: Elliott Whitlow

• SQL Newbie - want to learn SSIS!

  Hi, I am trying to change my career focus from batch scheduling into the BI,Data analytics area. I …

  john_nyasani

  7 replies

  13 years, 9 months ago

  By: SQLRNNR

• SQL Server 2000 - Replay traces with Perfmon

  Hi I am new bie. I have a test system in which the profiler traces are running and I have access to…

  Abdul Rahman

  1 replies

  13 years, 9 months ago

  By: 456789psw