Viewing 15 posts - 12,556 through 12,570 (of 26,486 total)
How obscure can some questions really get?
ok.this is simple question but nee dhelp.
i need something like untill there is value the loop should go.
i cant give any condition
suppose files
item1
item2
item3
the loop...
April 23, 2012 at 1:52 pm
GilaMonster (4/23/2012)
Lynn Pettis (4/23/2012)
Sometimes, however, using a function makes sense when the same code is used in multiple queries as it makes it easier to localize changes.
Providing it's an...
April 23, 2012 at 1:45 pm
If you would still like to use a function, give this a try. It isn't coded as a catch all query.
CREATE FUNCTION [dbo].[itvf_TransTotal]
(
@ClientId int,
@AcType varchar(5),
@OnDate Date
)
RETURNS TABLE WITH...
April 23, 2012 at 1:34 pm
Jeff Moden (4/23/2012)
Lynn Pettis (4/22/2012)
Revenant (4/22/2012)
Lynn Pettis (4/22/2012)
Revenant (4/22/2012)
Lynn Pettis (4/22/2012)
April 23, 2012 at 12:32 am
Koen Verbeeck (4/22/2012)
Lynn Pettis (4/22/2012)
Revenant (4/22/2012)
Lynn Pettis (4/22/2012)
April 23, 2012 at 12:06 am
Henrico Bekker (4/22/2012)
Excuse me if this sounds like a product punt, but BI Documenter from Pragmatic is an excellent documenter tool..
I think the question is a lot more basic than...
April 23, 2012 at 12:04 am
Revenant (4/22/2012)
Lynn Pettis (4/22/2012)
Revenant (4/22/2012)
Lynn Pettis (4/22/2012)
April 22, 2012 at 11:56 pm
niha.736 (4/22/2012)
If you are comparing 2012 April data and 2011 April data if 2011 april is null then u need to compare with march 2011 data,how to achieve it.?
Why would...
April 22, 2012 at 11:50 pm
anil.janu143 (4/22/2012)
//this is my tablecreate table std_table
(
id int,
name nvarchar,
address nvarchar,
)
//this is my table data
10 null null
null anilkuar null
null null hyderabad
//i want the data like this
10 anilkumar hyderbad
Your table has...
April 22, 2012 at 11:47 pm
Revenant (4/22/2012)
Lynn Pettis (4/22/2012)
April 22, 2012 at 11:34 pm
Sometimes I wonder if some people posting questions even try to solve their own problems. Doesn't help when they start mixing code posted by others with their own and...
April 22, 2012 at 10:22 pm
Viewing 15 posts - 12,556 through 12,570 (of 26,486 total)