Topics
Started by
Posts
Last post
Is it possible to have a view that does not refresh on ever request, but refresh only when the data…
1 replies
I have a db with 12 tables for the each year (2005, 2006, 2007. 2008-till september) and I need to …
14 replies
OK, we are querying a table called ptSchedule. In this table is data from a schedule of Appointment…
16 replies
We have a table "Account Reference" that is keyed by "Division", and a user has entered all informa…
7 replies
Hello, I have a table that contain 10 lakhs of data. when i tried to retrieve that …
18 replies
I am trying to create a query. Simplified, it looks like this declare @wh int set @wh=1; select ob…
35 replies
I have this view viewALL that gets information based on 4 weeks from the days date. SELECT TOP…
10 replies
hello, what is the difference between the NCHAR() AND NVARCHAR() Regards: Dastagiri.D Thanks …
2 replies
Hello, I need to pivot table, but pivot operation requires agregation function, in my case I does n…
8 replies
Hi, I have a table which has some null values in "name" and "surname" columns. I use a function …
7 replies
Can a DECLARE statement be used inside a CTE to create a local variable?
5 replies
I am trying to create a column in a temp table (stored procedure) with a counter based on certain v…
8 replies
Hi Folks, i use the table Person.address from adventureworks. i add a column "Datei" with the datat…
18 replies
hello , I am working on the Profiler and increase performance of the queries. "A QUER…
3 replies
I have a log table, that contains a Detail column which looks like this... auth=2 ms,xslt=110 ms,wa…
3 replies
Viewing 15 topics - 8,506 through 8,520 (of 12,230 total)
You must be logged in to create new topics.