Topics
Started by
Posts
Last post
I have inherited a system which has very few tables with indexes. One table has 18K rows, expected…
2 replies
I am trying to create a script file that will get me the total number of orders in july. How exactl…
8 replies
I am trying to get Start date for this week and the coming 3 weeks. For this week this is what I ha…
6 replies
I am making a stored procedure with 2 optional parameters customerid and companyname eith a custome…
5 replies
Hi, I am having table with below data. create table #temp (id int, name varchar(10), name1 varchar(…
4 replies
I am working on a delete statement that has 2 separate conditions. I have to delete from my orders …
24 replies
I need to divide a number by the number of full weeks based on today's date. Say today is April 30 …
9 replies
Does datediff hinders performance in queries. I am trying to access the records and it takes almost…
9 replies
I have a script that updates assignments of closed help desk tickets and I modified it and now it u…
1 replies
I have table, ordered by weeknumber, one column contains data I need to test for. The data column t…
5 replies
Hi all, I have this stored procedure but everytime I run it - the output is a whole number but I wa…
2 replies
I have created a database where an employer coop program hires students. I came up with 4 tables e…
10 replies
I am loading a table thru a store Proc but now we need to add another Column to that SP to be loade…
2 replies
I am hoping someone can assist me with a dilemma; I am trying to exclude records that have an asses…
7 replies
Hi Expert, Today my Application server was too much slow , even user was not able to work on any ap…
3 replies
Viewing 15 topics - 586 through 600 (of 5,050 total)
You must be logged in to create new topics.