T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• insert value generate special character => xml file contains bulgare language !

  Hi, i'm a beginner with t sql. I have a web page where the user can select the language (FR, EN, BG…

  christophe.bernard 47659

  3 replies

  12 years ago

  By: Mike John

• How to calculate sum value in these table

  create table cust_details ( id int , city varchar(20), cust_name varchar(20), sales int ) insert in…

  raghuldrag

  2 replies

  12 years ago

  By: MyDoggieJessie

• Count distinct values - help needed.

  Hi everyone. Can someone offers some advice on how to achieve this. I need to count the number of r…

  MickyD

  9 replies

  12 years ago

  By: ChrisM@Work

• avoid self join

  i would like to do display results as below. I can achieve results by self joining back, is there a…

  mxy

  8 replies

  12 years ago

  By: Jeff Moden

• How to add up the monthly total?

  Here is example table and data CREATE TABLE [dbo].[sales]( [date_value] [datetime]NOT NULL, [mont…

  Seattlemsp

  6 replies

  12 years ago

  By: Seattlemsp

• need help on convert function dates

  hi all, please help me to get this out put. details: declare @deadline Datetime = '2014-03-23 15:30…

  kbhanu15

  2 replies

  12 years ago

  By: kbhanu15

• Performance nehancemnt in writing the SQl query

  I have written my query like this: select a.ID, a.Name from Table2 b INNER JOIN Table3 c on b.ID =…

  VSSGeorge

  6 replies

  12 years ago

  By: MysteryJimbo

• Need to write query to get Steps in custom job that have not completed

  I have the following: create table testdata ( StepName varchar(25) ,StepStatus char(25) ,EntryDat…

  jamie_collins

  5 replies

  12 years ago

  By: Dwain Camps

• Cannot create index on view 'ViewTicket' because the view uses an implicit conversion from string to datetime or smalldatetime. Use an explicit CONVERT with a deterministic style value.

  Hi Team, Please advise.... Step 1 Created View CREATE VIEW [dbo].[ViewTicket] WITH SCHEMABINDING…

  ghitpro

  2 replies

  12 years ago

  By: mickyT

• Taking long time to executing after created table valued functions as my scripts

  Hello, I have one Table valued functions FN(@param1,,,,,,) . When, I try to selecting the function…

  Saravanan_tvr

  4 replies

  12 years ago

  By: Grant Fritchey

• compare records in tables

  There are four tables 1. Matter MID, CID, RType 001, a, m 002, a, m 003, b, m 004, c, m 2. Category…

  Seattlemsp

  18 replies

  12 years ago

  By: Seattlemsp

• how to GROUP BY with shortest Distance by AccountNumber

  Given the following example; declare @CustIfno table (AccountNumber int, StoreID int, Distance dec…

  Geoff A

  7 replies

  12 years ago

  By: mickyT

• SQL Agent Job - Send SSRS Report Based on Certain Criteria

  I have an SSRS Report that I created. I'd like to set up a job that will run every hour, and what t…

  joshdbguy

  3 replies

  12 years ago

  By: SQLRNNR

• Update rows

  I have a scenario: I have a table tablAA with column IDA which is get referened in some other table…

  kapil_kk

  6 replies

  12 years ago

  By: mcx5000

• 'New Line' - logic

  I am trying to format to paragraph of output to be used in an email, I have the static portion in a…

  TryingToLearn

  5 replies

  12 years ago

  By: TryingToLearn