T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Summing negative and positive values

  I'm having a bad brain day today and can't figure out why my query is returning seperate rows for n…

  Neil D Denton

  3 replies

  15 years, 1 months ago

  By: Neil D Denton

• Split source data in two tables

  Hi everyone, I have currently the problem that I want to make an data import from one source table.…

  Patrick_Fiedler

  2 replies

  15 years, 2 months ago

  By: Patrick_Fiedler

• Function inside a Stored Procedure

  I remember hearing that having functions in a stored procedure is no bueno. In the past I would jus…

  smallmoney

  3 replies

  15 years, 2 months ago

  By: Jeff Moden

• Compressing out consecutive runs of data quickly

  This is part of a long and much more complicated process, but I have tried to simplify it for posti…

  Ferguson

  2 replies

  15 years, 2 months ago

  By: Ferguson

• T SQL Trigger on certain columns

  I am looking for examples of an UPDATE query that will only fire if certain columns in a table are …

  GBeezy

  6 replies

  15 years, 2 months ago

  By: MysteryJimbo

• SQL QUERY using HAVING,GROUP BY

  Hi, I am new to SQL and I am still learning SQL. Please help me with this query . Here is the situa…

  NewBie23

  9 replies

  15 years, 2 months ago

  By: NewBie23

• How to write a circular function in T SQL for this scenario?

  Hi all, This is my first question in this forum. Please help me on following problem. Emp Table co…

  raj_paandy

  8 replies

  15 years, 2 months ago

  By: Ron McCullough

• Eliminating Duplicate Rows in SQL server

  Hi guys, I'm new to Sql Server. I have a question here.... I have a table with 6 rows here it goes.…

  sqlnew

  14 replies

  15 years, 2 months ago

  By: Sioban Krzywicki

• Case help

  I have a table table1 with CustomerID, OrderID, Address, AddressTypeID. So each CustomerID can have…

  varunkum

  2 replies

  15 years, 2 months ago

  By: varunkum

• error in select when converting to number and compare

  I have a table1 with it's fields all stored as text Name lastname Age ----- -------- ---- Jo…

  jaytaba

  3 replies

  15 years, 2 months ago

  By: Ron McCullough

• how to pass the bit value in parameters in ssrs2008

  Hi All, i am facing problem in my report, bellow sp working fine in SSMS but inmy report side i am …

  sambireddy chirra

  2 replies

  15 years, 2 months ago

  By: Ninja's_RGR'us

• way to check if windows auth user is real?

  I'm playing around with a little script to add new users. It's just for my own practice/learning fu…

  SQLSandwiches

  5 replies

  15 years, 2 months ago

  By: Ninja's_RGR'us

• *=

  I came across this syntax WHERE territories.regionid *= region.regionid what does *= mean??? I have…

  jameslester78-958147

  2 replies

  15 years, 2 months ago

  By: jameslester78-958147

• Do a grouping by year

  I am trying to write a script that will group by year based on a date: SELECT Count(qlkpApplicantWa…

  Arthur.Lorenzini

  1 replies

  15 years, 2 months ago

  By: Arthur.Lorenzini

• Studio Manager Editing

  Is there a way to edit more than 200 records in the grid in Studio Manager? Warm Regards, Arthur Lo…

  Arthur.Lorenzini

  3 replies

  15 years, 2 months ago

  By: Arthur.Lorenzini