Topics
Started by
Posts
Last post
Sample data: create table #a (ID int identity (1,1) , AgentID varchar(10) , TransDate datetime , Ag…
4 replies
Okay. I'm stuck. Maybe it's because it's Friday and I'm seeing double, but here's my problem. I …
9 replies
Hello everyone. Got a question that I am not sure if anyone has ever done before. I have a crazy …
2 replies
I am trying to develop script for getting table names, row count for each table. I want to do do it…
7 replies
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
Viewing 15 topics - 8,506 through 8,520 (of 12,234 total)
You must be logged in to create new topics.