• T-SQL with Recursion – Display top ID on all levels below (To: Kent Milligan)

    Hell Kent, I read through "V5R4 SQL Packs a Punch" http://www-03.ibm.com/systems/resources/systems_i_software_db2_pdf_rcte_olap.pdf    I would need the query in figure 20 and the result in figure 21 which do not show up in the article.  I have a query similar to the example (parts of an iSeries...

    Cavallino30 pointsBadges:
  • Parameter in select statement

    Hi, I need to pass a parameter into a stored procedure which values are dynamic always. Executing a variable which having the Select statement. Following query working fine. BEGIN DECLARE @strQuery NVARCHAR(MAX) DECLARE @CountryId INT DECLARE @CityId INT SET @CountryId = 2 SET @CityId = ' AND...

    Plugsharma40 pointsBadges:
  • iSeries accessibility to VB.NET, ASP 2.0/3.0 ,NET programmers in Visual Studio

    My shop does not have WebSphere but does have a sizeable VB.NET team using the MS Visual Studio. They need access to the iSeries files in DB2/UDB - real-time. We already thanks to me have a number of batch/DTS package type transfers. Do any of you know packages that can make the iSeries files...

    JohndeCoville0 pointsBadges:
  • tutorials

    hi all. i wanted to ask if anyone knows any sites where i can download free ebooks or free tutorials. thx.

    Mmm5550 pointsBadges:
  • How to split a column into SQL data..

    I have table called  country having one column called complete_name (varchar(max)) which is as under   [table style="border-collapse: collapse;" border="0" cellpadding="0" cellspacing="0"> [tbody] [tr] [td style="border: medium none #d4d0c8; padding: 0in 5.4pt; background-color: transparent;...

    Anamika8315 pointsBadges:
  • SQL indexes

    hello, there are many indexes clustered an non clustered .so how can i see the result of each index, clustered and non clustered seperately through (T-SQL) pls guide me. RINO

    Fhhdjfhjdhfjhjdfh135 pointsBadges:
  • Automate TSQL Query Output

    I want to have a stored procedure run on a schedule that automatically creates a database output file as a result and saves it to a specific location on my network. Can someone please tell me how to do this?

    Eabouzeid175 pointsBadges:
  • SQL Server schema

    Hi,    How can i get the user names assigned to the Schema through (T-SQL) Regards; Rino

    Fhhdjfhjdhfjhjdfh135 pointsBadges:
  • Multithreading T_SQL

    I have to pool data from 1000+ sites on different physical servers through a web service running on each server. What is the best way to do so using T-SQL so that the multiple threads/processes run in parallel

    Rajeevraina5 pointsBadges:
  • difference between t- and pl sql lang

    in both t-sql and pl/sql we can use if/else condition and jump into other statements..then actually what makes the difference between t- and pl sql lang?

    NidheeshPV5 pointsBadges:
  • passing data between two SQL Server databases

    I am having an issue to passing data between two SQL Server databases.  I can not simply use Import/Export functions or Data Transfer Functions from SSIS because I was asked to transfer “20%” data with more than 15 criteria among 200 related tables.  Also we are not allowed to use the...

    LL12325 pointsBadges:
  • Set identity to not for replication in T-SQL

    Hi, Does anyone know the TSQL to change the identity column on a table in SQL Server 2000. And also the TSQL to change trigger to not for replication. Thanks

    Db23290 pointsBadges:
  • SQL select loop list?

    Say I want to derive the following: Select ID, F1 from table Union Select ID, F2 from table Union Select ID, F3 from table Union … etc until F10. Is there smart and easy way so that I can just provide a list: F1,F2,F3,…,F10 and somehow be able to have the select statement loop through it? Also,...

    Vinical5 pointsBadges:
  • T-SQL query to ACESS 2007 database

    I need examples of T-SQL queries running on SQL Server 2005 that retrieve data from a MS ACCESS 2007 Table. Any explanations are appreciated. Thanks

    DamMan5 pointsBadges:
  • Variables in T-SQL

    Hi, I want to know y does the following script run in SQL and not in T-SQL DECLARE @tblName varchar(30) SET @tblName = CONVERT(VARCHAR(20),GETDATE(),112) + 'Table' DECLARE @sql nvarchar(4000) SELECT @sql = 'CREATE TABLE "' + @tblName + '" ( ID VARCHAR(15), Name VARCHAR(15) )' EXEC(@sql) go it gives...

    Babar198220 pointsBadges:
  • Capitalize First Character

    How can ensure that when certain columns in a row are INSERTed/UPDATEd, the first letter of the value is capitalized and the rest are lower case? For example "QUESTION" or "question" should be converted to "Question".

    VelameLaCosa110 pointsBadges:
  • DBCC CHECKDB

    before runing DBCC CHECKDB WITH repair_allow_data_loss, How can i know what table and data that will be deleted

    Sreenu125 pointsBadges:
  • question: T-SQL stored procedure conversion to C# CLR assembly….

    I'm wondering why it is difficult to find an example ( in literature or Internet ) example of converting a T-SQL procedure which contains "out" variables into identical C# CLR stored procedure. Is there something which prohibits this conversion ? If not, can someone provide or cite example ? Real...

    Tann5 pointsBadges:
  • stored procs in Master db, sql server 2005

    Does anyone know where I can get a list describing, in layman's terms, all the sp_usr... stored prodedures in the Master database? New to all this and don't have the time or knowledge to decipher the TSQL behind it. Hope someone can help! Cheers

    GillsJules5 pointsBadges:
  • DATEDIFF – 1 year off

    I need to figure out age from a birthday. When I use the DATEDIFF function for year, the number of years is one year ahead if the birthday hasn't passed yet for this year. How can I get the accurate age based on the day and month of the birthday.

    Bananahead60 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following