T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• SQL Query - Simple Question

  Hi guys, We got a table in a form like this: Imagine it has millions of records! I'm looking for a…

  salardx

  10 replies

  11 years, 3 months ago

  By: Luis Cazares

• Query to show table Products with its modes

  Hello, I need assistance with a query that show me a Products Tables and its models, 1 product coul…

  sistemas_casinomnes

  5 replies

  11 years, 3 months ago

  By: sistemas_casinomnes

• My Cursor don´t UPDATE

  Hello comunity I have build this cursor, but the same one don´t make the Update to my table ft2. he…

  luissantos

  3 replies

  11 years, 3 months ago

  By: Eirikur Eiriksson

• tsql with out using cursors

  Hi Please.. can anyone give me an alternative code for the below tsql with out using cursors decla…

  Damian-1673

  50 replies

  11 years, 3 months ago

  By: Jeff Moden

• Holidays and Business Days

  Hi All, I have a stored procedure that has to deliver the next 11 years of business days, accountin…

  sgmunson

  4 replies

  11 years, 3 months ago

  By: ksatpute123

• Agent Job report omit previously sent data

  Hey everyone, I have this report i setup as an agent job in SSMS; It's setup to run every 7 minutes…

  salkobi

  5 replies

  11 years, 3 months ago

  By: salkobi

• Error in CASE statement

  Hi all, I have write a code using CASE statement but it gives me error. SELECT CASE WHEN Division …

  kapil_kk

  9 replies

  11 years, 3 months ago

  By: aaron.reese

• returning rows within a certain distance in miles from city using longitude and latitude

  I've got a working query which returns all leads within a supplied proximity to a city. I followed …

  KoldCoffee

  13 replies

  11 years, 3 months ago

  By: serg-52

• Question about VALUE

  In the thread: http://www.sqlservercentral.com/Forums/Topic1637167-392-5.aspx Lynn Pettis, showed …

  djj

  4 replies

  11 years, 3 months ago

  By: djj

• Cannot create an instance of OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "(null)"

  I know this question was discussed lots but seems still cannot figure it out, here is the issue: My…

  halifaxdal

  6 replies

  11 years, 3 months ago

  By: halifaxdal

• cursor replace hyperlink function

  I am trying to replace names found in 'xml' fieldname as hyperlinks, by matching with the names in …

  missy786

  4 replies

  11 years, 3 months ago

  By: Eirikur Eiriksson

• Function to parse T-SQL

  I am debugging a DB maintance script which creates a table of index maintainance commands which are…

  dan-572483

  3 replies

  11 years, 3 months ago

  By: Xedni

• Comparing columns in Unpivot table sql server

  SET NOCOUNT ON; IF OBJECT_ID('dbo.TBL_SAMPLE_DATA') IS NOT NULL DROP TABLE dbo.TBL_SAMPLE_DATA; CRE…

  Dhruva_51

  7 replies

  11 years, 3 months ago

  By: Sean Lange

• Having issue with implementing CTE in Stored Procedure. Please help!!

  I’m hoping that anyone can help me with an error that I’m receiving when I try to alter following s…

  Zohaib Anwar

  34 replies

  11 years, 3 months ago

  By: shoestringdba

• "Order" between JOIN and APPLY

  I ran into a statement where it selects from something like that: ... FROM Table1 AS a CROS…

  btio_3000

  25 replies

  11 years, 3 months ago

  By: sgmunson