Topics
Started by
Posts
Last post
Why doesn't this work SELECT * FROM #NEWTEMP UNION SELECT asg.ASGN_STAT_CODE, asg.ACTUAL_STAR…
9 replies
I have used Views to setup the links to match data files that I want to pull data from. I have a la…
4 replies
Basically, we have a "Router" table with PK: RouterID and FKs: SiteID, TierID, IpID, LanID that rel…
4 replies
with the bellow query it has worked for SQL 7 for ages a but now i'm testing it on SQL 2000 the que…
25 replies
When I CREATE a table in SQL Server and then DROP it, have I used up some memory that is not recove…
1 replies
From QA ver. 8.00.760 CREATE TABLE #s1(seqnum int) insert into #s1 values (1) drop #s1 Run above co…
1 replies
Greetings, I am curious if anyone has thoughts about an update trigger that when fired, updates the…
7 replies
Hello. I was wondering if anyone out there can help me out. I'm pretty new to all this so I'm not s…
2 replies
I have a table in my SQL 2000 DB that logs visitors to my website. Here are some of the values that…
3 replies
I need to call a single method from a C# DLL from a trigger. Has anyone done this? I did some rese…
1 replies
I am looking for a way to sequentially number the rows returned from a query, I have an identity fi…
4 replies
The following query works for Views that are under the 4000 character Nvarchar limitation; SELECT…
3 replies
Can any one help me with this little problem. I have a datetime field in a database. it's a datet…
5 replies
why does this return ERROR "invalid column name 'profit' " code: Sum([intquantity]*[curcost]) AS Co…
3 replies
I'm running a VB front end with SQL Server database. Im currently converting from an Access databas…
2 replies
Viewing 15 topics - 3,571 through 3,585 (of 4,455 total)
You must be logged in to create new topics.