Topics
Started by
Posts
Last post
All, I have done lot of fine tuning work in sql2005. I just consolidated it in a spreadsheet and se…
9 replies
I have a table with a primary key. I need to create a query with a command alter table to add a col…
1 replies
All, I have seen lot of tables with IDENTITY column created with PRIMARY KEY. I am sure we shouldn'…
24 replies
Let's say you have an order table defined as: CREATE TABLE order ( order_number INT NOT NULLl, …
10 replies
I have written a stored procedure that updates data, it runs ok until it reaches the name Milly's. …
3 replies
I have this Stored Procedure which works well. This with other lines allow me to call the Stored P…
5 replies
Hi All, I'm joining two tables to get the id name from another table the structure is CREATE TABLE …
5 replies
I'm trying to concatenate month and year columns and check the resulting date value to be greater t…
5 replies
Hi. What is the most efficient way of sending/passing parameters to a stored procedure from ADO.NET…
6 replies
Hi, I have an SQL question that I need an answer to. Assume 2 tables: Table 1 : "CDs" that holds '…
1 replies
Here's the example that I'm working with: CREATE TABLE #TestTable ( ID INT, Field1 VARCHAR(MAX),…
12 replies
/* Need assistance in creating a T-SQL query to exclude certain rows: The idea is to calculate each…
5 replies
All, This is driving me crazy. It should be easy but is giving me multiple records per day. Pleas…
19 replies
Hi, I need to calculate a rank column. Just assume following result and my desire rank column. Plea…
3 replies
Hi Friends, I have one result set which is as below. --------------------Run below script in your q…
7 replies
Viewing 15 topics - 3,631 through 3,645 (of 12,230 total)
You must be logged in to create new topics.