T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• Debug SSIS

  I hope I am posting this in the right forum. Tried posting it on another forum but did not get any …

  ramadesai108

  3 replies

  14 years, 7 months ago

  By: ramadesai108

• Transpose in SQL & SYBASE

  Hi All, I have a requirement in sql & sybase. create table b_req ( b_id int, ac_id int, type v…

  karthik M

  2 replies

  14 years, 7 months ago

  By: Orlando Colamatteo

• Divide By Zero Error

  I have a strange problem here When I execute a stored procedure with parameters, I don't get any er…

  Kingston Dhasian

  7 replies

  14 years, 7 months ago

  By: Henrik Staun Poulsen

• Trying to sum transactions only for new clients

  Goal: - Return the sum of all transactions for all NEW clients, grouped by broker Name Tables and F…

  Father Branigan

  12 replies

  14 years, 7 months ago

  By: Phil Parkin

• foreign key constraint issues

  Hi, I have a table with a column ItemCode, what I want is to keep only those ItemCode which have be…

  sqlbaby2

  5 replies

  14 years, 7 months ago

  By: SQLRNNR

• collation change

  Hi friends, We need to change the collation on some of the fields in the database. Do I need to dr…

  newbieuser

  8 replies

  14 years, 7 months ago

  By: Piotr.Rodak

• Limit access to programs

  I’m an application programmer and I proved that I could update our production databases via Excel. …

  tyson.price

  14 replies

  14 years, 7 months ago

  By: K. Brian Kelley

• Calculating Median and Percentiles

  Hi everyone, I've been looking at calculating the median and percentile values for some of our data…

  Dohsan

  6 replies

  14 years, 7 months ago

  By: Orlando Colamatteo

• Calculate future date based on input date. Must be rolling

  I have a scenario where I have an input date and I need to 3 months to this date on a rolling basis…

  SQLDev1

  7 replies

  14 years, 7 months ago

  By: SQLDev1

• Text Extract with datestamp from PRINT command

  How do I capture the output of the print command within t-sql and dump it to a text file which is d…

  mtz676

  2 replies

  14 years, 7 months ago

  By: GSquared

• Return Max value for each Group set

  Hi, I have a column (MaxOrderRank) in a temporary table (@Results) which I need to update using va…

  DerbyNeal

  6 replies

  14 years, 7 months ago

  By: DerbyNeal

• script Permissions at OS level folder

  Hi Team, Is there any T-SQL script which can i have DENY permission at OS level. The reason behind …

  Oracle_91

  4 replies

  14 years, 7 months ago

  By: Oracle_91

• what the heck??? why does my table return data in ssms but blank rows over native client?

  I have never in my 4 1/2 years working with SQL Server come accross anything quite this bizarre. I …

  BenWard

  7 replies

  14 years, 7 months ago

  By: BenWard

• why does my commit not commit and my rollback not rollback?

  Afternoon All This is somewhat perplexing. I have a query (planning to build it into a sproc) that…

  BenWard

  7 replies

  14 years, 7 months ago

  By: BenWard

• Insert and Update Within a Transaction

  I have a stored procedure that hangs intermittently. I have not been able to identify any obvious …

  Stewart Joslyn

  4 replies

  14 years, 7 months ago

  By: TheSQLGuru