|
database
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
SQL Server database programmingmicrosoft.public.sqlserver.programming
WHERE Clause CASE
Scott -
19 Aug 2006 11:34 PM - 2 messages
The below WHERE clause in CODE 1 works fine, but gives me a null error if mill_id = 2. That's because the WHERE clause should look CODE 2 when mill_id = 2. Is there a way to use the CASE function in the WHERE clause to test the ...
delete query
tom taol -
19 Aug 2006 10:12 PM - 4 messages
table1 fld1 aa bb cc table2 fld1 aa cc after query execute result table1 table1 fld1 bb "delete from table1 a where a.fld1=table2.fld1" but not working *** Sent via Developersdex [link] *** ...
Side Clash in distributed transaction Statement
Bishoy George -
19 Aug 2006 8:27 PM - 3 messages
Hi, I have a distributed transaction statement that updates an SQL server instance on Windows Server 2003 from another SQL server instance on Windows XP SP2. Both servers a linked to each other. The DB is the same on server and client. ...
Could not find Type 'StoredProcedures' in assembly 'HelloWorld'
carl.jung -
19 Aug 2006 6:54 PM - 7 messages
Hi, I am trying to create a CLR stored Procedure as bellow: create procedure HelloWorldSP as external name Helloworld.StoredProcedures.HelloWorldStoredProcedure1 However I get the error: Could not find Type 'StoredProcedures' in assembly 'HelloWorld' My .NET code to create the managed code is: ...
Fill table with dates based on a source date columns
robc390 -
19 Aug 2006 6:14 PM - 3 messages
I am trying to build a lookup table of valid dates for given business periods of time. Given four peices of information: PERIOD, START_DT, MID_DT, END_DT I wish to have one row for each date between START_DT, and END_DT for ...
newbie: how to access variables across multiple queries
groups -
19 Aug 2006 4:37 PM - 4 messages
Hi All, I've inherited a bare-bones reporting environment that relies on manually executing dozens of select queries in Query Analyzer each month, then cutting and pasting results into Excel. Each month, the date ranges for each query have to be manually adjusted. ...
optmizing Cursors
hch -
19 Aug 2006 10:12 AM - 6 messages
Hi all I m working on a stored procedure with 5 nested cursors working on 5 temporary tables . I tried some technics to reduce the response time but i didnt succed I tested these methods : - Replacing cursor by a while loop ...
Assistance With Query
Albert Frausto -
18 Aug 2006 11:14 PM - 4 messages
Hello, I'm a bit rusty with my Transact-SQL and I've come across an issue with a Query. I have the following pair of tables: Scores Grants ...
Odd One
Chris -
18 Aug 2006 10:59 PM - 4 messages
sql2000 sp4 std ed I have a sp call that an asp webpage calls over oledb/ado - database trace running - duration for completed event takes 15+ seconds. Run exact same sp call in QA - less than 1 second response. When running in ...
Update a table using an aggregate(sum)
kw_uh97 -
18 Aug 2006 8:21 PM - 8 messages
Hello Everyone How can I update this table to show an aggregate(sum) on a column? CREATE TABLE [SUR2] ( [Domain] [nvarchar] (128) COLLATE Latin1_General_CI_AS NOT NULL, [WorkPack] [varchar] (50) COLLATE Latin1_General_CI_AS NULL , [InvoiceMonth] [datetime] NULL , ...
Upgraded to 2005, but its slow??
mavrick_101 -
18 Aug 2006 7:55 PM - 7 messages
Hi, For some reasons, our new SQL 2005 is running slower than our old MS Sql server. Is there a tool where I can analyze if there are some differences on indexes on different tables across the two SQL servers? ...
What's wrong with this query
Henry Jones -
18 Aug 2006 7:27 PM - 4 messages
use northwind select o.orderID, o.employeeID. o.customerID, o.orderdate from dbo.orders AS O join (select employeeID, max(orderid) as Maxoid from dbo.orders group by employeeID) as D ON o.orderid = d.maxoid; ------------------------------------------------- error generated: Msg 258, Level 15, State 1, Line 3 ...
Help with a calculation please
ITDUDE27 -
18 Aug 2006 6:59 PM - 6 messages
Hello, I have this stored procedure that is calcualting invoice payment. For some awkward reason it some of the record the right payment amount and for others it gives some rediculest number. Can anyone see what i'm doing wrong ? ...
UNION and GROUP By
Ric -
18 Aug 2006 6:50 PM - 4 messages
I want to write a UNION query and group by the entire result set: select submitdate, emplid, sum(submithours) from StandardTime union select submitdate, emplid,sum(submithours) from NonStandardTime group submitdate,emplid This does not work, I need a group by on each individual select statement. ...
Stored Procedure commit/rollback
Eric Stott -
18 Aug 2006 5:58 PM - 8 messages
When I run a stored proc in QA, it runs successfully, however when I run the code against BizTalk I get the following error: The adapter failed to transmit message going to send port "SQL://database/". It will be retransmitted after the retry interval specified for this Send ...
Joining Two Tables
c_shah -
18 Aug 2006 5:44 PM - 3 messages
Table1 Table1ID ControlID (int) 1 100 2 101 3 102 ...
Trying to restore a .bak in C#
Jayyde -
18 Aug 2006 5:00 PM - 6 messages
Can I run a SQL command like: RESTORE DATABASE NewDB FROM DISK = 'ApplicationStartupPath\SQLSE2005\DevDB.bak' WITH RECOVERY, MOVE 'DevDB_Data' TO 'C:\\Program Files\\Microsoft SQL Server\\MSSQL.1\\MSSQL\\Data\\NewEB_Data.mdf', MOVE 'DevDB_Log' TO 'C:\\Program Files\\Microsoft SQL ...
Using sp_dropserver
moondaddy -
18 Aug 2006 4:49 PM - 2 messages
For a week I have been trying to resolve an issue with VS2005 where it will not debug sql server 2k or 05. One of the many links I was given or found to resolve this is: [link] ...
How can I calculate a running YTD sum
Arthur Dent -
18 Aug 2006 4:05 PM - 7 messages
I could use some guidance here. I would like to know how I can calculate a running YTD sum value in the following scenario: -- START CREATE EXAMPLE CREATE TABLE dbo.tblTestData ( generic_id int NOT NULL IDENTITY (1, 1), ...
Lady Only
SEXBLOG -
18 Aug 2006 3:59 PM - 1 message
Lady only 24-Hrs +91 9810577227 OR email to i***@lenstar.org ...
Lady Only
SEXBLOG -
18 Aug 2006 3:59 PM - 1 message
Lady only 24-Hrs +91 9810577227 OR email to i***@lenstar.org ...
Determine Table Owner w/Catalog View
Dan -
18 Aug 2006 3:58 PM - 4 messages
I am using the sys.tables catalog view to get information about tables in my database. I would like to also determine the owner of the table. Is there a catalog view that contains this information? ...
nolock
Shahriar -
18 Aug 2006 3:09 PM - 2 messages
I am hoping that somebody could point me to a right direction for this question. In a heavily used website, we are getting occasional timeouts accessing tables. Could the casue be due to not having the "nolock" phrase in some of ...
Unable to drop index
StrykerSoccer -
18 Aug 2006 2:40 PM - 4 messages
I am trying to drop an index. The error I'm getting is: Cannot drop the index 'dbname.PK_sku_price', because it does not exist in the system catalog. Thanks...Nali ...
Alter Table ....Add Column
Bob -
18 Aug 2006 2:14 PM - 8 messages
Most everyone knows how to alter a table and add a column...or else we can look it up in BOL. But....how do I add a column WHEN I want the column to be the xth column in the table. ...
DateTime format
amjad -
18 Aug 2006 2:13 PM - 10 messages
is their any function in sql server to format date like ddmmyyyyhhmm i want to create a key from date but date is bydefault like 12/12/2004 12:30:30 but i want to convert it to like we do in vb ...
rastreadores GPS Ratreador gps localizadores bloqueadores 2677528
rastreador gps rastreadores gps de =?ISO-8859-1?Q?Ve=EDculos?= -
18 Aug 2006 1:58 PM - 1 message
CENTRAL ÚNICA DE VENDAS 10 Marcas de ratreadores, Compare e Compre. Rastreador de Veículo Rastreadores de Veículos Rastreador GPS ...
Design discreet transactions
Chris Strug -
18 Aug 2006 1:53 PM - 2 messages
Hi, I was wondering if anyone could provide a little guidance to the best approach to this: In my database I generally creat an insert/update procedure for every table (plus a few others). Say that I have an operation that requires an insert into table X, Y and Z - ...
Encrypt function in SQL2K
DBA72 -
18 Aug 2006 1:50 PM - 6 messages
Has anyone played around with this function? I have different results with it on different servers. Both servers are running SQL2KSP4 but the script below returns: 0x6100 and 0xB0ED on one server (this is what I would expect). But on the other server it returns 0x6100 and 0x6100 - so the encryption is not ...
sql2005 output deleted.* into ?
WebBuilder451 -
18 Aug 2006 1:46 PM - 4 messages
I'm attempting to use the new tsql capibilitied of 2005 and in the book sql 2005 for developers i saw how the output function seems to work and i have the following example that does not work. It gives me this message: Incorrect ...
Read
Weman -
18 Aug 2006 1:26 PM - 1 message
Lady only 24-Hrs +91 9810577227 Send email to i***@lenstar.org get access code. ...
Get unique poolID value for interlinked items
Veeraraje Urs -
18 Aug 2006 1:15 PM - 3 messages
Hi All I have a table with the data in the following format Col1 Col2 PoolID BOOK1 BOOK2 0 BOOK3 BOOK1 0 ...
User defined functions and booleans?
William Sullivan -
18 Aug 2006 1:10 PM - 12 messages
For some strange reason, I can't find any information on this... Can a UDF return a boolean? I know there isn't a boolean type, but there sorta is... The reason I ask is because it would make my UDFs more graceful, as in: ...
BCP .dbf file useing t-sql
jaylou -
18 Aug 2006 1:01 PM - 9 messages
I am trying o import a .DBF file into my SQL server 2000 database. I have attached the error, my command line code and my fmt file below. Should I be using tab delimited for a DBF? This is driving me crazy, I have ...
Openquery Maximum Length 128
Fuzzydave -
18 Aug 2006 12:41 PM - 4 messages
Hi, I am writing a query which moves information between SQL Server 2000 and Postgres 8.1.3. Before i modified the script it would very occassionally return the error that my openquery was "is too long. Maximum length is 128" but 99% of the time it would ...
Calling an Oracle Stored Procedure from a Sql Server 2000 Stored Procedure using a Linked Server
Richard Urrutia -
18 Aug 2006 12:25 PM - 3 messages
Hi, I'm trying to call an Oracle stored procedure from Sql server and I have this error message Could not execute procedure 'INTEGRE_INTERNET' on remote server 'ORA_DEV1'. [OLE/DB provider returned message: One or more errors occurred during ...
Read
Weman -
18 Aug 2006 12:19 PM - 1 message
Lady only 24-Hrs +91 9810577227 Send email to i***@lenstar.org get access code. ...
Paging by char parameter
Arjen -
18 Aug 2006 11:24 AM - 4 messages
Hi, I have a select statement (stored procedure) that selects on the first char. The first char is an input parameter. I.e. on my webpage I show the alphabet a ... z when a webuser select a char the selection will be based on this first char. ...
Probably very trivial SQL Query question....
Balt -
18 Aug 2006 11:13 AM - 8 messages
Hi all, I'm a bit of an SQL newbie and have the following problem: I have two tables, one contains waypoints in latitude and longitude from a trip. The other contains trips. so: tabTrip: TripID, TripName tabWaypoints: fk_TripID, Lat, Lon, tstamp ...
Applying hierachy custom security with TSQL.
Vilma -
18 Aug 2006 10:42 AM - 1 message
Hi. I am developing an application based on SQL. I want a folder structure and security based on these folders. That is easy, but I find that I am replicating the security info in subfolders, subsubfolders etc. So the choice is to use inherited security and here I need some help. ...
Case don't run in a query
Luigi -
18 Aug 2006 10:05 AM - 3 messages
Hi all, I have a query that insert in a table some values find in another table. The problem is that one field (marked on a code) is always null (is it impossible, for my data). This is the query. ...
SQL 2005, web services, error: Object reference not set to an inst
Chris -
18 Aug 2006 9:56 AM - 1 message
hi, I am using sql server 2005 and web services of project server 2007. my job is to write a simple stored procedure that calls project's web services - to log on to the server, create a project and log out. I can log on.out - these ...
ORDER BY VIRTUAL TABLE CASE END bug?
kurt sune -
18 Aug 2006 9:15 AM - 4 messages
Hi, is this a bug in SQL server 2000? Create a table: create table dbo.Numbers ( Number1 integer not null, ...
tough request
samuelberthelot -
18 Aug 2006 9:10 AM - 9 messages
Hello, My Table: [FlagData] { FlagDataID, FlagID, DataDesc, DataValue} An example: FlagDataID = 1 FlagID = 5 DataDesc = 'FirstName' DataValue = 'Brian' FlagDataID = 2 FlagID = 5 DataDesc = 'LastName' DataValue = 'Smyth' How can I check if there are records with same FlagID and with ...
SQL Insert Statement
John -
18 Aug 2006 8:58 AM - 3 messages
Can i do this : INSERT INTO tblquotation_order (Order_Number, LisaNo, Organisation_Name,Order_Date, Order_Value, Createdby) VALUES (SELECT OrderNumber AS Order_Number, 'LIZ' + RIGHT(ProjectNumber, LEN(ProjectNumber) - 3) AS LisaNo, NameOfSoldToParty AS organisation_Name, PODate AS order_date, NetValue AS order_value, 'System' AS CreatedBy FROM tblSAPOrders ...
Tracking data changes
Martin H. -
18 Aug 2006 8:24 AM - 2 messages
Hello, I'm trying to understand what is the best way to track data changes in tables (SQL Server 2005). Meaning i need to store data about who and when inserted a row, modified a row (including what columns and corresponding ...
How to stop sqlservr.exe........
Bpk. Adi Wira Kusuma -
18 Aug 2006 7:57 AM - 3 messages
When I connect Internet, I watch on Taskmanager that sqlservr.exe seldom over work and Cannot be stoped. Now, I ask to u, Why does sqlservr.exe seldom over work? Or What is its causing? And How to stop it? Because it can make my connection internet be ...
issue with sp_OACreate
Bindu Pushparaj -
18 Aug 2006 6:34 AM - 2 messages
Hi All, When we run the sp_OACreate sp, we are receiving the following error: OLE Automation Error Information Source: ODSOLE Extended Procedure Description: Class not registered This happens only, when we try to run the sp_OACreate sp in a separate ...
Re: Copy SQL ResultSet to Variable or Table This!
Steve Dassin -
18 Aug 2006 5:16 AM - 3 messages
Hello Tom, [link] I think your too bright not to see thru what sql is selling:) After you work with a 'relational' db you'll see that 'this' ...
Function for finding the median in T-SQL?
JP -
18 Aug 2006 4:40 AM - 3 messages
I have a sql statement that returns the last four quarters of sales numbers for a given salesperson. What I would like to do is exclude the highest figure and the lowest figure then sum the two middle figures and ...
Same query ,different results ,why!
Joseph Anderson -
18 Aug 2006 3:22 AM - 6 messages
Dear all, I have sql scrips like the following lines details --starts here DECLARE @my_cursor CURSOR DECLARE @sqlstr VARCHAR(50) DECLARE @strTable VARCHAR(1000) SET @my_cursor = CURSOR FORWARD_ONLY STATIC FOR SELECT DISTINCT name FROM ...
How to combine several long strings and then insert them to a text field
Joseph Anderson -
18 Aug 2006 2:33 AM - 10 messages
Dear all, I have a question here, could anyone give me a help! I have 4 long varchar strings ,and I want to combile these for ...
SQL Server - Function Table Call
Amb -
18 Aug 2006 1:55 AM - 3 messages
I have a request from a friend that I personally don't think is possible without a cursor loop: Lets say I have a function that returns a table: Similar to below - and it will only ever, no matter what, return one row. ...
Select against calendar table
Terri -
17 Aug 2006 11:47 PM - 3 messages
I'm looking to set the variable @BusinessDayFactor based on a select against a calendar table. The select will have one parameter @ReportDate. The logic is as follows: Given @ReportDate count the subsequent, contiguous days which are not business days if those non-business days are in the same month and year as ...
Run a .vbs job
Scott -
17 Aug 2006 10:26 PM - 4 messages
Is it possible to create a job that fires a .vbs script file? ...
how to better manage jobs created by reporting services?
=== Steve L === -
17 Aug 2006 10:23 PM - 4 messages
the job names and step names are so encripted, they often look like 4DC18F43-DF2F-4F12-BAFB-58DD054EF0BA or exec ReportServer.dbo.AddEvent @EventType='TimedSubscription', @EventData='4ade808a-0199-4 is there an easy way to find out a report name the job is referring ...
insert into table
Zeng -
17 Aug 2006 10:13 PM - 3 messages
Hi, I thought we can just do this insert...into statement to copy data from one table in another db but it gives me errors below. Both product tables have the same schema. insert into db1.dbo.product ( select * from db2.dbo.product ) ...
Scramble Integer column?
nkw -
17 Aug 2006 9:29 PM - 7 messages
I have an int column for client ID (with unique contraint). Is there a good way to scramble the column? bitwise exclusive OR will keep the "neighbor" IDs still stay together. ...
Parse Text Problem
kaplan.jason -
17 Aug 2006 9:05 PM - 6 messages
Hi, I'm at a standstill on this and hoping that someone can assist. I've looked at substring, trim, right, and left to no avail. I have a field called Jobname this field can contain different lengths of text. Here are some examples ...
Run a query against multiple databases
Skeptical -
17 Aug 2006 9:03 PM - 4 messages
Hello, I had asked this question before but I guess my description was not very clear. I am able to select all databases from master..sysdatabases, but I am not sure how to run queries against each so I have something like: ...
Procedure expects parameter which was not supplied
ST -
17 Aug 2006 8:58 PM - 7 messages
Hi, I'm getting the error: "Procedure 'PAFF_Activity_Calcs' expects parameter '@SubjectID', which was not supplied." In my stored procedure. I'm new to SQL and SQL syntax, so I was hoping someone could look at my procedure and walk me thru why it's wrong? This is it below: ...
Help with reconciling data in two tables
Timothy.Rybak -
17 Aug 2006 7:45 PM - 3 messages
I have two tables - PartsShipped and PartsConsumed. Each table has three columns - Processdate (a date/time stamp), PartNumber, and SerialNumber. I need a simple query that will show me the 3 bits of info for all serial numbers that exist in the PartsShipped table, but not in the ...
PLEASE HELP with Query
Michael Kintner -
17 Aug 2006 7:43 PM - 6 messages
I am trying to use a IN statement Select * From ShowMenusFirst WHERE (Security In ((select Security from Users Where (Username='mkintner')))) ORDER BY Menus.Level; The results from the query select Security from Users Where (Username='mkintner') is 'Low','Med' ...
Controlling test input
Jim Abel -
17 Aug 2006 7:36 PM - 2 messages
I am trying to control the format of the text values into a 2000 sql server single column of a table. The coloumn is a varcchar(50) and the incoming values typically are as follows, “New Server†...
how to use multiple criteria based on other criteria in Where clau
Rich -
17 Aug 2006 7:36 PM - 4 messages
Hello, I need to retrieve all rows from the following dataset where code1 contains only('aa' , 'bb) and code2 contains only ('c1', 'c2', 'c3') when code1 is bb. So I want to pick up all the rows for code1 = 'aa', and only the rows ...
Tracking Databases On a Server/Instance
JasonDWilson -
17 Aug 2006 7:36 PM - 4 messages
I am a DBA and have a development DB server (SQL Server 2005) where developers can send me a request, and I create them a blank database and administer it, perform backups etc. The users can add tables, views, data, ...
Trigger and instr
Vanessa -
17 Aug 2006 7:35 PM - 3 messages
everyone, Is there is a INSTR built-in function at triggers? I tried to compare if a variable contains "FED". I tried If INSTR (@myvar, 'FED') > 0 but it said 'instr' is not a recognize functions. Please help! ...
Problems using LinRegR2
Ash -
17 Aug 2006 7:20 PM - 6 messages
Hi All, I'm currently trying to use LinRegSlope as follows: LinRegR2(lastperiods(60), [Measures].[Growth_Avg], ?????) I would like to regress the growth_avg measure against the following series (1,2,3,...,60). So, essentially I'm regressing against a time ...
Orphaned Trigger...
dave.seng -
17 Aug 2006 6:57 PM - 6 messages
I have a trigger that was copied over from sql2000 to a sql2005 box that was on the sysusers table. There were apparently 'problems' with the trigger, and not sure if it's even possible to actually create a trigger on the sysusers table anymore. Anyway, I can query the ...
User-defined Select list
lord.zoltar -
17 Aug 2006 6:36 PM - 8 messages
I have a stored procedure that selects from a table, the details of the query or table aren't that important (it's quite simple). Right now, the columns it selects are specified explicitly. I'd like for the user ...
Record count after Insert
gv -
17 Aug 2006 6:02 PM - 6 messages
Hi all, I have added 70 records from another table into a table. When Selecting the count from Query Analyzer I get the correct new count. When right clicking on properties of the table I get the old count. Can someone explain this why? ...
Dynamic "ORDER BY" based on data in database
William Sullivan -
17 Aug 2006 5:43 PM - 3 messages
I'm dealing with a legacy system (yecch) that I'm trying to search. The data I'm searching is a flattened representation of a tree. My problem is that my search results aren't being displayed in the correct order. ...
How can I pivot data on a range of integers? - Brain buster here!
McDale -
17 Aug 2006 5:39 PM - 4 messages
Hey everyone, I have a situation where I need to take one record and split it up over a range of integers that could be different for each record. The result would be one record for each integer in that range. Here is an example: ...
SQL query to find repeat entries
Greg Smith -
17 Aug 2006 5:34 PM - 4 messages
Can you run a query that will return only results that have the data in a target column duplicated in another row? i.e. Duplicate address data Original table tblPeople: RecordID Last_name First_name Address ...
Error when executing a distributed query on a linked server
SammyBar -
17 Aug 2006 4:57 PM - 2 messages
Hi, It's a repost of an old thread with more information included I'm testing a Sql Server 2005 Enterprise Evaluation Edition 64 bits. I've been trying to link a sql server 2000 SP4 to this but I'm having some ...
Can I use .NDF file recover my data?
Mike Torry -
17 Aug 2006 4:11 PM - 2 messages
I want to recover data in a table on SQL 2000 server. This database has 10 files (.MDF, NDF, and LDF). I know which .NDF file contains the data of the table. I made detach the database. Can I use one old backed up .NDF file replace the current .NDF file, and ...
SUB QUERY SELECT
robken -
17 Aug 2006 4:08 PM - 2 messages
Hi all, Just a quick question...can anyone tell me if SQL allows you SELECT...FROM (sub query) WHERE...etc? i.e is this query possible without first inserting the sub query data into a temp table? SELECT place1, SUM([value]) FROM ( ...
Backup Job Fails
Scott -
17 Aug 2006 3:55 PM - 4 messages
When I create a backup job and schedule it, I get the below error. I can create the job and run it immediately fine. But if I try to schedule it, I get this error. This is Win 2003 Standard SP1 and SQL 2000 SP4. I also use ...
Copy SQL ResultSet to Variable
StephenMcC -
17 Aug 2006 3:54 PM - 8 messages
Do we know, is it possible to copy the results passed from a select into a variable (I think similar in the way one can pass a resultset back from a UFN), so one doesn't have to keep on querying the table to get the results ...
Group By Month
murzik -
17 Aug 2006 3:47 PM - 5 messages
Hello, I am looking to group my query by month and having some problems. My Query: SELECT CONVERT(varchar, DateStamp, 110) AS DateAdded, COUNT(CONVERT(varchar, DateStamp, 110)) AS [#_of_Articles] FROM InstantKB_Articles ...
trigger problem
Jesse Aufiero -
17 Aug 2006 3:34 PM - 5 messages
Hello, I'm trying to create a trigger that involves an ntext column and i'm running into problems. Upon modification to a row in table A, a trigger should determine if column A, which is an ntext column, was modified. If so, the ...
Urgent: Help on query
Roshan Jayalath -
17 Aug 2006 2:46 PM - 12 messages
Hi all, I have a large table from which I need to fetch data according to a given filter conditions. But I will only need to fetch a set of records (Eg : To display the first 200 records in the table.). Still I would need the total ...
Sub-Query Error
Kevin -
17 Aug 2006 2:32 PM - 3 messages
I am getting the following sub-query error msg, Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression. I understand why I am getting the msg, just not how to resolve the issue. ...
Daylight Time
The One -
17 Aug 2006 2:26 PM - 4 messages
Hi, can anyone tell me how I can tell if a machine has applied Daylight Time or not? I need to find this out in a stored proc in both SQLServer2000 and 2005 using T-SQL. TIA John ...
Loop through MS SQL data with VBScript
Alex -
17 Aug 2006 2:13 PM - 2 messages
Hello, I need to write a script that will loop through data within a MS SQL database and print to a specific printer. I'm totally green when it comes to VBScript, so I'm not sure if this is possible and if so, what ...
Monday from week and year
Luigi -
17 Aug 2006 2:01 PM - 8 messages
Hi all, when I have the script: declare @week int declare @year int set @week = 35 set @year = 2006 how can I obtain the monday of that week? result: 14/08/2006? Thanks a lot. ...
Bin Location SQL Server 2005
dkisting -
17 Aug 2006 2:00 PM - 3 messages
Hello, I have a script which copies the xp_smtp dll to the bin folder of sql. In SQL 2000, I use the procedure or statement EXECUTE sp_MSget_setup_paths @SQLPath OUT to get the location (c:\program files...) to the bin folder. ...
Insert String into text file using bcp
ntuyen01 -
17 Aug 2006 1:53 PM - 4 messages
Hi All, I have a string 'ABC 12345 678910 XXXX '. I want to insert it into the test.txt file using bcp command. How do I do that. Thanks for your help. ...
how to find object modified date
FARRUKH -
17 Aug 2006 1:43 PM - 1 message
today when I come to work, I noticed someone had modified and deleted few columns n a table. Is there any way I can find out when and who modified and deleted columns? is there any scripts i can run ...
how to find object modified date
FARRUKH -
17 Aug 2006 1:43 PM - 4 messages
today when I come to work, I noticed someone had modified and deleted few columns n a table. Is there any way I can find out when and who modified and deleted columns? is there any scripts i can run? ...
How to integrate reporting services into a java application?
Aruna Muthyala -
17 Aug 2006 1:21 PM - 1 message
Hi, I have created some reports using SQL Server Business Intelligence Studio 2005. How can I call these reports in my java application. Any sample example will be of great help. Thanx, Aruna ...
Append to end of text data type field in sql 2000
TCH -
17 Aug 2006 1:17 PM - 4 messages
The notes field is type text in sql 2000. I need to append a line of text to it. This truncates at 8000: update tbl_main set notes = cast(notes as varchar) + ' This line is appended to the text field.' WHERE rcd_id = '01047' ...
Complex SQL Query
ad -
17 Aug 2006 1:01 PM - 2 messages
Hi, I have the following data from Excel spreadsheet. LST125A LST075A LST040A PBL125A LST125A 60 240 240 360 ...
Using Control-M to start MS SQL Jobs and Maintainance jobs
Naana via SQLMonster.com -
17 Aug 2006 12:54 PM - 1 message
Anyone have a simple script that might be used by an external scheduler such as Control-M to kick off .sql jobs or Maintenance Plans ( Backups, integrity, and Optimization). We are trying to use Control-M to monitor sql jobs, but ...
How to retrieve database user
Mike -
17 Aug 2006 12:54 PM - 2 messages
Hi guys, I'm new to SQL programming and I want to know if there's a way to retrieve user in a database that as space in is name. I'm able to retrieve user with sp_helpuser but if there's a space in ...
bulk insert from remote machine fails
Zekske -
17 Aug 2006 12:26 PM - 7 messages
When I start a bulk insert from a network share locally on the server I have no problem. When I start the bulk insert (is inside a stored proc) from a remote computer I get the following error message: Msg 4861, Level 16, State 1, Line 1 ...
parse
Roger -
17 Aug 2006 12:18 PM - 2 messages
Platform: Windows 2003 R2 64 bit 32 GB RAM Sql Server 2005 Enterprise 64 bit with SP1 and all fixes applied Executing Parse in Sql Server 2005 Management Studio I get the following ...
|
|||||||||||||||||||||||