Topics
Started by
Posts
Last post
How can I use datepart to select records between a certain date range without having to hardcode th…
4 replies
I have data stored in a table as follows: ProjectNOIYear 24-21.672007 24-1.632006 2441.4920…
4 replies
I am trying to convert code over to use the native XML data type instead of using sp_xml_prepare…
1 replies
After moving the nonclustered indexes to seperate disk array on secondary filegroup the CPU usage i…
4 replies
I came across a strange problem in which two nearly identical queries behave very differently. Can…
3 replies
Hi, i use a sql 2005 database where we stored phone call historic notes. The detail of the phone ca…
11 replies
Hello I have this value in a number of rows within a table, P406600; and i will like to delete the …
5 replies
How do i resolve collation errors. Msg 468, Level 16, State 9, Line 23 Cannot resolve the collation…
3 replies
I need to produce small reports as per Users request. Here is my table structureCREATE TABLE [dbo].…
10 replies
Hey guys, here's the problem: I initially wanted to implement a trigger that fires BEFORE the execu…
5 replies
Re: WHERE clause evaulation and resulting execution plans When I execute the following queries with…
4 replies
I have a customer on either SQL 2000 or SQL 7 that's running old software I'm trying to review for …
2 replies
I'm trying to load a table from a view. The target table is currently empty and has the following b…
4 replies
i have a column name --- ordernumber varchar(13) from table1 all i want to know is how many of them…
21 replies
I have a table called ptAppointments and a table called ptSchedule. We want all records that are in…
3 replies
Viewing 15 topics - 8,476 through 8,490 (of 12,234 total)
You must be logged in to create new topics.