T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Transpose data

  I have a table in my companies database that looks like this (I can not change this structure). CRE…

  squidder11

  8 replies

  14 years, 4 months ago

  By: Cadavre

• SQLServer equivalent of SELECT RANK ... OVER ... PARTITION in Oracle

  I had some code that was running like a three legged dog with three broken legs. All our systems w…

  marlon.seton

  2 replies

  14 years, 4 months ago

  By: marlon.seton

• missing records on table

  Hello All, I was asked a question by someody for which I did not have answer and still couldn't fig…

  Walton

  18 replies

  14 years, 4 months ago

  By: Jeff Moden

• Cannot resolve the collation conflict...

  I'm getting a pesky collation error when trying to run my mail script. The error is: Cannot resolve…

  memymasta

  3 replies

  14 years, 4 months ago

  By: memymasta

• Error No - Msg 15530 when change to dbo schema

  Hi, I try to change schema name "dbo" as below statement, but its produce error EXEC sp_changeobjec…

  SQL Galaxy

  9 replies

  14 years, 4 months ago

  By: MarkusB

• Need Sp fro data delete

  Hi, I am using below query to delete rows from table A which rows are available in table B also (s…

  manju3606

  3 replies

  14 years, 4 months ago

  By: Sam Bendayan

• select update

  Hi i am having problems with a query i have i am trying to do a select update i want to have someth…

  Simon Parry

  5 replies

  14 years, 4 months ago

  By: Sam Bendayan

• Error converting data type varchar to bigint.

  I am having the darndest time selecting rows where a column value is <=9999. Here is the schema …

  hkflight

  6 replies

  14 years, 4 months ago

  By: Jeff Moden

• select * into

  Hi, I am trying to create a table selecting from a view and the view has alias names to most of the…

  Tara-1044200

  9 replies

  14 years, 4 months ago

  By: Sam Bendayan

• delete from XQuery using sql:variable

  Anyone know how to properly use a syntax for XQuery with delete a path listed in a sql:variable? Ne…

  Gabriel P

  1 replies

  14 years, 4 months ago

  By: GSquared

• T sql query to verify decimal exist in the column

  Hi How to verify whether a decimal point exist in the column data. eg:I have a Column called primar…

  ry.sqldev

  5 replies

  14 years, 4 months ago

  By: Ninja's_RGR'us

• Write query from (particular period)

  I want to query data from (01.09.2011 - 31.10.2011), please do not use PERIOD column to retrieve …

  solomon.jernas

  5 replies

  14 years, 4 months ago

  By: solomon.jernas

• Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = 0, current count = 1.

  I want to know what is wrong with the stored procedure. It works fine with all cases except when I …

  schauhan13

  5 replies

  14 years, 4 months ago

  By: schauhan13

• compare date columns

  hi, I want to join 2 tables with date. I want to compare only the dates. That is excluding hours, m…

  dhanalakshmi 99938

  3 replies

  14 years, 4 months ago

  By: dhanalakshmi 99938

• Why select table1.colA + table2.colA = null ???

  Hello When I select table1.colA + table2.colA it return null value when colA is 0 At table1.colA an…

  m0n

  4 replies

  14 years, 4 months ago

  By: mister.magoo