Topics
Started by
Posts
Last post
I have 2 tables with customer id in one coulmn and orderid in another table. I need to find out the…
1 replies
Hi there - Please find attached part of my SELECT statement - Select '1' AS Trigger_Status, …
9 replies
Can someone help me update this text field? I need to update the Serial and MX records in this zone…
8 replies
I need to modify the unique index already created on a table to include another column. How can i d…
2 replies
Hi All, I have to two DDL statements followed by a SELECT stmt which is ofcourse is not working 🙂 …
3 replies
[font="Courier New"]I have a table of purchases with 50 million records. Each purchase has an ID I…
14 replies
Thanks to the help of the nice people here I use: CASE When Max(vtbl_Job_Descript_Master.START…
3 replies
Type table has three columns machine, material , store select machine, material , count(*) as Count…
1 replies
Hi guys, Is there a whay to create a trigger on all the tables to monitor data being deleted.I hav…
14 replies
How do I convert binary data which is in MCS (Multinational Character Set) format? consider the bin…
3 replies
I have a CSV file that I need to import into a table. The records looks like the following: 110,"L…
2 replies
With a long uptime, I checked the index use and would like to drop the indexes which have zero user…
2 replies
So I have two tables that have two fields that are the same. How do I find pairs in one table that…
2 replies
Hi, I would like to use a stored procedure that calls other stored procedures and use a temporary t…
17 replies
For the life of me I can't figure out why I have this error. here is my Stored Procedure. USE [Kraf…
6 replies
Viewing 15 topics - 6,346 through 6,360 (of 12,234 total)
You must be logged in to create new topics.