T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• is possible to put a instruction declare inside in a view??

    for example is possible to do that??? CREATE view CVW_Callas as   declare @a int selec…

  Hector Angello Silva Carmona

  4 replies

  18 years ago

  By: noeld

• How do I identify movements form one level to another

  Hi Guys I have got a patients table which describes how a patient moves from one service to another…

  Nuts

  4 replies

  18 years ago

  By: SwePeso

• Return rows by AND/OR

  OK, I've used a solution using ColdFustion that resolves my problem and I want to convert ColdFusio…

  David Diener

  3 replies

  18 years ago

  By: David Diener

• Query to determine public access

  Is there any T-SQL Script or SP that would determine what tables public users have access to? I on…

  Kyle Schlapkohl

  1 replies

  18 years ago

  By: Andras Belokosztolszki

• Very confusing problem..Please help me friends!!

  Hi Guys I have got a table of patients where each patient has got a unique patient number.There are…

  Nuts

  6 replies

  18 years ago

  By: Nuts

• get the maximum value from a query with a join

  friends i need to get the maximum value from a query which is composed with a join   example s…

  Hector Angello Silva Carmona

  2 replies

  18 years ago

  By: Hector Angello Silva Carmona

• Selecting last two orders

  Hi all. I am having a brain meltdown. I am trying to gather the last two orders for a customer. Wou…

  David Tyler-455966

  20 replies

  18 years ago

  By: David Tyler-455966

• Simple but tricky String Concatenation issue

  I have two columns Country and CompanyName. Table looks like this: Country    &…

  Justin-14543

  8 replies

  18 years ago

  By: Justin-14543

• Invalid Object Problem dynamic(CTE) Paging

  Hi there, I'm new to T-SQL and i'm trying to implement the efficient paging method outlined in scot…

  at work

  7 replies

  18 years ago

  By: Matt Miller (4)

• conditionally store triggers status in temp table

  I'm looking for generic script which will  selectively  store status of triggers  in…

  vision59

  1 replies

  18 years ago

  By: SwePeso

• Combining two varchar fields to one datetime

  I know this is simple to you who have been around, but it is driving me buggy.  I have tried a…

  Tom Adams-483355

  11 replies

  18 years ago

  By: David McFarland

• Can this query be optimized

  Hi.......... the query that i have made calls the same table with condition 'processing_date <= …

  Sameer Sait A

  15 replies

  18 years ago

  By: Tomm Carr

• Unable to execute dynamis SQL from within a UDF leaves me with a problem

  Hi all I have a problem which would be easily solvable if I could execute dynamic sql from within a…

  Bradley Cotier

  4 replies

  18 years ago

  By: Bradley Cotier

• Variable parameter lists in functions

  I don't think this is possible, however I will pose the question just in case.... I am converting a…

  Brian Jones-401554

  4 replies

  18 years ago

  By: Brian Jones-401554

• what''s my name?

  Hi All, Does a stored procedure know it's own name at run time?  I would like to be able to h…

  Elliott Berkihiser

  3 replies

  18 years ago

  By: Elliott Berkihiser