Topics
Started by
Posts
Last post
Hi - I have a table. This table (table1) as 3 columns (name,address and number). The fields 1 and…
4 replies
Hi All, I want to find the missing date from a series of date. create table t_date ( dt datetime ) …
9 replies
Here is the table definition... CREATE TABLE [dbo].[tblObject]( [ObjectID] [int] IDENTITY(1,1) NOT…
5 replies
My following query yields 0 records but I expect 3 records as 'catalogItems' table has 3 records fo…
5 replies
I am looking for a solution to a problem. I can't quite find the command I am looking for. I want…
2 replies
Hi I am passing a table name as a parameter in stored procedure ?? when I did that, it is not dis…
18 replies
given the table: is there a way to create 20 new records using @@rowcount? why wouldn't this work? …
1 replies
All, I have executed the below queries today. select convert(decimal(16,2), 12344.83937898) select …
4 replies
I have a View that needs to be a good deal faster than it is, but I'm getting nowhere beyond shavin…
8 replies
I'm querying the number of weekdays between two dates unless the leavedate is null in which case I …
7 replies
given the table, I have a set of productcontrolID's that have many applicationID records. Given the…
21 replies
Hi- I have a procedure. This procedure have two instructions. Each instruction should only be execu…
2 replies
that how the data is SKU PO# QTY Date 1 '640050193' 'X1234' 122 '03/13/2009' 2 '640050193' 'V3344' …
13 replies
I have a need to return the elapsed time in a specific format. Namely hh:mm:ss.sss without supressi…
4 replies
Hi, We have this location table - locationid, location, parentid. It is a tree like structure, that…
1 replies
Viewing 15 topics - 1,831 through 1,845 (of 17,082 total)
You must be logged in to create new topics.