Viewing 7 posts - 1 through 7 (of 7 total)
GilaMonster (2/3/2016)
You've given them names. First and Second in your code example. You can reference them by those names in the last query.What are you trying to do?
i want use...
February 3, 2016 at 2:43 am
how to set name for firest and second table?
my code is:
ALTER procedure [dbo].[test2] (@d1 int,@d2 int,@d3 int,@d4 int)
as
WITH first AS
(
SELECT dbo.card_in.id_reg, dbo.region.name_reg,...
February 3, 2016 at 2:23 am
i need result of select 1 and select 2 for last select
how to set name for first select and second select for use in last select
February 3, 2016 at 2:01 am
In this SP
SELECT TOP (@topval) dbo.bigtb.fire, dbo.maingroup.maingroup, dbo.bigtb.subgroup, dbo.maingroup.groupnamefa, dbo.subgroup.subgroupfa, dbo.bigtb.title1,
...
April 27, 2014 at 6:12 am
v_userpro is a View,
I dont use View,
I want use
SELECT fire, COUNT(id1) AS pageview
...
April 27, 2014 at 5:33 am
Viewing 7 posts - 1 through 7 (of 7 total)