Topics
Started by
Posts
Last post
I have a parent table ProductType and child tablE Product. ProductType has one to many relationship…
17 replies
Is there a way I can reduce the duplication in this stored procedure? In each if statement, I have…
6 replies
Hi all, When i try 'include the actual execution plan' in the query analyser, I get this error, ple…
2 replies
The company has our dept to try to come up w/ a solution for our current invoice/statement process …
3 replies
I have created two tables and entered the data as shown below. Create table tablea(col1 varchar(10)…
4 replies
How do I truncate a Dimension table with foreign keys to the Fact table?
1 replies
Hi all. I'm working in SQL Server 2005 and ASP.NET 2.0. I have six tables, each of which referenc…
5 replies
Hi all I have this script that calculates the best product combinations based on their sale price. …
14 replies
Hi I have a problem when importing a .xls containing date fields into a table using SSIS through de…
3 replies
I have written Stored Procedure TourCount which take tourID as input. I have written the following…
1 replies
In the below test procedure, I have defined CustomerID as VARCHAR(10). If the XML passed to the pro…
4 replies
I am getting an error when I convert varchar to bigint. Is there a better way to do this? INSERT IN…
2 replies
I am developing a system using the MS Access 2003 tool. The backend is SQL Server MSDE2000. I want:…
2 replies
Hi, I am trying to retreive data from a temporary table which I have inserted into in the same sp. …
2 replies
Hi, I had received some data files for a new project with 1 million rows and 75 columns. Do we ha…
1 replies
Viewing 15 topics - 2,986 through 3,000 (of 4,155 total)
You must be logged in to create new topics.