| Thread | Last Post | Replies |
|
| table object - create index | 31 Jul 2008 23:54 GMT | 3 |
declare @summaryEmp table (ID int, Code varchar(20), Paid money) create index idx_summaryEmp on @summaryEmp (Code)
|
| Joining on a text comparison | 31 Jul 2008 21:16 GMT | 12 |
I have 2 databases. In the 1st database foo1, I have a table - tfoo1 - which contains item numbers in the following format, e.g. 12345XYZ345 The second database foo2, item numbers are in the format e.g., XYZ I need to create a sql script that joins the two tables in separate
|
| bulk insert with negative sign after number | 31 Jul 2008 21:13 GMT | 35 |
I would like to use bulk insert with a text file that contains numbers both negative and positive (OK so what the big deal?). It turns out that the system delivering the text files appends the negative sign behind the number so it looks like this ('|' being my column delimiter):
|
| To NULL or not to NULL | 31 Jul 2008 20:42 GMT | 10 |
Purely theoretical while I'm finalising the design currently, so DDL isn't directly relevant unless requested. I'm currently writing a recipe database for an online game. Each recipe is assigned a level within its appropriate skill, at which it becomes
|
| Table Creation | 31 Jul 2008 20:29 GMT | 12 |
I have query like this Declare @var nvarchar(max) SET @var= 'SELECT
|
| Cannot delete table rows ?!? | 31 Jul 2008 19:26 GMT | 11 |
In management studio - get weird message: error source: Microsoft.Visual Studio.DataTools error message: 'row values updated or deleted do not make the row unique or alter multiple rows (5 rows)'
|
| Simple Recovery, Filegroup Backups | 31 Jul 2008 18:57 GMT | 1 |
-- If I have a database in Simple recovery mode, it is possible to BACKUP a FILEGROUP. However, it does not seem possible to RESTORE it. -- Is it ever possible to RESTORE it? I personally didn't think it was possible in Simple recovery mode, but then it doesn't make sense you ...
|
| Pick up top 1 record in each group | 31 Jul 2008 18:45 GMT | 3 |
In one table I try to pick up one record in each group and do not want to use cursor. This is a huge table with 100 millons of rows. I need performance. How can I do this? For example, the table like below. For each group I need pick one
|
| multiple CTE's with control flow | 31 Jul 2008 18:13 GMT | 8 |
I'm new to Sql server and i'm stuck with an issue with CTE. I have a situation where i have to use the following logic... If (Condition) begin
|
| 1:n Comma seperated list | 31 Jul 2008 17:33 GMT | 6 |
I have a normal 1:N relation. My child table is just a list of string values. I would like to have this list as a single column, comma seperated So that I woul have a single row, with my parent description, then a column with the child string valuse comma seperated.
|
| Sorting | 31 Jul 2008 17:23 GMT | 2 |
I have a sorting issue. I have a bunch of records, let's call them NOTES. Field NOTEID (which is data type INT in the database, but was converted to nvarchar in the stored procedure) is being sorted alphabetically
|
| Getting unique ids affected by a group by clause | 31 Jul 2008 17:23 GMT | 2 |
Let's say I have a customers table and an orders table. In the orders table, I have the customer name. So if I want to select the orders grouped by customer name where the customer has more than 3 orders, it's easy:
|
| adding a column to a hugh table | 31 Jul 2008 16:04 GMT | 5 |
I will need to add a column to a customers database table. The table has records more then two years old abd has approx. 10,000 records. I have never been able to add a column to a table with much less records. I will be doing so with SqlWb unless there is a better way. We ...
|
| SQL Injection Clean Up | 31 Jul 2008 15:29 GMT | 6 |
Hello we were recently hit w/ a SQL injection attack. If I gave the table name, column name and the text that we want removed from the fields would someone be able to come up with a stored procedure or query that I can run to clean this up. It wasn't to bad to clean up
|
| How to compare old and new values of primary key in update trigger? | 31 Jul 2008 14:37 GMT | 16 |
I know that you can compare old and new values of a non primary key column in an after update trigger the following way: select i.col 'newValue', d.col 'oldValue' from inserted i
|