Topics
Started by
Posts
Last post
Hi, I have a Photo Database, with a Photo table. Each photo has several Varchar fields for storing …
2 replies
Hi, I have a database on a 2000 server which is storing numeric data using the float datatype, all …
3 replies
I have a query that performs multiple FTS on SQl 2005 and I would like to use indexed view to optim…
3 replies
if i have a table where the date is an index does retrieving rows like the query below disregard th…
6 replies
I am trying to modify an existing view to convert it to a monthly view from a "bi-weekly" view (rep…
3 replies
I have a table where I need to increment the year of a datetime field by one year. The rest of the…
2 replies
I want to return an different column for each row having a MAX(). There doesn't seem to be an intu…
10 replies
Hi! I'm writing a simple update trigger, whenever one field changes, i update a date, et change bac…
2 replies
I have 4 tables Product - ProdID, ProdName Location - LocID, LocName ProdLoc- PLID, ProdID, LocID …
11 replies
Greetings all, I need some help with a T-SQL statement which will return a range of rows based off …
4 replies
On insert of few thousand record iam facing a primary key voilation error. Is there any metord to s…
2 replies
Hi All, I have XML string stored in database column, by parsing the XML string I need to get some v…
2 replies
I thought for sure that SQL Server 2005 had a row count function that displays the row number for e…
7 replies
Hello I need in TSQL code to return the following example : Total of Sails between : 01-11-2007 and…
9 replies
Good Morning Everyone, I have stored salary amount as varchar in my table and now i need to convert…
2 replies
Viewing 15 topics - 11,701 through 11,715 (of 12,234 total)
You must be logged in to create new topics.