Topics
Started by
Posts
Last post
I know this cannot happen ... but it does. At least for me! I have a table from a production databa…
5 replies
Hi there, I am fully aware of DATEADD and DATEDIFF functions. However, for something simple like ad…
2 replies
i have a table 'staff'... it already contains some 10-15 records now i want to add a new column Sta…
2 replies
OK - here goes... I've been messing about with this archival process for a couple of days now. Ide…
11 replies
I need to cast multiple fields to varchar - however, I won't know the field size or type in advance…
12 replies
Hi all, Can we get the event viewer event properties by using a query? Are there any extended s…
1 replies
I have a simple query select * from table1 where field1 = 'xxx' There is a clustered index on the P…
3 replies
I have archive table and a 'live' table with the same table struture. I have created a view with a …
3 replies
Hello all, Hope all of us know that DST Patch update will be on 4th November,07. Here my query is…
5 replies
Hi all, I have a problem with my Stored Procedure. It runs longtime. How can i create…
14 replies
Hello guys, Is there a way to declare TOP? something like this: DECLARE @Rows int SET @Rows = 100 s…
3 replies
Can anybody tell me how I can get this data into one row? Each account can have any number of Small…
3 replies
Hi experts, I have a task which sounds simple to me but as am new in this field i need you guys hel…
3 replies
How do you pass a datetime parameter to a stored procedure. Enclosing the date in single quotes fai…
3 replies
I am preparing a stored procedure to obtain some financial data. One of the data items is a 30 day…
8 replies
Viewing 15 topics - 3,736 through 3,750 (of 17,082 total)
You must be logged in to create new topics.