T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Violation of PRIMARY KEY constraint

  Hi all, i am trying to execute this query: begin tran insert into Attributes (Id, EntityId, Attribu…

  martin.kerr 34088

  11 replies

  14 years, 2 months ago

  By: Paul White

• Enhance the query to read the organization ID from organization table instead of listing the organization ID in WHERE clause

  Hi SQL Gurus, I need your help here to enhance my script below. This script here is to check whethe…

  yingchai

  11 replies

  14 years, 2 months ago

  By: ChrisM@home

• Need Hellp

  WITH CTE AS ( SELECT MNTH, YR, Sev1Count,Total_Count, CAST(CAST(ROUND(CAST(Sev1Count AS DECIMAL…

  muralistar84

  1 replies

  14 years, 2 months ago

  By: BrainDonor

• Select Query - need optimization

  Table_1(custid,store,amont) Insert into Table_1 values (1,store1,1000) Insert into Table_1 values (…

  calibar2k

  15 replies

  14 years, 2 months ago

  By: Eric Hu²º¹²

• Insert rows into table dependant on how many to insert

  Hi, I have two tables OrderHeader OrdersMissing On the OrdersMissing table it will have the followi…

  SQL_Kills

  4 replies

  14 years, 2 months ago

  By: fahey.jonathan

• Getting the difference from current row and previous row

  Hi, I have a database table which logs hourly value from a meter. I need to get the difference betw…

  hemaljoes

  7 replies

  14 years, 2 months ago

  By: hemaljoes

• sp_executesql

  Hi, I'm trying to explore about sp_exectesql and the below query is showing the syntax error at '+m…

  gary1

  2 replies

  14 years, 2 months ago

  By: Eric Hu²º¹²

• 8144 Exception in SQL profiler

  Hi, I have SQL SERVER 2008 Standard Edition (64 bit).When I call a specific Stored procedure thoru…

  Aspet Golestanian Namagerdi

  1 replies

  14 years, 2 months ago

  By: Ben Teraberry

• Conversion of oracle query to SQL

  Hi, I am finding difficult to resolve this oracle query to SQL. select substr((pagename), 1,instr(…

  Minaz Amin

  5 replies

  14 years, 2 months ago

  By: fahey.jonathan

• convert '1 - Apr' to datetime

  select replace('1 - Apr',' ','') dt into #test select dt --how do i convert this varchar to a datet…

  Snargables

  6 replies

  14 years, 2 months ago

  By: Snargables

• Data mining

  Hey guys, We have a system that was designed incorrectly and has bad data in it... SO I am writing …

  asm1212

  13 replies

  14 years, 2 months ago

  By: asm1212

• getting info from 2 tables with parent ids

  Need some help in creating a query that will give me a report of items size and color that are stor…

  steve-760524

  4 replies

  14 years, 2 months ago

  By: Sean Lange

• multiple column in one column with same id

  create table mytable (id int identity(1,1), PersonID int, Unit varchar(10)) insert into mytable …

  freecoder

  15 replies

  14 years, 2 months ago

  By: freecoder

• Excluding records that took place within 5 minutes

  I am really stuck on this and am probably missing the obvious solution: I have a table like this: D…

  ramses2nd

  8 replies

  14 years, 2 months ago

  By: Jason Selburg

• Help with importing XML using T-SQL.

  Hi, I am trying to import XML data into SQL Server tables using T-SQL FOR XML. The scenario can hyp…

  UnionAll

  3 replies

  14 years, 2 months ago

  By: UnionAll