T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Is there a "tables collection" in T-SQL?

  I'm not even sure how to ask this question. I'm an ASP.Net/C# developer who uses Management Studio…

  brad.woody

  9 replies

  14 years, 5 months ago

  By: Jeff Moden

• Passing a Var to SP that needs B-up and

  I am passing a string var to a SP. that string Var has a value of 4,11,12 I am trying to get al…

  Trav williams

  11 replies

  14 years, 5 months ago

  By: drew.allen

• info required ..

  hey i want to know when ever we drop a table then its indexes automatically droped or not ?

  faruk.arshad

  4 replies

  14 years, 5 months ago

  By: ghanshyam.kundu

• Help! Conversion Failed when converting the varchar value...

  I am trying to update a table (TRANSACTIONS) based on the matching rows in a view (DONORS). DONORS …

  hkflight

  7 replies

  14 years, 5 months ago

  By: hkflight

• update row according to previous row

  Hi I had a problem for updating a row according to previous row. My table looks like this: ID COU…

  memostone86

  4 replies

  14 years, 5 months ago

  By: memostone86

• T-SQL Query

  Dear Friends I have a to make a T-SQL query to display the employee name and login duration. Explan…

  Sy-1148362

  5 replies

  14 years, 5 months ago

  By: Ken McKelvey

• Question regarding updating a table with staging table data

  Good Morning, We're working on automating a system where users will upload data from a spreadsheet …

  Nunnery

  3 replies

  14 years, 5 months ago

  By: Nunnery

• Non-aggregated in aggregate function

  It's too long to explain the business reason for my problem, so I'm using Northwind to illustrate. …

  Amy.G

  9 replies

  14 years, 5 months ago

  By: Amy.G

• Getdate function not returning data

  Hello, I'm trying to return data for the current month(October 2011) but i cant seem to get it to …

  Jnrstevej

  14 replies

  14 years, 5 months ago

  By: Jared

• Update previous value

  Hi, how to update null with previous value. ITmField1 Result 254689AAAA aaaa 25469…

  gugan_ta

  6 replies

  14 years, 5 months ago

  By: irobertson

• using varchar and char

  hey guys, I'm just confused on this data types (varchar,char) If a value shorter than the length of…

  Teemo

  11 replies

  14 years, 5 months ago

  By: GSquared

• Joins

  Hi Guys When referring to joins.... There is a left and right table Where is this specified, in the…

  SQLSACT

  7 replies

  14 years, 5 months ago

  By: muthukkumaran Kaliyamoorthy

• Creating a function to replace symbols with HTML names

  Hi guys, This is an interesting problem that I'm trying to solve that we normally do in C#, but for…

  Derrick Smith

  6 replies

  14 years, 5 months ago

  By: drew.allen

• Location lookup query

  Hi Experts, I am working on one GPS based application,need your assistance here. my requirement is …

  fawwad

  7 replies

  14 years, 5 months ago

  By: Sean Lange

• Table joins to return non repeating values

  I'm trying to figure out the best way to accomplish the following situation: Table 1 has two column…

  tmitchelar

  7 replies

  14 years, 5 months ago

  By: tmitchelar