SQLTeam.com | Weblogs | Forums

Welcome to the **Microsoft SQL Server** Forums at SQLTeam.com


#44

Can you try something for me?

It's seeing the @variable in your TSQL and thinking it is a user mention. After you get the error, can you try putting that into formatted text? If that works I'll see about updating the posting guidelines. If not, I'll file a bug.


#45

I found my error. In my topic, I did not use the tag code for the snippet I was writing.
This error message --> Sorry, new users can only mention 2 users in a post.
It was no relevant to me.

One more thing, why do I always receive email from this forum duplicated?

Thanks!
N.B.: Great looking web tool.


#46

I'm late to the party and offended that my post count and profile moniker didn't transfer! Fortunately I know people "on the inside"


#47

Forums look nice Graz, it's been a while.


#48

Everyone is probably offended their post count didn't transfer. I'm lazy. :yak:


#49

hey bill, any section for mssql pdw?


#50

Nothing specific at this point. Let's just put anything in the SSAS,SSRS category and we can tag it as PDW. I'll see abou updating the description.


#51

Hi Bill,

Nice work! It's good to see ravishing new look for SQLTeam, except post count.

What is the link for the old read-only sqlteam forums which where I can see my posts?

Thanks.


#52

Hey, great to hear from you. It should be at www.sqlteam.com/forums/.


#53

Thanks Bill.


#54

I can never find where the how to faq are.


#55

Dear Sir,
I need to get output in text file from mssql

This is the format which I have raised from website of ICEGATE EDI format
ICEGATE Header:
HREC^]ZZ^]^]ZZ^]^]^]^] ^]^]^]^]
Example:
HREC^]ZZ^]ABCD^]ZZ^]XYZ^]ICES1_5^]P^]^]COCHE01^]123456^]20071015^]1015

Pont 1 : When I open the Output in Notepad I get in this manner without any spaces in between
--------------------------------------------------Point 1------------------------------
HRECZZAAACF2188HZZINNSA1ICES1_5TSACHI011201512080959


Point 2 : When I open the Output in Word pad I get in this manner with spaces in between
--------------------------------------------------Point 2------------------------------
HREC ZZ AAACF2188H ZZ INNSA1 ICES1_5 T SACHI01 1 20151208 0959

Point 3 : When I open the Output in Notepad++ I get in this manner with GS where space shown ie Group Separater

How can I handle this via syntax in MSSQL


Moving a topic: Exporting to data file
#56

I'm unclear if you want to query a database and output that format to a file. If that's not the case, then please explain in more detail.

You can use SSIS, export wizard or bcp to get that output, just use ^] as the column terminator.

If you want to do it in TSQL, you would build it by concatenating ^] to each column.


#59

How can SQL Server instances be hidden?


#60

hey guys im having a problem with my query
select idmedicament,dateExpiration from stock where (SELECT DATEDIFF(day,dateExpiration,getdate()) FROM stock )>=21

but bring me this error below
Msg 512, Level 16, State 1, Line 13
Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.

please help me because is an academic project


#61

Hello guys. May anybody help me with MySQL website issues?

https://www.nonstopsigns.com

Thanks a lot for your help


#62

Looks nice!
Hopefully my post count will migrate and no one else's! :slight_smile: