T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Conditional Table Join

  I am interested in selecting certain tables to query from based on age of request. Ex. If a person …

  mbrady5

  2 replies

  9 years, 11 months ago

  By: sgmunson

• Moving values to fill in nulls.

  Hi all, I have been away from SQL for a couple of months, and for the life of me cannot work out a …

  danielfountain

  8 replies

  9 years, 11 months ago

  By: danielfountain

• Not Equal in Inner Join not working

  I have 2 Tables. Say, [font="Courier New"]Table1[/font] - with fields PId, SSN [font="Courier New"]…

  abhilashca

  20 replies

  9 years, 11 months ago

  By: tibco29

• Calculating running totals for partitions of data

  I have table named #t1 and three columns. CODE, Column1, and Column2. create table #t1 ( …

  kdejan87

  12 replies

  9 years, 12 months ago

  By: Steve Jones - SSC Editor

• Query to display dif values from the same column in the same table -t-sql

  I have a table with a column AttributeNumber and a column AttributeValue. The data is like this: Or…

  montserrat.deza

  2 replies

  9 years, 12 months ago

  By: montserrat.deza

• Counting number of occurances

  I'm trying to figure out how to do the following: Number of People receiving their second speeding …

  jkw

  10 replies

  9 years, 12 months ago

  By: higgim

• Comparison of times row by row

  Hi All, I'm looking for some advice with comparing times in the same field. I have two tables, one …

  Paul Munter

  6 replies

  9 years, 12 months ago

  By: Paul Munter

• HASHBYTES ERROR INT

  I get in the following sql statement a ERROR: SELECT * INTO [#VWDimLocation] FROM DWH_Stagin…

  GG_BI_GG

  2 replies

  9 years, 12 months ago

  By: GG_BI_GG

• Search through rows with specific values

  Hello All, I've a table that stores operationcode for each jobnumber. The jobnumber can have multip…

  SSRS Newbie

  11 replies

  9 years, 12 months ago

  By: SSRS Newbie

• Deadlock when creating new FK constraint?

  The other day developer asked me to create a new table that had a FK constraint to an existing larg…

  ManicStar

  1 replies

  9 years, 12 months ago

  By: Ken McKelvey

• TRY/CATCH Blocks

  I am having an issue where my templates seem to have variances. Do these both work or should I pic…

  JKSQL

  1 replies

  9 years, 12 months ago

  By: JKSQL

• Cannot create the clustered index ind on view V because the select list of the view contains an expression on result of aggregate function or grouping column. Consider removing expression on result of aggregate

  [p]I am creating Indexed views using SQL Server 2008R2. When I create index on the View it give me …

  azhar.iqbal499

  4 replies

  10 years ago

  By: Maddy29

• Need CTE query to find specific record

  Hello comunity I need to build a CTE query to find for the same Cabstamp (document) where i have di…

  luissantos

  5 replies

  10 years ago

  By: luissantos

• query for compare data in 2 tables

  HI all, Table 1 has "Gender" field with "Male" and "Female" in it, table 2 has "Gender" field with …

  rajbetl11

  4 replies

  10 years ago

  By: rajbetl11

• get week numbers from dates, saturday being start of the week,

  i have the following table I need to select dates grouping them by weeks, my week start is Saturday…

  Nomvula

  4 replies

  10 years ago

  By: ScottPletcher