T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Unique key

  hi this is just que i am confused. how many unique key we can have in a table? if a data coming fr…

  shah.simmy

  4 replies

  14 years, 5 months ago

  By: Sean Lange

• A Tough One, At Least For Me

  I have a spreadsheet of companies that I need to insert into our CRM. Basically the CompanyID, Com…

  adams.squared

  15 replies

  14 years, 5 months ago

  By: adams.squared

• Different result in Query vs. View

  Somewhat of a basic question I think but... If I run this in a query window, I get the results I ex…

  tnpich

  4 replies

  14 years, 5 months ago

  By: tfifield

• Select CASE Problem

  i Have a report that contains parameters one for customer and one to decide what to include in th…

  peseta30

  4 replies

  14 years, 5 months ago

  By: peseta30

• Set based updates...not using cursors or loops

  I am struggling with how best to do a data update to a table. I have (right now) a comma separated …

  Laurie-1124340

  9 replies

  14 years, 5 months ago

  By: Laurie-1124340

• 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, 5 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, 5 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, 5 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, 5 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, 5 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, 5 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, 5 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, 5 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, 5 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, 5 months ago

  By: Snargables