T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• Handling dynamic SQL Where clause in a SP

  Hi all, I hope this is not a stupud question but I can't seem to find a solution. I have a search t…

  eric-810666

  7 replies

  16 years ago

  By: WayneS

• Return txt from string

  Hi. I have a column in a database that lists license key information. The data (NVARCHAR (64)) is h…

  2Tall

  12 replies

  16 years ago

  By: 2Tall

• Randomizing some data

  So I've been working to randomize/anonymize some data so that I can use production volumes of my da…

  Luke L

  2 replies

  16 years ago

  By: Luke L

• Merge two records together that exist in one table

  I would like to merge two records that exist in a single table. I currently have all of the code i…

  Owen White

  2 replies

  16 years ago

  By: Owen White

• Struggling to engage brain! SQL code requiring a simple solution!

  I'm working on a SSRS project where the user will be able to select data based on 'Package', 'Date'…

  Dom Horton

  10 replies

  16 years ago

  By: Dom Horton

• "Order By" issue

  Hi, i have a table with one column of type varchar. Values inserted in it are '12th','9th','10th','…

  shyam.oec

  5 replies

  16 years ago

  By: sonaltotla

• OpenRowset import from excel to sql fails

  hi all i used to import excel data in my last job using the below OpenRowset statement, but when i …

  dopydb

  17 replies

  16 years ago

  By: dopydb

• Date Conversion

  Hi, I would like the results of this simple query to show just the 'Created Date' in dd/mm/yyyy fo…

  Shabba

  7 replies

  16 years ago

  By: Shabba

• Run Stored Procedure from VB

  Hi - I was wondering if anyone has a simple example of how you can run a stored procedure from VB? …

  Bosco2

  1 replies

  16 years ago

  By: Piotr.Rodak

• Query Help

  I have a table that contains a customer key, event code There is multiple customer key's and events…

  Stephen crocker

  3 replies

  16 years ago

  By: Stephen crocker

• Getting the database name that a trigger fired off from...

  I have a trigger that fires off on a ALTER_DATABASE, CREATE/DELETE DATABASE. The triggers are firi…

  John Waclawski

  1 replies

  16 years ago

  By: John Waclawski

• Patsing a string using a tally table

  HI all, I'm using some ciode I saw in a post here to return numbers from a comma delimited string. …

  allen davidson

  1 replies

  16 years ago

  By: Dohsan

• Tricky substring

  I have data which resembles below declare @msg varchar(200) set @msg = 'Merged Facility Id:6644- Pa…

  timscronin

  10 replies

  16 years ago

  By: Pete Cox

• How to restrict decimal numbers using select clause?

  Hi Friends, Here is my table structure- Table1 ColumnA ColumnB ColumnC 11111 …

  cvvikram 71819

  4 replies

  16 years ago

  By: cvvikram 71819

• SQL trigger per Order no..

  i all i have the below trigger, which sends an email when an order is released for picking. that wo…

  dopydb

  6 replies

  16 years ago

  By: Bhuvnesh