Topics
Started by
Posts
Last post
I have a table with the following tructure CREATE TABLE [dbo].[Transactions]( [AccountNbr][var…
4 replies
Hi In sql2005 or Sql2008, is there any possibility to find since last month, what r the maniputio…
18 replies
I am trying to create a stored procedure that takes a database name as variable. I am trying to use…
6 replies
I'm trying to make sure that no one steps on the other's job number. This is my code: S…
10 replies
Hi, I am trying to normalise some data and am unsure how best to deal with Location data. There are…
5 replies
Here is some sample data to work with: --===== If #MyTable already exists, drop it IF OBJECT_…
3 replies
I need to update the File1 Value field but I not sure how to do the syntax. DECLARE @XmlData xml S…
2 replies
Hi Recently i pulled some data out of a sql table into excel. The table has a column that is a varc…
3 replies
Hi I am trying to merge same table recursively to get some formatted output, For instance, I have t…
1 replies
What's wrong with my thinking below? If @ID is provided, I want the WHERE clause to only reflect ID…
7 replies
Hi Everyone, I wanted to replace cursor with some select statement for multiple columns and multipl…
9 replies
I have this extended SP "sp_XML_preparedocument" missing on both the SQL 2005 sp4 and SQL 2008 R2. …
6 replies
I have a table that show the working log for a particular users. We can see the Date, Time, CardNum…
7 replies
I posted a previous query where I was looking just for a state, now I want to use a case in the whe…
2 replies
To export the entire data base into an XML file , and updating that xml file dynamically. Means we …
5 replies
Viewing 15 topics - 2,446 through 2,460 (of 12,234 total)
You must be logged in to create new topics.