Topics
Started by
Posts
Last post
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
Here is my problem: I currently have a cursor-based solution to read from 3 different databases an…
7 replies
How do I calculate Median value for a set of records using a simple query. Thanks in advance for yo…
13 replies
Anyone have a good way of finding non-alphanumeric characters in text/character fields without havi…
12 replies
Hello, I have a table with the following data: store, articles I need to know how many articles in…
10 replies
Viewing 15 topics - 11,701 through 11,715 (of 12,230 total)
You must be logged in to create new topics.