SQL Server 2012 - T-SQL

• Topics

  Started by

  Posts

  Last post

• Row_Number over partition Help

  Hi there i am having problems getting my last revision number out when i am trying to use inner joi…

  jamie 49796

  2 replies

  11 years, 10 months ago

  By: Umer Akram

• Need a 2nd opinion on a query

  I had a collegue write the following query. He got defensive when I asked what he was trying to acc…

  dndaughtery

  13 replies

  11 years, 10 months ago

  By: John Chapman

• insert into table execution of a stored procedure

  Hello I have this table declare @UserMidListTable Table (Id Int,Mid int,ValueMid int,CatParent int,…

  bkshn

  10 replies

  11 years, 10 months ago

  By: Jeff Moden

• SSIS package backup of sharepoint

  Hi all, Hi was assigned a project to make a backup of data from 3 lists in a sharepoint with the ob…

  daniel.carreira

  1 replies

  11 years, 10 months ago

  By: bahiapt

• Normalizing using Cross Apply... with a twist

  I was reading Kenneth Fisher's article on using Cross Apply to normalize an unnormalized table. (I…

  pietlinden

  1 replies

  11 years, 10 months ago

  By: Dwain Camps

• Replacement for a whole mess of left joins?

  Hi, A bit of a general question: I have a query with 28 LEFT JOINS. 20 of them join one table to th…

  sqldriver

  22 replies

  11 years, 10 months ago

  By: sqldriver

• Could this be done better?

  Howdy, Late last night I got a request for some data. The format was the biggest challenge, since t…

  sqldriver

  22 replies

  11 years, 10 months ago

  By: sqldriver

• sys.default_constraints bug

  Hi all i've executed the following CREATE DATABASE practise USE practise CREATE TABLE dbo.SUPPLY1 …

  mssqlnoob

  1 replies

  11 years, 10 months ago

  By: Keith Tate

• Find out if the whole column of data in a table is empty - dynamic sql creation

  Morning, Thanks for your help in advance, very much appreciated. I have created some dynamic sql to…

  olibbhq

  10 replies

  11 years, 10 months ago

  By: olibbhq

• Question About Trapping Attempt to Insert Duplicate Record in Stored Procedure

  I have the following stored procedure (shown at the bottom of this posting). It attempts to do a s…

  brad.mccollum

  8 replies

  11 years, 10 months ago

  By: brad.mccollum

• Dynamically create a sql script only selecting columns where there is data

  Morning, Thanks for your help in advance, very much appreciated. I have created some dynamic sql to…

  olibbhq

  1 replies

  11 years, 10 months ago

  By: olibbhq

• How can I use MAX() function in another DataBAse?

  Hello I want to use max() function and I want to read the input of this function from another datab…

  bkshn

  2 replies

  11 years, 10 months ago

  By: Jeff Moden

• Import XML returns 0 rows affected failing

  Hi All I am trying to do a bulk import of data from XML into sQL. My query returns no errors but no…

  Last

  2 replies

  11 years, 10 months ago

  By: liteswitch

• Datawarehouse Flat files Bulk data load Slow Loading

  Hi Friends, We have to load 15-20 GB of file in Data warehouse daily. The current configuration of …

  Vishal_MSBI

  4 replies

  11 years, 10 months ago

  By: Vishal_MSBI

• T-SQL Doesn't Catch Condition

  I have a strange, perhaps too complex query (any suggestions gladly welcomed...) meant to catch dif…

  Jim

  6 replies

  11 years, 10 months ago

  By: Jim