T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• How to copy data of a table(selected columns) from one DB to other

  Hi All, This is my first post in this forum. I need to copy the data of table(only selected columns…

  nandu524

  4 replies

  15 years ago

  By: nandu524

• Import from Excel (insert into ---- select from Openrowset : not in the same order as in Excel Why? How to avoid this

  Hello, I have to import data from Excel from TSql stored proc. The import is going well but the ord…

  DZN

  4 replies

  15 years ago

  By: DZN

• Transactions

  If I have this sproc: create procedure dbo.test_tran as begin begin tran create table #temp ( iI…

  Mister Ken

  1 replies

  15 years ago

  By: SQL_Enthusiast

• select column1 of table1 that doesnot contain in column1 of table 2

  Need to retrieve the records from Table User where User_ID doesnot exist in User_Role Table Tried t…

  gadedineshreddy

  4 replies

  15 years ago

  By: Gail Shaw

• 10 rows to check the high value and do some calcs

  I am looking for a help in writting a sql query... below is the SQL table i won DDL USE [abc] GO SE…

  Best_boy26

  10 replies

  15 years ago

  By: Orlando Colamatteo

• Group by

  Hi All, Let us say I have a table with a column Varchar(20) that stores IP address. I want to group…

  Roy Ernest

  23 replies

  15 years ago

  By: Jeff Moden

• Rounding issue converting float to datetime

  Hi I have a scenario where I need to take the date part from one datetime field, and the time part …

  Wolfmeister

  4 replies

  15 years ago

  By: Wolfmeister

• insert into table select * from opendatasource/openrowset - getting the Excel row number and filename in the same time in the DB

  Dear all, It is possible to grab in the same time the Excel row number and the Excel filename and p…

  DZN

  2 replies

  15 years ago

  By: DZN

• How do Select inThis order ..........? Please

  Hi, Am having table with two column like follows +--------------------------+----------------------…

  nithin11

  5 replies

  15 years ago

  By: Sean Lange

• Date Rounding

  My goal was to create a function that I could pass a datetype and date to and it would return a rou…

  ptn1

  13 replies

  15 years ago

  By: UMG Developer

• replace nested IF..Else in query using CASE

  below is the nested IF ELSE statement i am using it in my store procedure ,,but now i want to repla…

  krishusavalia

  4 replies

  15 years ago

  By: krishusavalia

• Bitmap filters slower??????

  i have the following DW query, 65 mil row fact table 1 mil dimension selectivity of query is about …

  !2Brite

  1 replies

  15 years ago

  By: Evil Kraig F

• Help need in writing Query with cte

  I have a SQL table with below DDL. USE [abc] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO C…

  Best_boy26

  1 replies

  15 years ago

  By: Dan.Humphries

• Invalid length passed to substring!

  I have a simple string splitting iTVF (attached) that im trying to use in an exist clause SELECT * …

  dant12

  6 replies

  15 years ago

  By: dant12

• Pattern Matching

  Hi, I have a column in a table which contains the pattern of a file.It could be AB*.xls, *.*,*2010.…

  SSM-242970

  3 replies

  15 years ago

  By: Jason Selburg