T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• T-SQL Pivot Help with weekly intervals

  Hi There, I am very new to Pivot tables and have seen a few examples in practice however none like …

  Blugecko

  7 replies

  14 years, 10 months ago

  By: Blugecko

• How to replace accented characters with non-accented ones

  Hi, I am looking for a SQL function which converts (not remove) a string containing accented charac…

  xavier.villafuerte

  6 replies

  14 years, 10 months ago

  By: Paul White

• help regarding getting more than one output data using stored procedure

  Hi i am trying to retrieve output data last name using the stored proc CREATE PROCEDURE dataretrive…

  Smash125

  2 replies

  14 years, 10 months ago

  By: Paul White

• SQL 2008 RAISERROR within CATCH not propagated to C# Caller

  I have generic error logging SP that I call from SPs CATCH block to log the error and then ReRaise …

  Gadgetman Stewart

  1 replies

  14 years, 10 months ago

  By: Paul White

• Difference between Namespace & Schema

  Hi, I just wanted to know that are namespace & schema interchangable(similar) in SQL Server 20…

  adhondiyal

  1 replies

  14 years, 10 months ago

  By: Vedran Kesegic

• View based on View doesn't have dependancy?

  We were trying to generate a script to create our database and it fails because of the order it is …

  loki1049

  1 replies

  14 years, 10 months ago

  By: loki1049

• Output all data in single column

  Greetings, CREATE TABLE Test ( Code char(1), Name char (3), Data int ) INSERT INTO Test SELECT '…

  Chrissy321

  5 replies

  14 years, 10 months ago

  By: Chrissy321

• Time Zone Dilemma

  My SQL server is in Pacific Time. My branches are all over the country. I can determine based on …

  SQL_Enthusiast

  4 replies

  14 years, 10 months ago

  By: SQL_Enthusiast

• Unable to Aggregate by name to generate SUM totals

  Populated a table with results from a sys.dm_io_virtual_file_stats query run across the entire MSS…

  Martin Sherwood-301653

  2 replies

  14 years, 10 months ago

  By: john.arnott

• Northwind Querry INNER JOIN GROUP BY

  I'm working on a tutorial which ask the following: Create a report that shows the total number of o…

  eh936

  13 replies

  14 years, 10 months ago

  By: eh936

• ERROR cursor:The cursor does not include the table being modified or the table is not updatable through the cursor.

  Hi I get the above error putting adding print statments in the code for the cursor I've written oth…

  yoho23_2000

  2 replies

  14 years, 10 months ago

  By: drew.allen

• Formatting Email Query Data

  I'm running a query via sp_send_dbmail. In Outlook, it would show up in Courier, so all the column…

  homebrew01

  3 replies

  14 years, 10 months ago

  By: GSquared

• generating a string with values from database table

  I have the following string. http://tgl.test.com/plc/login/confirm.asp?c=1&ftr=0&lvert=12…

  sql_novice_2007

  4 replies

  14 years, 10 months ago

  By: sql_novice_2007

• query an xml file !?

  Hi all, i'm a beginner with t sql .. i have a xml file with some attribute and i'd like to get thes…

  christophe.bernard 47659

  6 replies

  14 years, 10 months ago

  By: christophe.bernard 47659

• msg 15151, cant find user dynamic sql

  I have 2 databases. Database A and Database B. In Database A, I have testuser with read,write,ddlad…

  dallas13

  8 replies

  14 years, 10 months ago

  By: dallas13