T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Question about the behavior asigning values to variables

  I found an isue when i was programing a stored procedure. I belived that the behavior in both cases…

  freyes

  9 replies

  14 years, 6 months ago

  By: mr_opto

• simple sp

  Hi I have two Tables: Table1: ID1 Int FileNumber Int Table2: ID2 Int F…

  nazaninahmady_sh

  7 replies

  14 years, 6 months ago

  By: Jeff Moden

• Currency conversion calculation

  Hi, I have been cracking my head on this and need some help on currency conversion calculations fro…

  yingchai

  4 replies

  14 years, 6 months ago

  By: yingchai

• Looking for a way to insert to a table that requires a field in another table to be created as part of the same process

  Hi There, I am struggling to find a way to insert into a table that has a field that is dependent o…

  chris.king

  7 replies

  14 years, 6 months ago

  By: R.P.Rozema

• Currency conversion calculation

  Hi, I have been cracking my head on this and need some help on currency conversion calculations fro…

  yingchai

  1 replies

  14 years, 6 months ago

  By: LutzM

• Getting accurate row count for a table

  I've found a lot of conflicting information about the accuracy of different methods for obtaining a…

  md23

  6 replies

  14 years, 6 months ago

  By: Ninja's_RGR'us

• Using IN operator in Then clause of sql case (inside where)

  case statement

  jaya

  4 replies

  14 years, 6 months ago

  By: jaya

• Running totals

  Hi there, I have a problem with running totals. Lets say I have a salesman 'bob' who sells a produc…

  cidr

  27 replies

  14 years, 6 months ago

  By: Jeff Moden

• Sequence creation

  Hi, I need to populate the values for a column in a sequential manner as below, these need to be au…

  SQLServerMS

  29 replies

  14 years, 6 months ago

  By: LutzM

• 2nd highest value in dataset

  Hi I have been assigned a task at work in a hospital. I have to look at patients who atttend accid…

  LoosinMaMind

  5 replies

  14 years, 6 months ago

  By: LoosinMaMind

• add new column to a table

  I have a critical database. And now I would like to add a column to the table, is it good to add a…

  sqlfriend

  5 replies

  14 years, 6 months ago

  By: spaghettidba

• passing date parameter as Today, Yesterday, this week, last week to SP in from date and to date

  i have to make query for following: this would be populatede in a dropdown and passed as single par…

  Shamshad Ali

  1 replies

  14 years, 6 months ago

  By: J Livingston SQL

• nvarchar column length...

  For the below table create script, the column length is specified as 255, for a nvarchar column, wh…

  s-sql

  2 replies

  14 years, 6 months ago

  By: Jeff Moden

• Columns and rows into one Column

  Hi I got a scenario where i should iget all the columns and their respective vaules in that rows to…

  tripri

  3 replies

  14 years, 6 months ago

  By: toddasd

• Generate Dynamic script

  Hi, I need to execute the below command in 50 databases and want to generate a dynamic script for t…

  Mani-584606

  1 replies

  14 years, 6 months ago

  By: Sean Lange