Topics
Started by
Posts
Last post
Hi, I have an excel spreadsheet which has location, name and DOB inthe rows. how can I split this s…
7 replies
Greetings: I have a nightly process that after pulling numerous data tables from another (dts) sour…
6 replies
Hey am new to UDF's and am looking over someone else code and i need to know whats going on with in…
7 replies
hi, If i had a table ORDERS and have few columns in it. Suppose there are 2 rows that have same d…
9 replies
declare @a decimal(38,20), @b decimal(38,20) select @a = 1.0000000000000000…
13 replies
Can anyone help me with this query. I have tables products and options. There is a third table, pro…
2 replies
Dear folks, We have got an issue and we can't work out. There is a table which own three tri…
3 replies
I have a table with a field that contains comma-delimited data. Here is a sample of two rows …
33 replies
Hi I have a value which I retrieve in a SQL query which is a Booking Date for system. In a later in…
20 replies
I have the following two tables: ID Type 1 Division 2 District …
3 replies
The following SQL returns the value 1 all the time: DECLARE @y INT SELECT @y = (SELECT COUNT(*)&n…
1 replies
Currently I have a stored procedure that queries data, loads it into a cursor, loops through it and…
7 replies
Part of my script runs: sp_detach_db @dbname, 'true' When the db is in use the message 'Cannot deta…
3 replies
hi, My Table contains the following structure: create table Delete_Dup_Records ( vid int, vName var…
5 replies
I'm having difficulty with finding a way to append the result sets of subqueries together in a perf…
4 replies
Viewing 15 topics - 7,741 through 7,755 (of 17,082 total)
You must be logged in to create new topics.