Topics
Started by
Posts
Last post
Why if I run the 1st of the following 2 statements do I get and error, when both are valid dates? S…
1 replies
on sql2005, i run an update using a linked server. how come this works: update linked_server.lcp.d…
3 replies
I have 3 fields (with sample data) RegimenID, DrugID, Country ======================= 1, 22, US 1, …
1 replies
Hi, When you issue a statement such as: DELETE TableA FROM TableA INNER JOIN TableB ON TableA.a = T…
8 replies
I need a query to select the Badge, record number of the person's last log entry, grouped by badge …
8 replies
Hi, I am trying to use the code below to delete log files that have been created by some of my jobs…
1 replies
Say you have a table with time oriented data (columns would be time period, and value), and you wan…
7 replies
Still on my quest to remove all the cursors from my database... or at least be capable of removing …
21 replies
Hi all, I am facing a problem at work atm, where I have a requirement to produce a report for the c…
3 replies
I looked around here a bit to see if anyone had posted anything about what is better: SET or SELECT…
82 replies
Given the following table structure and data sample, I need to find the number of days consumers we…
14 replies
How could I instruct a sp to coninue execution even if it faces an error.. I am looking for the sam…
2 replies
I am working with SQL Server 2008 Express and I am having issues with loading an XML schema in and …
2 replies
I have a client whos database table uses a multicolumn PK. Unfortunately, the columns used for the…
1 replies
I am trying to perform an update in an access 2007 database but I get an error stating missing oper…
1 replies
Viewing 15 topics - 6,601 through 6,615 (of 12,234 total)
You must be logged in to create new topics.