T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• join operator "=*"

  I just ran accross a query that uses "=*" in a where clause. I know I read an article recently abo…

  Uripedes Pants

  9 replies

  14 years, 10 months ago

  By: Uripedes Pants

• Help with CASE statement

  I have: SELECT * FROM tablename WHERE AccountID = '000001' This returns a blank value as that Accou…

  GBeezy

  7 replies

  14 years, 10 months ago

  By: GBeezy

• contraints syntax and script

  In SSMS, I click a constraint and generate script create to, I got something like below: USE [Asset…

  sqlfriend

  3 replies

  14 years, 10 months ago

  By: Victor Dvoryaninov

• Query Help

  I need help for following scenario. I have a table tb1 with following datetime columns. c1,c2,c3,c4…

  flash.rsn

  11 replies

  14 years, 10 months ago

  By: Jeff Moden

• Passing a Constant in a query which is stored in a variable.

  Dear Forum members, I am trying to capture the stats of dataware house. So I u…

  rockybhai

  7 replies

  14 years, 10 months ago

  By: SQLRNNR

• How to find max value in which column

  I have following table structure: CREATE TABLE [dbo].[Results]( [Id] [int] IDENTITY(1,1) NOT NULL…

  Shamshad Ali

  9 replies

  14 years, 10 months ago

  By: Victor Dvoryaninov

• Strange Results, Operator Precedence !

  [font="Verdana"]Please if following queries, with their respective output, can be explained in simp…

  Abrar Ahmad_

  5 replies

  14 years, 10 months ago

  By: Abrar Ahmad_

• Perplexed by 2005/2008 error handling options - please help me understand why I shouldn't miss the @@error days

  Hi all, I know that Try/Catch was supposed to make our lives easier, but I am still perplexed by th…

  Sha_

  2 replies

  14 years, 10 months ago

  By: Sha_

• "...cannot be renamed because the object participates in enforced dependencies"

  Hi I am working on renaming some tables inside a database. For this I have made the following code:…

  4R4

  2 replies

  14 years, 10 months ago

  By: 4R4

• Eliminating Data with Multiple occurrences!!!!!

  Hi, I have a table as shown below with three columns EmpNo,ReferenceNo & Status. EmpNoReferen…

  Hakuna Matata

  4 replies

  14 years, 10 months ago

  By: LutzM

• Asking for help to understand subtle nuances of randomised query.

  Please consider this query for generating "Coin Tosses", heads or tails. It seems to contain some s…

  mister.magoo

  18 replies

  14 years, 10 months ago

  By: Jeff Moden

• TSQL - want to get count of other column...how to

  -- Count items per hour SELECT Year, Month, Day, Hour, /*COUNT(Hour) AS "Items per Hour",*/ COUNT(s…

  sql_jr

  3 replies

  14 years, 10 months ago

  By: Jeffrey Williams

• Best practices in querying

  This is just a general question, but let's say I was going to create a stored procedure and referen…

  Mike Scalise

  6 replies

  14 years, 10 months ago

  By: Jeffrey Williams

• How to "key/join" procedural vs. relational records??

  Have an interesting problem can’t quite get my head around to parse in tsql. We have these 3 tables…

  al_nick

  13 replies

  14 years, 10 months ago

  By: Evil Kraig F

• Getting dates from SQL into Excel in float format

  HI, I have a view with seveal columns, ie a period column (date type in SQL). whenever I'm querying…

  DZN

  6 replies

  14 years, 10 months ago

  By: DZN