T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• Select Related Fields Data Issue

  Hi, i have a huge database where users can search according to their requirements(this is location …

  MuhammadShafiq

  13 replies

  13 years, 1 month ago

  By: MuhammadShafiq

• Can You Run a veiw with its own permissions?

  To get around Kerbos double hop.. can you set your view's SQL statement to use its own permissions?…

  dwilliscp

  2 replies

  13 years, 1 month ago

  By: vikingDBA

• BACKUP DATABASE WITH COMPRESSION is not supported on Standard Edition (64-bit).

  I'm getting an error when trying to backup a database on a 64 bit machine. I've previously benn abl…

  dndaughtery

  5 replies

  13 years, 1 month ago

  By: Gail Shaw

• Extracting unique records based on two columns

  I've attached the ddl for the table, the insert, and the desired results. I need to write a query t…

  lulu_lutz

  10 replies

  13 years, 1 month ago

  By: lulu_lutz

• Rolling 13 weeks of data

  I'm sure this is simple, I'm just missing something here. I have a table of data, and I want to al…

  ericb1

  2 replies

  13 years, 1 month ago

  By: ericb1

• Save DAT file in sqlserver

  Hi, i have .DAT file having whole world information.when i am getting information from this file,it…

  MuhammadShafiq

  8 replies

  13 years, 1 month ago

  By: RBarryYoung

• How do I link 2 records in the same table with no apparent link?

  Hi All Here is my problem. I have a table that is used for time clock punches, the IN and OUT punch…

  craigalaniz

  11 replies

  13 years, 1 month ago

  By: craigalaniz

• Count number of columns in a CSV file

  Hi people.. Is it possible to Count number of columns in a CSV file from a T-SQL code? i think we c…

  ColdCoffee

  6 replies

  13 years, 1 month ago

  By: Jason-368451

• How to retain the variable's value in a dynamic sql? Thanks.

  In a case I have to use dynamic sql in my query, here is the query: set @sql = 'select @subTotal =…

  halifaxdal

  10 replies

  13 years, 1 month ago

  By: Eugene Elutin

• SQL DDL trigger

  I have just starting using MS SQL Server. I want to create a DDL trigger. The idea is as follows: I…

  Magnus S.

  2 replies

  13 years, 1 month ago

  By: RBarryYoung

• Why table is not created?

  I know this is weird, just couldn't think of a possible reason, please help. Thanks. I have a sp, w…

  halifaxdal

  9 replies

  13 years, 1 month ago

  By: Divine Flame

• Could not be bound...

  Hi, I'm having some trouble with what I thought was a fairly easy query... select CMPCOMPANYCODE …

  krypto69

  6 replies

  13 years, 1 month ago

  By: drew.allen

• Bulk Insert with Double Quotes and Single Quotes

  Hi, I would like to import a csv file to my Database. The import should captured the Double Quotes(…

  yapafly

  3 replies

  13 years, 1 month ago

  By: John Mitchell-245523

• SQL Pivot Tables

  Hi I've been asked to create an SQL pivot table at work, and to be honest I have not seen this stuf…

  doyler61185

  2 replies

  13 years, 1 month ago

  By: doyler61185

• Execute output of the output

  Hello All, Is there a better (or more elegant ) way of executing the output of the output of the St…

  barsuk

  8 replies

  13 years, 1 month ago

  By: Orlando Colamatteo