T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• SQL Statement for Compatibility Check

  Hello, I want to first apologize for my lack of research and code presented in this post. I recentl…

  SQL_Enthusiast

  3 replies

  15 years ago

  By: SQL_Enthusiast

• Row values diffrence in same row

  ---I have below SQL Table..... USE [abc] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET AN…

  Best_boy26

  6 replies

  15 years ago

  By: ChazMan

• Invalid length parameter passed to the LEFT or SUBSTRING function

  Hi, when I am running below SQL I am geting the error msg "Invalid length parameter passed to the L…

  kiran.rajenimbalkar

  2 replies

  15 years ago

  By: Evil Kraig F

• SQL Query Help after 13th row Dynamic and in 12th row static values with a formula

  I have below table structure with the similar to below output. S_NO_T_PO_P H_PL_P …

  Best_boy26

  15 replies

  15 years ago

  By: Evil Kraig F

• Combine multiple columns into one columns

  I need to get the following results when combining multiple columns into one column. Col0 Col1 …

  TT-131210

  5 replies

  15 years ago

  By: TT-131210

• Common SPs and UDFs, some default tables

  In our server instance, I am planning to have common database which has all the default tables, com…

  krishnaroopa

  8 replies

  15 years ago

  By: dant12

• Look Up transformation in SSIS

  Hi I got to desgin an ssis package whihc pulls data from excel sheet to a db. So i designed that pa…

  tripri

  2 replies

  15 years ago

  By: dant12

• Query Help Rownumber 13 Dynamic and 12 static values with a formula results to the same row after caluculation as separate column

  Below is the SQL Query i used to create as view CREATE VIEW [v_AMP_C] AS SELECT dbo.IC_Raw_In.…

  Best_boy26

  1 replies

  15 years ago

  By: Sean Lange

• Query help using Pivot

  I have the following stored procedure which is doing a perfect job and creating a matrix style outp…

  joshtheflame

  2 replies

  15 years ago

  By: joshtheflame

• Use sp_OACreate to connect to share drive ..

  Does anybody knows where I can find doc for this ? I would like to do something like (in vbs) Set o…

  DZN

  10 replies

  15 years ago

  By: Elliott Whitlow

• Select rows with multiple occurrences over multiple tables

  DB: SQL Server 2008 I want to select id, title and userid from a table if that userid occurs more t…

  petervdkerk

  5 replies

  15 years ago

  By: Evil Kraig F

• T-SQL Help

  Hi, The following is a sample of the data I am working with: CREATE TABLE #Temp1 (ID INT, Code I…

  MattW2010

  14 replies

  15 years ago

  By: Jeff Moden

• select and join

  i got a piecec of code from 3rd party app, which looks like: select * from table_1 a join table_2 b…

  michael wang-201906

  2 replies

  15 years ago

  By: michael wang-201906

• Why does this query only run in master?

  Am I doing something wrong. It runs fine in master, but if I try and run it out of our dbadmin data…

  Susan-322874

  7 replies

  15 years ago

  By: Susan-322874

• not able to use xp_cmdshell...

  Hello, I'm trying to read a folder located on another server. 1. I have created a credential (Ident…

  DZN

  6 replies

  15 years ago

  By: DZN