T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• CONVERT(varchar(@MAXLENGTH),x) FROM y

  Not sure how to google for this ... proc outputs to text file. for formatting reasons only I want …

  snomadj

  5 replies

  14 years, 7 months ago

  By: snomadj

• RANK / PARTITION BY <range> Possible

  I've come across some code that fills a temp table in 3 parts CREATE TABLE #Tmp ( pKey INT, Sor…

  Tom257

  2 replies

  14 years, 7 months ago

  By: drew.allen

• filter by calcuated feild?

  I have a table with a list of unix timestamps. i'm trying to figure out how to list all values new…

  foscsamuels

  14 replies

  14 years, 7 months ago

  By: Sean Lange

• Very strange question ... with an unexplainable solution

  Hi all, Got a bit of an odd one here. I have a problem, which I have several solutions for. I just …

  kramaswamy

  4 replies

  14 years, 7 months ago

  By: kramaswamy

• Get result based on competition like FIFO

  I've tables and data as following, declare @t1 table (idx int identity, programID int, quota int, f…

  Qira

  4 replies

  14 years, 7 months ago

  By: Qira

• Not able to handle duplicates whild updation. Not as simple as you think..

  I have a problem with a data correction procedure. The username / password policy of company is cha…

  SQL Kidu

  4 replies

  14 years, 7 months ago

  By: J Livingston SQL

• Stored Procedure Parameters

  Hi all, In below code DbCommand dbCommand = db.GetStoredProcCommand("saveUpdate"); d…

  MuhammadShafiq

  1 replies

  14 years, 7 months ago

  By: Ron McCullough

• Horizontal filtering(or way to say it)

  Hello all, I've been diggin it everywhere but can't find result, maybe i am searching for the wrong…

  diditheouf

  1 replies

  14 years, 7 months ago

  By: Evil Kraig F

• IF (1=0) BEGIN SET FMTONLY OFF END

  Sorry for the rather undescriptive title, but I am not sure what to call this problem, aside from g…

  loki1049

  10 replies

  14 years, 7 months ago

  By: Andre Guerreiro

• Multi-Database View in SQL Server 2000 - Restricting Permissions

  Our payroll company stores detailed payroll for us in a SQL Server 2000 database (there's no chance…

  jvanderberg

  4 replies

  14 years, 7 months ago

  By: Elliott Whitlow

• PIVOT Function ?

  Hi, I have data in following format from my variable table ID ! TEXT -------------------…

  SQL_path

  1 replies

  14 years, 7 months ago

  By: GSquared

• Summation of amount in T-Sql

  Hello! Please run the queries below to get along. The users of the tables below want to see accura…

  SaintGr8

  17 replies

  14 years, 7 months ago

  By: SaintGr8

• lost bytes - BULK IMPORT

  Hi, I've got a problem with importing file. My web application store users files as data type image…

  bpecak

  1 replies

  14 years, 8 months ago

  By: PhilPacha

• Simple Equal not returning records but Like condition is

  We have a third party SQL 2000 Database which is suddenly giving strange results in that a simple e…

  SG Cowley

  8 replies

  14 years, 8 months ago

  By: Adi Cohn-120898

• XML into a table

  How do I do this? I have a XML data type with XML text in it. How do I view the XML as a table? I…

  Dan Guzman - Not the MVP

  13 replies

  14 years, 8 months ago

  By: pham_p