dbTalk Databases Forums  

Sponsored Links


microsoft.public.sqlserver.mseq microsoft.public.sqlserver.mseq


Discuss in the microsoft.public.sqlserver.mseq forum.



Post New Thread
Threads in Forum : microsoft.public.sqlserver.mseq Forum Tools
  Rating Thread / Thread Starter Last Post Reverse Sort Order    Replies         Views     
I have a table with a varchar field that for the most part contains valid dates ie (mm/dd/yyyy). There are some items that are not dates. I...
Dan
02-01-2005 11:39 AM
Steve Kass Go to last post
1 174
Hi All Another quick question, is it possible to put a index on a temp table and if so what is the syntax. Thanks Phil
Phil
01-31-2005 03:30 PM
Hugo Kornelis Go to last post
1 167
Hi All, Just a quick question for anyone, I have a stored procedure that uses a lot of variables in a where statement, the only problem with this is...
Phil
01-31-2005 04:45 AM
Hugo Kornelis Go to last post
1 160
Real new person question here but during my query practise I created some parameter queries in the enterprise manager however theses will not work...
Sam
01-19-2005 09:03 PM
Nigel Rivett Go to last post
1 176
Help me with the following query. I have employee table as follows EmpID (Number) FullName (Text) ReportTo(Number) ReportTo field contain number...
Harry J Nathan
01-19-2005 09:01 PM
Nigel Rivett Go to last post
1 195
Hello, I am new to sql (very new). I have two database, let's call it database1 and database2. Both database contains last name, first name and...
Steve
01-19-2005 09:01 PM
Nigel Rivett Go to last post
1 155
how can I keep track of who is making modifications to a existing stored procedure. thanks samy
samy
01-19-2005 08:57 PM
Nigel Rivett Go to last post
1 185
Hi. Is it possible to fire a trigger on a specific time i.e. when the system time is 1200 hrs(for eg) , trigger fires automatically and run a...
Muhammad Bilal
01-19-2005 08:55 PM
Nigel Rivett Go to last post
1 217
Hi I am trying to write an update query that update the BG1 field in the Customer table with the BG value in the Agreements Table from a...
Newbie
01-13-2005 04:12 AM
Newbie Go to last post
1 228
I'm using sql 2000 and Access 2002. I need to create a parameter query that would ask the following statement: "Enter the work order number". How...
pjscott
01-04-2005 03:50 PM
Hugo Kornelis Go to last post
1 287
I'm not sure if I understood this correctly. If I create a temporary table with the name #SomeTempTab, can anybody else see this table while I'm...
MichaelK
01-02-2005 01:40 AM
MichaelK Go to last post
2 195
Is it possible to make a query to have a counter which would have a sequential number of each record in the query starting with 1? Thanks, Michael
MichaelK
12-28-2004 04:05 AM
Hugo Kornelis Go to last post
4 166
We're trying to dump our remaining v7 SQL server and update to 2000. We're having trouble with a trigger updating some tables. At the beginning, it...
Bill Polewchak
12-24-2004 04:15 AM
Hugo Kornelis Go to last post
1 311
Hi, I'd like to create a SP like this: SP_Table1_LOAD Update Table1 set... (alter existing rows) Insert Into Table1... (insert new rows) This table...
Miguel Salles
12-20-2004 04:27 PM
Hugo Kornelis Go to last post
3 312
I can't figure out why i have a bookmark lookup cost on ValidVendorPackages on the below proc: Select PriceViewHotelPrice.price as Totalprice,...
we7313
12-15-2004 03:49 PM
Hugo Kornelis Go to last post
1 202
I have a table as follows: Code Quantity Status ACC1 50 Dispatched ACC2 31 Dispatched ACC3 62 ...
Wes
12-10-2004 02:48 PM
Hugo Kornelis Go to last post
1 263
I have a proc that can specify a price range if its passed in. my and where clause looks like this: where ((PriceViewHotelPrice.price +...
we7313
12-06-2004 03:24 AM
Hugo Kornelis Go to last post
3 182
Hi I am having a table , acct dramt cr_amt 101 5 103 5 101 10 how can i make a select stmt which gives the...
shif
12-01-2004 02:56 PM
Vishal Parkar Go to last post
1 191
I have this query in SQL 2000, I get wrong answer SELECT B.ID, ISNULL(B.ID,'Is Null') FROM secuenciales A LEFT JOIN ( select b.id from (select 'Isnt...
Yaocuauhtzin
11-30-2004 12:05 AM
Steve Kass Go to last post
6 222
Hi, Is there a way in T-SQL to update several fields of a table with fields from another table using a select statement based on a key? I remember...
Chip
11-29-2004 04:59 PM
Hugo Kornelis Go to last post
2 272
Hi, I am using Windows 2003 Server. The VPN works fine, but I want to FTP through the VPN so the connection is encrypted. The problem is each of...
Jason Robertson
11-29-2004 04:50 PM
Anith Sen Go to last post
1 172
I have a select proc that will take a bunch or criteria parameters. Based on how many are not null I would like to decide how many inner joins to...
we7313
11-29-2004 04:49 PM
Anith Sen Go to last post
1 210
Whats the maimum number of stored procedures you can have in one database? Would I notice any performance degredation if I had over 2,000? -- will
we7313
11-29-2004 02:43 AM
Hugo Kornelis Go to last post
1 178
I have a table with a date field. I need to convert the date so that it returns in a text format of DDMMYY - no separators. How do I do this?
Newbie
11-25-2004 04:04 AM
Newbie Go to last post
6 245
I haven't been able to find an answer to this simple question from any of the online documentation. In table design view, each one of my columns has...
cmaso
11-24-2004 02:43 AM
Vishal Parkar Go to last post
1 175
I've been unable to find a way to write the following query. Assuming this table: Year Quarter ---- ------- 1990 1 1990 ...
Shawn
11-24-2004 02:36 AM
Vishal Parkar Go to last post
3 187
Hi! I ran the upgrade pack for Microsoft last night and now my localhost on my laptop won't work. I use SQL to demonstrate a website on the laptop...
Cormac Mannion
11-23-2004 05:41 PM
aaron kempf Go to last post
2 197
hello, I've a problem with a trigger : this trigger update a file with an index field but it's return an error : UPDATE stop because the Set option...
philned
11-21-2004 07:35 PM
Nigel Rivett Go to last post
1 185
hi, I have requirement. I want to format a numeric value with commas. is there any function to use in transact-sql query to do this. for example if...
hari
11-10-2004 02:23 AM
pranab_das26 Go to last post
3 186
Hi, I have some SQL-statements that are very slow, and I'm wondering if I can do this in a more efficient way. The problem is that I need to list...
Ingar Eide
11-08-2004 08:45 AM
Hugo Kornelis Go to last post
1 148
Does anyone know a (relativly) easy way of keeping records in their created order? (or a specific order, and maintaining that order...
Gary K
11-08-2004 03:35 AM
Hugo Kornelis Go to last post
1 184
I have a db with a table that records details about order transactions. The main columns I am concerned about are the "Transacton_Type" column and...
Strugglin'
11-07-2004 11:29 AM
Steve Kass Go to last post
1 187
Hi, I need help in constructing a query against my Db I have. The DB I have has 122 Tables and 15 columns in each. I have information in a column...
Dave Lugo
11-04-2004 04:08 AM
Hugo Kornelis Go to last post
1 271
Hello, Can i install SQL server 2000 on XP Prof? is there any seperate version for XP Prof? Where can i get Free SQL Server 2000 book in PDF...
Rajani
10-31-2004 12:42 PM
Hari Prasad Go to last post
1 189
Hi all, we have a table with a column of type "datetime" We want to get the smallest timespan between two entries. Now we get this timespan with...
mike
10-29-2004 02:56 AM
Hugo Kornelis Go to last post
4 271
We have a tableA with a varchar field whose contents are hexadecimal. We want to insert these hexadecimal contents from a varchar field into...
Skip
10-28-2004 08:17 PM
Steve Kass Go to last post
9 238
Is there a way in SQL Server to run the simple query having something like IIF function in Access. Similar to this easy query. SELECT Mobile,iif(=1,...
MichaelK
10-27-2004 05:30 PM
Hugo Kornelis Go to last post
1 238
Hi, I am new to MS SQL server. I installed the sql server 2000 evaluation edition on my PC( Windows XP Pro,SP 1). I can work with enterprise manager...
Someswar Barkataki
10-27-2004 12:42 PM
rdbrock Go to last post
2 174
Hi I have data in 3 tables that I want to add together to get a total figure So far I have an sp that uses a union query that gives me 3 totals (1...
news.microsoft.com
10-25-2004 09:19 AM
news.microsoft.com Go to last post
4 240
Hello, SELECT discounts.*, discounttype AS Expr1 FROM discounts WHERE (discounttype = 'Initial & Customer') This query in pub...
JIM.H.
10-23-2004 12:36 AM
Steve Kass Go to last post
2 314
can you update date a column with an if then statement. This is a simple example and I want to do something more complex, but I can't figure out...
John
10-18-2004 05:56 PM
Anith Sen Go to last post
1 194
I've got one table that holds various information fields and a field for the city, and another table that holds city and state (and zip, etc). I...
chazz
10-18-2004 01:56 AM
Vishal Parkar Go to last post
1 156
I've got one table that holds various information fields and a field for the city, and another table that holds city and state (and zip, etc). I...
chazz
10-17-2004 09:54 AM
Vishal Parkar Go to last post
1 171
Can anyone advise me of how to make sure that a customer is inputting correct information into the database. I am building a website, where...
Stefnils
10-13-2004 04:51 PM
Anith Sen Go to last post
1 180
Hi, I have a expenses table, in this table I have the account, exp_date, exp_type and amount fields. I have three exp_type (real, budget and myu) I...
Miguel Salles
10-13-2004 04:45 PM
Anith Sen Go to last post
1 193
Hi, I've a problem to remove certain character from one column/field eg. 500000000000ABC. How to remove ABC ? Thanks in advance.
GW
10-12-2004 03:48 AM
Paul Nielsen Go to last post
2 181
I want to condense several rows of a table using a select statement, function, or stored procedure For Example mytable : 1 a 2 b 2 c 2 d 3 a
Dan
10-12-2004 03:44 AM
Paul Nielsen Go to last post
1 200
Hi Being very new to SQL so iam hoping that this will be easy. Using a dts package to transfer IIS logs into a SQL database i would now like to...
Simon Jelinek
10-08-2004 09:33 AM
nemb Go to last post
1 203
Is it possible to use variables in a view... Ex: Create view zz as Declare @user Set @user = 1 Select * from sometable where @user = 1 i think you...
??
10-05-2004 02:18 AM
Steve Kass Go to last post
2 198
Hi I am using mssql7 server.unfortunatily the space of the hard disk reached below 10mb and while saving data server has showned the disk full...
shif
10-02-2004 12:37 PM
Steve Kass Go to last post
1 219
Post New Thread

Display Options
Showing threads 401 to 450 of 961
Sorted By Sort Order
From The
Forum Tools Search this Forum
Search this Forum :

Advanced Search

New posts New posts More than 15 replies or 150 views Hot thread with new posts
No new posts No new posts More than 15 replies or 150 views Hot thread with no new posts
Closed Thread Thread is closed  
 
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off


Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.