T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Information displaying incorrectly.....

  Hi, I have 2 tables: CREATE TABLE [dbo].[GV_InwardAtStore]( [InwardAtStoreID] [int] IDENTITY(1,1) …

  kapil_kk

  1 replies

  12 years, 9 months ago

  By: kapil_kk

• the script that will enable you to create the new values for each of the measures listed above. The financial year end is 28 February 2011 Then confirm the Financial Year, Quarter, Month, Week and Weekday,please help

  i am not sure about this statements please help : CREATE PROCEDURE FinYear2012 @Cost_date date = '…

  engstevo

  1 replies

  12 years, 9 months ago

  By: Eugene Elutin

• Function to replace string 'NULL' with null value

  Hi I am selecting values to one table and populating them in another table, and I'm using a case st…

  hoseam

  2 replies

  12 years, 9 months ago

  By: hoseam

• substring comparison for last 2 characters

  I have a field with data like below I need to join on patid 123453 124344ME 323390 3233MS I need to…

  timscronin

  21 replies

  12 years, 9 months ago

  By: Dwain Camps

• Urgent help with Date comparison in TSQL

  Dear friends, I have requirement - to retrieve order from database that were created before 12:00 …

  dhananjay.nagarkar

  11 replies

  12 years, 9 months ago

  By: dhananjay.nagarkar

• Dynamic Vertical Rows to Horizontal

  I read through the following topic already, and it has moved me MUCH closer to the solution that I'…

  N.B.

  7 replies

  12 years, 9 months ago

  By: N.B.

• Need to derive avg execuion time for 3 tables

  [font="Courier New"] Need to derive avg execution time per row in table for each tablename. Sample…

  Express12

  4 replies

  12 years, 9 months ago

  By: Erin Ramsay

• Extract first numeric value from a string

  Brothers, I need to parse the first numeric value from a string that usually contains several numer…

  valeryk2000

  33 replies

  12 years, 9 months ago

  By: valeryk2000

• Test

  Testing

  smithmich

  1 replies

  12 years, 9 months ago

  By: Erin Ramsay

• Query - literal date vs local variable

  I have a query that pulls invoice data. I'm looking for invoices with an invoice date > blah (w…

  sqlpadawan_1

  2 replies

  12 years, 9 months ago

  By: sqlpadawan_1

• Write a SQL statement that will return all the Sales Orders for the Salespersons’ with the name starting with ‘John’.

  Write a SQL statement that will return all the Sales Orders for the Salespersons’ with the name sta…

  engstevo

  1 replies

  12 years, 9 months ago

  By: Lowell

• how to insert foreign key value in my table?

  Hai friends, i ve two tables create table users ( users_id int primary key, username varchar(20), …

  raghuldrag

  4 replies

  12 years, 9 months ago

  By: HanShi

• sql query questio

  I have 2 tables Case CaseID Name ------------------- 12341 XYZ 23451 ZZZ 90892 …

  kk1173

  6 replies

  12 years, 9 months ago

  By: Dwain Camps

• Find lowest populated field, not min value

  Hi all, I have a tricky one. I have a dataset as below which deals with airport delays. CREATE TA…

  derrysql

  2 replies

  12 years, 9 months ago

  By: Evil Kraig F

• Move Log file

  Hi, I have data file and log file at different location. data file at location: D:\Folder1\test.mdf…

  kapil_kk

  9 replies

  12 years, 9 months ago

  By: kapil_kk