Topics
Started by
Posts
Last post
set nocount on print 'Show Size, Space Used, Unused Space, Type, and Name of all database files' se…
3 replies
Hi guys. Using SQL2000....... I have a UDF that takes a single parameter (integer) returns a scalar…
4 replies
My problem is as follows. I have this query that works fine as two seperate subquery fields. --V…
6 replies
I have the following example query: DECLARE @foo TABLE(value INT); DECLARE @bar TABLE(foo INT, val…
1 replies
I am sad to say I haven't been able to figure this out. I have a table with a Start Time and an End…
6 replies
HI , I want store some script files in my table . Which data type i have to use to store script f…
3 replies
Create Table #Table (id int,Empname varchar(10),Job varchar(10)) Insert into #Table values (1,'shar…
8 replies
I'm doing something similar to the below example: DECLARE @RowStart INT DECLARE @RowEnd INT SET @R…
16 replies
Hi can someone tell me this doesn;t work?? It just returns a blank every time. The same happens whe…
16 replies
Hello All! My stored procedure works to calculate total number of days of Holidays taken eliminati…
5 replies
hi i'm querying against a linked db (unix) and am trying to create a between predicate for current…
5 replies
I'm trying to create a xml tree by writing a sql query. Here is what I have: DECLARE @CountOfPort…
20 replies
I can't understand this. I have a query and if I hard code a number for a EntityType in the query,…
4 replies
hi i have three rows in a table for each product. each line represent a different unit of measure v…
6 replies
I hate asking questions when I know there are 42,000 answers out there already, but I can't seem to…
4 replies
Viewing 15 topics - 1,786 through 1,800 (of 12,234 total)
You must be logged in to create new topics.