Topics
Started by
Posts
Last post
Hi All, I was trying to use partitioned index for a slow query but I was stopped with fol…
9 replies
Hi All, I have created a function (Func_GetSeqValue) which is creating a Sequential number. Here is…
2 replies
truncate table
6 replies
I am trying to join three tables together to get a sum from one table, count from second table, and…
5 replies
hi, Bad situation that I can't get out of, but, I am able to get the data below extracted from a st…
9 replies
Hi Friends, Pls help me out ... create table sample ( name varchar(100), Mark1 int, mark2 int, mar…
22 replies
My count is incorrect when I do this query: SELECT Records.JulianDate, Records.Records, COUNT(sale…
5 replies
Hi, I have a similar situation as in the following code where i want to materialize future due ord…
5 replies
Hi All We have some really large tables(100s of GB) in our Datawarehouse and have decided to partit…
8 replies
Hi Guys, This should be simple but I've spent too much time on it and can't see the solution. Tried…
5 replies
I want records for datetimes between 01/01/2000 (after midnight) through 01/03/2000 (through midnig…
9 replies
Table looks like this.... employeeId, Activity, StartDateTime, EndDateTime 12345 …
5 replies
Good morning I needed to make a stored procedure for maintaining a database SQLServer 2008. The ide…
3 replies
I need to write a SQL when i pass Max & Min Date like (2013-04-01,2010-01-01) i should get bel…
2 replies
I need to create a field that looks at calculation based on the client. My code below needs to app…
1 replies
Viewing 15 topics - 4,711 through 4,725 (of 4,984 total)
You must be logged in to create new topics.