|
jbrook3708
Starting Member
3 Posts |
 Posted - 2001-06-25 : 19:25:06
|
| hi there,i'm having a problem with selecting a variable as a column name (so i can make it available to my ASP app.)here's the syntax - declare @temp varchar(8000)set @temp = '132,194,196,197,202,203,205,207,209,210,211,213,215,216,217,219,221,222,223,225,227,229,231,233,235,237,239,241,243,244,246,248,250,252,254,256,257,259,261,262,264,265,266,268,270,272,274,275,277,279,280,281,282,284,286,287,289,291,293,294,295,297,299,301,302,305,306,308,309,311,313,315,317,321,323,324,326,327,329,331,333,335,337,340,342,344,346,349,351,352,354,356,358,360,362,364,366,368,372,380,382,387,389,391,393,395,397,399,401,403,405,406,408,410,411,412,414,416,417,419,421,423,425,427,429,431,433,435,436,438,440,442,444,446,448,450,452,454,456,458,460,462,464,466,468,470,472,474,476,477,479,481,483,485,487,489,491,493,495,497,499,500,502,504,506,508,510,512,514,516,517,519,521,523,525,527,528,530,531,533,534,536,538,539,541,543,544,546,548,550,552,554,556,558,560,562,563,565,567,569,571,573,575,577,579,581,583,585,587,589,591,592,594,596,598,600,602,603,604,606,608,610,612,614,615,617,619,621,623,625,627,629,631,633,634,636,638,640,642,644,646,648,649,651,653,655,656,658,660,661,663,664,665'select @temp as id_listif you try running it in query analyzer - it stops at char number 256..why is that?if you replace "select @temp as id_list" with "print @temp" you get the full list.i would really appreciate some help with this.. we're running MS SQL Server 2000..thanks!jamie |
|
Select As problem...