Hello, I am trying to query a database and return the information in a zpl (zebra printer language) string. I know the query and I know what the string needs to be but and having problems. Here's the goods (or in my case the bads): DECLARE @vchBrand varchar(20) DECLARE @vchFlav varchar(2...more >>

I apologise if I have selected the wrong group, and if I have please let me know as I am a newbie to this. I have put together the following SQL code in MS acess: SELECT T1.INTERVAL_START_DATETIME, T1.QTY, T1.S_PRICE, T1.Q)CLEARED, T1.M_Price FROM DATASOURCE.T1 T1 WHER...more >>

--I tried to submit this 20 minutes ago and cannot see it yet. I hope it is not a dupe. Hello, I am trying to query a database and return the information in a zpl (zebra printer language) string. I know the query and I know what the string needs to be but and having problems. Here's the ...more >>

ok i have an interface beign built and a requirement of this interface is to have a table that records tasks people do a requirement of these tasks that are stored in the database is that the name of the task must be unique each task is releated to a project so a project has many tasks but the u...more >>

Hi All, Sql Server 2005 SP2 I enabled logon triggers on server. Please see script for logon trigger below. Now i am seeing deadlock errors in error log. I enabled traceflag 1222 on server and can see all the deadlock events in error log. As per my interpretation all the deadlocks are ...more >>

Hi, can anybody give me some ideas why a UNION ALL would significantly slow down running 2 views? I am working on this for a couple of days now and I am running out of ideas. I have looked at the execution plans of the individual views and the major work seems to be done clustered index scan...more >>

I am very new to C#. I need to create a Windows form that will read a SQL table and populate a treeview. I can connect to the DB, create the dataadapter, populate a data set. The problem is how to use the dataset to populate a treeview. I have looked at a few examples but none use a datas...more >>

Hi I have two tables, one temporary inserted from a bulk insert with over 100000 user records, another one used by main application that also has over 100000 records, the cross reference fields between two tables are fields called RefKey which is a the field with char value, since there are ...more >>

Hi, up front I know that I can not use Order by in a subquery with UNION, is there a wok around? need to get last item, something like: Select top 1 myItems from etc... where xyz = 'idjnwlsl' order by myItemsID desc UNION Select top 1 myItems from etc... where xy...more >>

Hi, I am trying to find a script that can go through a given database and show you the following: Tables with 80+ % reads and 20-% writes Tables with 50/50+- Read/Writes Tables with 80+% writes and 20-% reads. Essentially I want to run my index defrags/rebuild on all these tables ...more >>

I've got a query that I want to pull back all records before the end of the month, whatever month I choose. Here is the pertinent part: WHERE (dbo.COM_TAP_ACCOUNT_CONTRACT_HISTORY.ACTIVITY_ON < DATEADD(day, 1, @end_date)) I'm plugging in variables of 8/31/07 for the @end_date, and I eve...more >>

Hi, can anybody give me some ideas why a UNION ALL would significantly slow down running 2 views? I am working on this for a couple of days now and I am running out of ideas. I have looked at the execution plans of the individual views and the major work seems to be done clustered index scans...more >>

Hello, I have 3 tables: [A] > Aid (PK) [B] > BId (PK) [C] > CId (PK), TargetId (FK) TargetId should be related to both Aid and Bid. Can I do this? Records created in C can be related to records in A or in B and TargetId can be either a Aid or Bid? Thanks, Miguel ...more >>

Does t-sql evaluate the right side of an OR if the left side is true ? For example : ( Employees.StartDateTime IS NULL ) OR ( Employees.StartDateTime > CAST('1/1/2007' AS DATETIME) ...more >>

Hello. Can anyone help with this one? I've written an app that queries data on two linked servers (sql server 2000). The stored procedure runs fine when I 'exec' it in management studio, but it times out when launched from VB2005. The funny thing is it worked last week - I'm just not sure wh...more >>

Our shop is all SS 2000 SP4. But I need to study for the new MCITP exam for Sql Server 2005. On my work computer I have both the 2000 and 2005 client tools. So I've got the client tools to help me study for the exam. But how can get an actual 2005 server on my work computer to help study f...more >>

Hello, I have a data modelling question. I have a table called tblTransaction with a primary key (identity field) of TransactionId. On this table I have two fields AssetClassCode and AssetCode thus :- TransactionId: 1 AssetClassCode: A AssetCode: MMM TransactionId: 2 AssetClassCode: A...more >>

I've been scouring google and google groups for help with my problem but haven't found it. I'm hoping that you can help me. I have a SQL Server 2000, SP4 with a linked server pointing to a SQL Server 2005 (most recent SP). On the SQL Server 2005 I have a table called "note": CREATE TABLE [...more >>

Hi, I have been asked to creata a table in SQL 2000 Db with an auto generating primary key field which comprises of Date, Time and a unique random number. Could anyone please tell me which is the correct way to achieve this? Many thanks Jim...more >>

how can i view contents of c drive in SQL Server 2005. Is there a extended sp that i can use similar to xp_fixeddrive that gives free space on server drives? thanks. ...more >>

Hi all, I'm new to sql programming but guessing that this is an old issue so looking for some advice please. I have a table setup as follows - MyTable id (varchar(16)) person_id (varchar(16)) network_id (varchar(16)) network_code (varchar(16)) Now I want to replicate a set of codes ...more >>

Hi, We've been using the catalog as part of our search engine for a year now. We use freetexttable to search for keywords and it is fine until now. For some reason the 'freetexttable' is inconsistent. I tried this query and I got a lot of rows. select * from tb_catalog where conten...more >>

sql 2000 i want to create a flattened out association table that looks something like this anscestorid descendentid 1 2 1 3 1 4 1 5 3 4 3 5 4 5 here is the current table i want to flatten out create t...more >>

I have tested with this: --======================================================== SET ANSI_NULLS ON --740 rows select * from client where client_addr_2 IS NULL --0 rows select * from client where client_addr_2=NULL --0 rows select * from client where client_addr_2 <> NULL --========...more >>

Does anyone know why SQL 2000 sorts the two strings: CONCEPT 5% CONCEPT 'A' 1. CONCEPT 5% 2. CONCEPT 'A' while SQL 2005 does the reverse? Both servers and databases are set to SQL_Latin1_General_CP1_CI_AS. Possible bug? Thanks Kelly...more >>

Dear all, I am design a sql database which can generate random weeekly menu from the recipes available in the database table,should I use newid() to do that? for example, to randomly return 7 dinner recipes and 7 deserts recipes from the recipe tables? thanks !!!...more >>

Hi Group, I need to solve a probles with a queiry that is quite simple really, but because of the large (not THAT large though) number of rows it just takes too long to execute. The platform is SQL Server 2000 and I need this query to run in 10-20 seconds...if possible... So here is the pro...more >>

Hi how to remove the option of password MUST_CHANGE , after the creation login ? is there and syn. can be used with alter login ? Thanks. Khaled ...more >>

Hello, I nedd to log schema changes (automatically, without user interaction) on all objects in database. The best solution would be posibility to auto save script like generated via "Generate change script" button from SQL Server Management Console. I was investigating DDL triggers, but ...more >>

I created a really simple table from which I want to return 9 random records, 3 where a flag is true, 6 where it's not. I've tried to do this with a UNION but I get virtually the same records each time. It never returns results where the ID is greater than 12; yet when I run these queries separa...more >>