General

• Topics

  Started by

  Posts

  Last post

• Aggregate query help

  select opr_id,evt_id, count(*) from dbo.rxrep_rept_card with(nolock) where acty_dte > '03/06/201…

  Dustin W. Jones

  1 replies

  15 years, 2 months ago

  By: spaghettidba

• Template for Data Flow in Sale Systems

  Hi, For an university research, I have to analyze Sale Systems and define input, output and process…

  sani

  4 replies

  15 years, 2 months ago

  By: sani

• Avoiding SQL injection

  I'm putting together a prototype mobile web page in classic ASP. (Unfortunately, I don't control t…

  Ray K

  7 replies

  15 years, 2 months ago

  By: Nadrek

• How to Add field and populate it in the same query?

  I have a table that may or may not have a timestamp field in it. For me to send out the deployment …

  Stamey

  3 replies

  15 years, 2 months ago

  By: Stamey

• Greatful for SQL Server resources like this one

  :w00t::w00t: (( And YES!!, I realized I misspelled grateful as soon as I hit the post button )) I j…

  SumOfDavid

  2 replies

  15 years, 2 months ago

  By: Jim Russell-390299

• testpassport ensure passing 199-01 exam

  testpassport is the online Certification Expert recognized by a worldwide audience of IT profession…

  7148050

  2 replies

  15 years, 2 months ago

  By: Henrico Bekker

• Anyone know how to obtain the SQL code which caused a trigger to fire?

  Hello, first time poster, long time lurker. We have a very large, distributed application which occ…

  geerobg

  9 replies

  15 years, 2 months ago

  By: Paul White

• Can't find assemblies to interact with Sql Server 2008 R2 via C#

  Hi, I have installed Sql Server 2008 R2 Nov 2009 CTP but I cannot find the assemblies that would al…

  info-849042

  2 replies

  15 years, 2 months ago

  By: RBarryYoung

• interesting sql problem

  Hi, I hav a table which contains student info. such as student name and course name. Its structur…

  jrajkhowa

  4 replies

  15 years, 2 months ago

  By: GSquared

• Need help adding boolean count

  All i have a stored procedure that takes position vacancy and filled counts and displays them in a…

  geo039

  8 replies

  15 years, 2 months ago

  By: geo039

• Execute stored procedures as RPC or T-SQL Batch?

  Hi all, I need some help with technical information about the right choice to execute stored proced…

  MSzI

  3 replies

  15 years, 2 months ago

  By: Jack Corbett

• sql query need Help about Absent Employee

  good Day... i need help about my project in school about employee attendance module. I have a table…

  oliver8615

  9 replies

  15 years, 2 months ago

  By: shiningworld_4u

• Full path of table chopped up

  The application code generates the full path of a table it will be cross referencing in the server:…

  repent_kog_is_near

  3 replies

  15 years, 2 months ago

  By: vidya_pande

• Adding two columns SQL 2005

  below is the code I have. I want to add the male and female and place in new column called TOTAL -…

  ritesh.kansara

  2 replies

  15 years, 2 months ago

  By: K Cline

• Possible to avoid a SELF JOIN without a Subquery?

  Hi, I'm wondering if there is a way to write a query such as this without using a SELF JOIN.. SELEC…

  OJ Ferns

  2 replies

  15 years, 3 months ago

  By: OJ Ferns