Sponsored Links

microsoft.public.sqlserver.programming microsoft.public.sqlserver.programming

Page 66 of 1545

Threads in Forum : microsoft.public.sqlserver.programming

Forum Tools

Rating Thread / Thread Starter	Last Post	Replies	Views
Retrieving data for current date - Query Hello Folks, This should fairly be a simply but I am lost. I am trying to retrieve the for current day means today but this does not give me any... Viol-8-r	09-10-2009 01:55 PM Viol-8-r	4	25
Union EXCEPT / Join I have a type (lookup) table and then a customers table. There's also a join table between these two, some customers will only use a few of the... John	09-10-2009 01:26 PM --CELKO--	2	36
Re: Lahjatilanne MTV 3. 07.06.2008. "Norjassa tuulivoima myötätuulessa. Norjan energiatarpeista PUOLET voidaan kattaa tuulivoimalla, kun nykysuunnitelmat toteutetaan!... Kristian Kaiser	09-10-2009 12:15 PM Kristian Kaiser	0	31
Insert Group By Category With Zero Sum Value I have the following code that groups by status. I would like all status categories to be returned even if the field I am summing on (book... James	09-10-2009 11:45 AM James	2	35
Question on Cursor I had this stored procedure working before, but recently I am starting to get this error. "Conversion failed when converting the varchar value 'YES ... Justin D.	09-10-2009 11:27 AM Kalen Delaney	9	43
Query to Choose which Lines to Update? I'm having a bit of a hard time thinking of this and I have not been successful searching the web as I don't really know what I call what I am... Carnage	09-10-2009 11:23 AM Carnage	3	23
SQL Server 2005 Compatability Mode Does anyone know what this really means? If I switch it to to SQL Server 2000 compatability, is that at a specified Service Pack level? Like SQL... John Couch	09-10-2009 11:13 AM Hugo Kornelis	2	21
conevrting date to character data within stirng Hello, when running select statment select convert(varchar(20),GETDATE(),120) it gives 2009-09-09 while putting it in a string statment , it... khaled	09-10-2009 10:32 AM Hugo Kornelis	6	37
Extending UI of Management Studio Hello NG! Is there a documented way to extend the Property Dialogs of SQL Server Management Studio (2005, 2008)? Like adding new "Pages" to Database... Günter Prossliner	09-10-2009 09:55 AM Günter Prossliner	2	33
Where condition using subquery output Hi Experts, I'm trying to use the result (datetime) of a subquery in my where clause. When I do that performance is problematic. If I change the... Avi	09-10-2009 09:29 AM Avi	4	38
Keep Getting "Error 1314 from CreateProcessAsUser" When Callingxp_cmdshell We have a stored procedure that uses xp_cmdshell to call an external program. It works fine for many years in all three of our database servers. ... Jay Chan	09-10-2009 08:09 AM Dan Guzman	3	29
RE: Can't add rows in query since copying database from MSSQL2000 to 2 Hi Paul, There is no Access project 2007. It is only Access 2007 database application. Create a simple table with identity integer column in SQL... znaika	09-10-2009 06:20 AM znaika	0	28
need pivot assistance I am trying to apply the pivot command to the following table ("pivotme") in order to render it like the next table ("pivotmeObjective"), but I can't... Freedom Nut	09-09-2009 07:03 PM Freedom Nut	2	30
Compairing to see which items do not exist in db I have a list of inventory items eg. ( '88815910401EI ', '88815910401ES ', '88815910401FE ', '88815910401FI ', '88815910401FS ', '88815910401GE ') I... Sammy	09-09-2009 02:18 PM Sammy	2	23
Joining Tables on Timestamp Hi All, I've got two tables in a MSSQL database that I need to join on a time/date stamp (YYYY-MM-DD HH:MM:SS) however the two time stamps are of by... Kevin Lucas	09-09-2009 01:24 PM Kevin Lucas	7	31
SQL to Access hi, My Task: Export (INSERT & UPDATE) from SQL to Access 2003 database. I tested the concept within a VPC (32bit), all was fine. When i went to the... Ian Oldbury	09-09-2009 11:20 AM Sylvain Lafontaine	3	44
Updating a field/column Hi, I want to UPDATE a column in a table with this statement: UPDATE compTable SET LYRNO = (SELECT COUNT(DISTINCT cokey) FROM compTable WHERE... Marilyn	09-09-2009 11:08 AM Marilyn	3	37
Too many parameters in sp I am executing a stored procedure in VB that returns a new identity value. I am getting an error about too many parameters and am trying to figure... David C	09-09-2009 08:49 AM David C	5	25
E mail notification from SQL Server Hi, I have a database on SQL Server 2005. On one of my table, I have different payment schedule for each employee. I was just comeup with an idea if... SF	09-09-2009 06:40 AM Dan Guzman	4	38
Link hi, My Task: Export (INSERT & UPDATE) from SQL to Access 2003 database. I tested the concept within a VPC (32bit), all was fine. When i went to the... Ian Oldbury	09-09-2009 03:17 AM Ian Oldbury	0	58
The query execution taking too long Hello, My server machine details are (2 x 2.26 GHZ Quad Core Processor, 12 GB RAM, SQL Server 2005 Enterprise Edition, 500 GB SATA HDD) I am using... Ganesh Subbiah	09-08-2009 11:31 PM Ganesh Subbiah	5	30
CREATE TABLE permission denied in database 'tempdb'. I am getting "CREATE TABLE permission denied in database 'tempdb'. " error when trying to create a temp table (#table or ##table) how can i solve... Gayathri	09-08-2009 05:17 PM Erland Sommarskog	5	42
Re: Calculating an average via multiple tables On Sun, 06 Sep 2009 15:56:38 GMT, h202 wrote: Hi h202, I already had the feeling this was a homework assignment when reading the problem, and I'm... Hugo Kornelis	09-08-2009 03:23 PM Hugo Kornelis	2	41
each row has either start date or end date - need to match them hi, First, let me apologies for posting this if it has already been answered. i tried searching for a solution first but couldn't find one. here's... Shoval	09-08-2009 02:44 PM Shoval	5	43
some sort of join I have below table CREATE TABLE .( (50) NOT NULL, (50) NOT NULL, (50) NOT NULL, NOT NULL, NOT NULL ) ON .nLL	09-08-2009 12:05 PM Isaac Blank	4	49
Combine Multiple Rows single column into multiple column single row Here is one method for SQL Server 2000. Note performance will not be good on a large data set. SELECT vst_int_id, MAX(CASE WHEN rk = 1 THEN... rob muzzy	09-08-2009 11:59 AM Plamen Ratchev	8	37
regarding the results of the query hi all, i have a table matter which has following fields: MatterName MatterNumber BuisnessArea -- the primary key is MatterNumber which is unique,... Ekta	09-08-2009 11:53 AM Plamen Ratchev	3	33
STR() and rounding Hi everyone These round correctly (round up): select STR(0.055, 10, 2) select STR(0.00055, 10, 4) while this doesn't: select STR(0.0055, 10, 3) Is... John Winterbottom	09-08-2009 11:00 AM Sylvain Lafontaine	2	34
Trouble getting sub totals and averages from multiple rows in a table I have been working on a web app to help manage our bowling leagues. Here is a subset of tables I have that I am trying to report on. I've trimmed... Jim C	09-08-2009 10:31 AM Jim C	2	23
CREATE VIEW command Hi, i'm trying to use 'create view' command Very simple: create view V as select ename,job,sal from emp where job = 'CLERK' select * from V This is... haba9	09-07-2009 06:46 PM haba9	4	63
Aggregate Query takes an Excessive 90 seconds to run. Any Optimisation Ideas? ( 1 2 ) I have two tables, each of which contain ~52 million rows. The first table - Events - contains an event ID and the time when the event occurred.... Charles	09-07-2009 05:17 PM Charles	15	87
How to check that a date field is null and replace by blank value Hello there, I'm trying to query a date field (smalldatetime) with the following query: select recID, date1, ISNULL(date1,'') from table1. It... Ben	09-07-2009 01:31 PM Hugo Kornelis	4	33
Is there a built-in MS-SQL 2K5 functions to create SQL script ondatabase changes? Hi all, I am developing an application with VFP9. The back-end is Microsoft SQL Server 2005 Express Edition. I use ODBC as the connection and... Willianto	09-07-2009 10:27 AM Olaf Doschke	9	58
Help with count/grouping wanted I have an import table (tblImportTransaction) with CustomerNumber, PaymentDate and Amount. I need help with the SQL syntax for checking if the table... staffan eriksson	09-07-2009 04:51 AM Uri Dimant	2	40
Need a tool or program to transfer a database from 2005 to 2000 ( 1 2 ) Does anyone have a clean, proven method for transfering a database (or at least a list of tables) from sql server 2005 to 2000? I've been trying... BC	09-07-2009 03:44 AM Albert D. Kallal	11	56
Selecting intervals of time with no overlaps Dear all, In http://sqlblog.com/blogs/alexander_kuznetsov/archive/2009/03/08/storing-intervals-of-time-with-no-overlaps.aspx there is a very nice... Henrik Staun Poulsen	09-06-2009 03:36 PM Hugo Kornelis	9	65
Format SQL time type I have a view that has a time(0) data type. I would like to format it as "short time" like 3:30 PM. Is there a function for this in SQL Server... David C	09-06-2009 08:14 AM David C	8	44
Reformat Group membership table Environment is SQL 2000 SP4 I have a 3rd party application which exports ActiveDirectory group membership to a SQL table. Each day the export... reformat table	09-06-2009 02:06 AM Uri Dimant	3	32
login failed for user <username> hi sql server 2005 I've restored a database, and created a new login and user for the db. When I ran the website (which is based on the db) I get... Anton	09-05-2009 04:21 PM Stuart Ainsworth	2	35
SQL 2000 attempting to process nText data type I would like to use the substring function to split a cell, but the cell is a nText data type. The data in this string is over 500,000 characters... BBF	09-05-2009 04:23 AM Erland Sommarskog	2	39
Speed, storing images in database vs files on web app I have a gridview that displays 100-200 images and it's loading really fast when I use a webservice to pull the images from sql server. As long as I... Cindy Lee	09-05-2009 04:11 AM Erland Sommarskog	5	44
Object Row_Count Write To Excel Worksheet Can you help me create script that will cursor through all non-systems databases for table row counts using the script listed below. This script... Joe K.	09-05-2009 04:09 AM Erland Sommarskog	2	55
Sum Returns from Sub Query Hi, I have these 2 tables: SALES and COST SALES invoice# part# quantity 123 AA 10 124 ... Han	09-04-2009 05:13 PM Plamen Ratchev	2	51
Breaking Changes sql 2000 to sql 2005 Hello, I am looking for a concise list of TSQL breaking changes between sql server 2000 and 2005. I know we cannot use some join logic in the where... Scott Ocamb	09-04-2009 05:08 PM Erland Sommarskog	2	42
Build an SQL statement based on data in tables Hi, The database we have store the relationship between tables in our own user-defined tables. We have a zrelation table and a zrelationfield... bpdee	09-04-2009 01:05 PM TheSQLGuru	3	49
Does TRUNCATE TABLE "retroactively" delete? Hello: I have a stored procedure called "BPHISTPROC" that is a SELECT statement which pulls in data from several tables that are within three... SQL Programmer	09-04-2009 12:47 PM Tony Rogerson	5	40
Multiple recordsets from 2 CTE's Hi there! I have a bit of a challenge! I've created a procedure with 2 CTE's. The first one is called "SearchTable", and returns the result of... Tom Dan Massun	09-04-2009 12:46 PM Tom Dan Massun	4	37
Re: Can I put a CASE in a WHERE clause when a condition uses the I Just as Dan suggest, you can avoid the case statement on the where clause, and use the combination of and, or operator: SELECT Coalesce(M.ManagerId,... Lucas Kartawidjaja	09-04-2009 10:33 AM Lucas Kartawidjaja	0	36
Re: Can I put a CASE in a WHERE clause when a condition uses the INoperator? You have some fundamental mindset errors. 1) CASE is an expression and not a control flow statement. SQL is a declarative language, not a... --CELKO--	09-04-2009 10:23 AM --CELKO--	0	41
stuck on an sql problem Say I have two tables (please don't ask for DDL as there is none, this is an idea question) Say table "Items" holds a list of... Smokey Grindel	09-04-2009 08:45 AM Philipp Post	2	69

Page 66 of 1545

Forum Tools	Search this Forum
Mark This Forum Read View Parent Forum	Search this Forum : Advanced Search

	New posts		Hot thread with new posts
	No new posts		Hot thread with no new posts
	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